Using data bind, if Field1 is found on the global list, then Field2 is auto-populated, but if not, the user is expected to fill out Field3. However, this creates 2 process data (from Field2 and Field3) diminishing our reporting abilities. As an example, if Fields 2 and 3 refer to a Customer’s name, in every report there will be 2 columns called ‘Customer name’, depending on whether the customer was found on the global list or not, and obtaining business reports from this is problematic.
Any recommendation on how to solve this is welcome.
Currently, even though Field2 is auto-populated we are asking users to fill out Field3 anyway, in order to have a single ‘Customer Name’ column the reports.
Can you not just map Field3 to the single process data?
If Field1 is found on the global list, then Field2 and Field 3 are auto-populated (you can hide field 3 if this needs not to eb shown to user).
If Field2 is not found on the global list, then Field3 is expected to be filled by user (you can hide field 2)
Hi Kevin, thanks for your response. However, I tried doing this without success.
Just to make sure I understood right, did you mean setting the ‘Value In’ of Field 3 to bring the process data generated by Field 2? I think this didn’t work because all fields are within the same action, I’m assuming Field 2 only generates process data when the action is submitted. (and so, if Fields 2 and 3 were in different actions I’m sure Field 3 would default to Field 2’s value)