- andrewrodieAsked on April 21, 2014 at 12:23 PM
Is there a way to get the first three characters of one field into another field based on a condition?
example, If Field 1 is "filled" then the left three characters of the field1 entry are automatically filled into Field2 (restricted field, user can fill in).
I have a drop down list of 107 items in Field1, prefixed with three numbers (ex., 001 Eggs, 002 Bananas, 003 Carrots).
After the user selects somthings from Field1 like "001 Eggs", Field2 is automatically populated with "002".
I hope I don't have to do 107 conditional logic based entries for this if Field1 = "001 Eggs", then input "001" into field2 automatically.
- KadeJMAnswered on April 21, 2014 at 02:51 PM
As far as I know it's possible to grab the data that is populated for a whole field. But I'm not so sure that this was possible or not and I thought we had a similar request via a thread awhile back, but so far I am unable to locate any relation to it since then.
The closest to that that I think we could come up with as of right now is with this solution here http://form.jotform.us/form/41105269868158. However, the downside to it is that it uses calculated conditional logic which I know you said you weren't really wanting to do since there would be 107 rules. You could offset it with 00 since that would get stripped as you'll note and you can additionally use the Duplicate Condition option to speed this up.