-
saman110Asked on March 12, 2019 at 8:26 AM
Hi,
I have a form with 3 identical pages. Each page contains an input table. My goal is to automatically copy all the data to the 2nd and 3rd input tables when the first one is filled. I have tried the solution provided on the link below:
It works fine but there is an issue when the data contains some characters. Using that method which utilizes "calculate a field's value" feature, would only copy the numbers not characters. For example, let's say the data on the first input table is "LP1234". It only copies "1234" to the 2nd input table. How can we fix this? Here is the link to my form:
https://form.jotform.me/90702807728461
Thanks for your help in advance.
Nima
-
jonathanReplied on March 12, 2019 at 10:16 AM
The Calculation can detect only 2 types of data -- String and Number
If the data in example is "LP1234" you should set it to String type as it contains non numeric data.
You did not mention which calculation condition it was that have the issue, so I was not able to immediately find it on your form. But to give you the idea please see the screenshot image below.
You can see that if its A-Z (brownish color), it is String/text data.
If 0-9 (black color), it is Number data.