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

[Katelynn_Straw1]

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?

[Kamille_Parks · Accepted solution]

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', ...)

[Katelynn_Straw1]

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

[Katelynn_Straw1]

Kamille_Parks:

SWITCH({Multiple Select Field Name}, ‘Designer A’, ‘URL A’, ‘Designer B’, ‘URL B’, ‘Designer C’, ‘URL C’, …)

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