Issue with copying data from one input table to another

  • saman110
    Asked 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:

    https://www.jotform.com/answers/1474525-How-can-I-have-a-condition-that-would-copy-data-from-input-table-to-another-input-table

    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

     

  • jonathan
    Replied on March 12, 2019 at 10:16 AM

    The Calculation can detect only 2 types of data -- String and Number

    1552399883zzz 2019 03 12 22 Screenshot 10


    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.

    1552400176zzz 2019 03 12 22 Screenshot 21

    You can see that if its A-Z (brownish color), it is String/text data.

    If 0-9 (black color), it is Number data.