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?
Best answer by Kamille_Parks11
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', ...)
+27Yes, 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', ...)
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?
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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
