Help

Can I use IF or SWITCH to return different URL's?

Solved
Jump to Solution
1283 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Katelynn_Straw1
5 - Automation Enthusiast
5 - Automation Enthusiast

I am trying to link a few different drop box URL’s to our table. The case use would be if designer X is selected from the multi select drop down, return URL(A), if designer XX is selected, return URL(B), if designer XXX is selected, return URL© and so on. I have a field with the multi select options and I have a field where I want the corresponding URL’s to populate once the designer is selected.

Is this possible?

1 Solution

Accepted Solutions
Kamille_Parks
16 - Uranus
16 - Uranus

Yes, its possible. You could do this with either SWITCH() or IF(), but SWITCH() is more efficient:

SWITCH({Multiple Select Field Name}, 'Designer A', 'URL A', 'Designer B', 'URL B', 'Designer C', 'URL C', ...)

See Solution in Thread

3 Replies 3
Kamille_Parks
16 - Uranus
16 - Uranus

Yes, its possible. You could do this with either SWITCH() or IF(), but SWITCH() is more efficient:

SWITCH({Multiple Select Field Name}, 'Designer A', 'URL A', 'Designer B', 'URL B', 'Designer C', 'URL C', ...)

So ‘URL A’ is the actual URL? And it works as a URL?

That worked! Thanks a bunch! I was not doing the correct punctuation. So thankful for knowledgeable and generous people here!