Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to set a variable to a formula (i.e., beginning with an equal sign) via an action trigger.
I was able to successfully set a variable to call the =OSUser function by setting the action to assign its value as ='=OSUser()'
However, I can't seem to make this "style" of a formula setting work if the formula itself has quotes in it.
Example:
='=''test'''
Any suggestions???
Use chr(34) like the following:
='='&chr(34)&'test'&chr(34)
Regards,
Thank you very much. FYI, I needed to use chr(39) instead of 34 but it worked great!!!