-
spaceandtimeAsked 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
-
jonathanReplied on March 21, 2019 at 5:43 PM
I was able to see the issue you described when I test on your form.
Allow me more time to test and check how to fix. I'll be back shortly.
-
jonathanReplied 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
2. Updated the calculation condition for the field Campaign Reference to use the 2 textbox fields instead.
I hope this help. Please let us know if this will not work for you.
-
spaceandtimeReplied on March 22, 2019 at 12:42 PM
Great, that fixed it thank you