I have what I thought would be an easy option in my macro. Typically I will have a formula Type="XX" and using a text box input, The action tool will replace the "XX" with the text box value. Is there a way to do that with a radio button. I have tried if [#1] then "High" else "Low" endif within the update value with formula. This is not working. I believe there must be an easy option to update the value. I only have two radio buttons labeled 'High" (#1) and "Low" (#2).
Solved! Go to Solution.
Hi @tmonroe
Could you elaborate on "This is not working"? The error message you receive will help diagnose the specific issue. One possible issue would be the quote wrapping in the Action expression. Try this:
IF [#1] THEN '"High"'
ELSEIF [#2] THEN '"Low"'
ELSE '"XX"' ENDIF
Notice that I placed an extra set of single quotes around the value to use. This is because we need the expression to be "High" and the single quotes are used to escape the value (including quotes) from the IF statement.
Check out the attached workflow for an example of this in action and an alternative interface option that uses a Drop Down tool.
Thanks for the input. I did try adding the single quotes around the data, but still not working. When I say it is not working, the initial "XX" is coming out as the value of the field. This is the action that I have.
In the Action configuration, select the next line down that says "expression - value = "XX"". That way the formula you entered will update the expression value and you should be good.
Thank you. That worked. I originally had that but i kept getting an error. I believe the double quotes within the single quotes was my issue. Thanks again.