Forum Discussion

Qrew Member

3 years ago

Same button takes some one to a different URL based upon the state.

I am adding a Formula URL button to my form. When someone clicks on the button I would like it to take them a particular website based on the state. For Example: If someone is in the form for the...

Formula and functions

JeffPeterson1

Qrew Captain

3 years ago

You could do it like this in your Formula URL field (This is the hard coded way that Mark mentions above):

Case([State],
"AL", "www.alabama.gov",
"AR", "www.arkansas.gov",
"AZ", "www.arizona.gov
)

And of course you'd need to list out all of the states and the URLs there, but this would work.

------------------------------
Jeff Peterson
------------------------------