Substring widget delay in updating

  • spaceandtime
    Asked on March 21, 2019 at 3:09 PM

    In my form I calculate a unique reference number by concatenating:

    - first 4 letters of client name

    - first 4 letters of development 

    - date

    - random number

    "Campaign Reference" calculates once client name & Development fields are filled.

    I've been testing what happens if the user changes the client name dropdown after it calculates and on the first time nothing changes.  then next change of dropdown it updates the first 4 characters of campaign reference BUT it's always 1 click behind! try changing the client name dropdown a few times and watch what happens to first 4 of campaign reference

  • jonathan
    Replied on March 21, 2019 at 5:43 PM

    I was able to see the issue you described when I test on your form.

    1553204525zzz 2019 03 22 05 Screenshot 10

    1553204545zzz 2019 03 22 05 Screenshot 21


    Allow me more time to test and check how to fix. I'll be back shortly.



  • jonathan
    Replied on March 21, 2019 at 6:38 PM

    I was able to figured out the fix. Can you please test my form first https://www.jotform.com/90796954637981

    The Campaign Reference field value should change on real time with the Client Name dropdown list changed also.

    You can clone my test form also to review it on your Form Builder.

    The changes I did:

    1. I added 2 textbox fields to get the value of the Substring widget into a separate container using Conditions

    1553207780zzz 2019 03 22 06 Screenshot 10

    1553207811zzz 2019 03 22 06 Screenshot 21


    2. Updated the calculation condition for the field Campaign Reference to use the 2 textbox fields instead.

    1553207862zzz 2019 03 22 06 Screenshot 32


    I hope this help. Please let us know if this will not work for you.

  • spaceandtime
    Replied on March 22, 2019 at 12:42 PM

    Great, that fixed it thank you