-
paddycockingAsked on January 7, 2020 at 1:28 PM
Field 1: dropdown choice e.g. EVE64, EXE65, etc...
Field 2: dropdown choice e.g. Monday, Tuesday, etc...
Field 3: Derive [field 3] from 1 & 2 that cannot be entered manually
Using Conditions, IF [field 1] is [filled] AND, IF [field 2] is [filled] AND, ALL fields are matched - DO
COPY MULTIPLE FIELD VALUES [field 1] AND [field 2] to SUMMARY [field 3]
Result example in [field 3] is EVE64Monday
However I only want the first letter of field 2 to return EVE64M
can this be done please?
thank you
-
jonathanReplied on January 7, 2020 at 4:29 PM
You can do it using Calculations + the Substring widget.
link: https://www.jotform.com/widgets/substring
You can extract specified char/string from the field data using the Substring widget and use the update/calculate condition to transfer the data into another field.