Can a workflow field support a LOGICAL OR and differentiate between two JSON entries?

1

I am trying to build a workflow that is intended to process data from three different JotForms that differ only slightly from one another. Forms 2 and 3 were clones of form 1, with slightly modified field labels and options.

QUESTION: can I use a single workflow step (‘add row to Sheet’) that evaluates more than one step depending upon the form submitted? The example I had in mind is below. But, it returns ‘Undefined OR’ in the Sheet cell (where the missing input falls).

In the example below only one the two values would ever be populated. Any suggestions?

{{steps.parse_json.$return_value.q60_typeA60}} or {{steps.parse_json.$return_value.q78_typeA78}}

2

Try {{steps.parse_json.$return_value.q60_typeA60 || steps.parse_json.$return_value.q78_typeA78}}

3

My initial tests with your recommendation worked like a dream! I’ll give some more iterations, but want to THANK YOU so much.

1 Like