Hi,
I'm struggling with the action tool to allow the user to update the "default value" of a SWITCH function containing an embedded Regex_Replace function (see attached workflow used as an example).
I would like to allow the user to modify the default value by entering its own text string but when using the update value with formula (action tool), the field in the Regex_Replace function is not recognized ....
Thanks for your help.
Emmanuel
Solved! Go to Solution.
the switch has to have a comparison... I put IsNull(regex.....) to validate the consistency...
the way you are putting it only with the regex without comparing with anything it will give an error even in a simple formula...
Dear @geraldo ,
Thanks for your advice but if I include IsNull(regex...) then I'll get Null values for my Switch function .... I'm not sure to understand your point ...
Anyway, in the meantime I could find the solution by checking the "replace a specific string" option in the Action tool. I've attached the modified workflow.
Best,
Emmanuel
User | Count |
---|---|
106 | |
82 | |
70 | |
54 | |
40 |