topic Re: Multiple URL in single field in App Development

Multiple URL in single field

tango — Wed, 01 Mar 2023 10:42:18 GMT

Hi,

I am creating a URL for a specific field in Straight table through add link and then pasting the URL.

I have a requirement wherein I am suppose to represent 3 different links for that specific field like : If I have a field called ID so if(ID =1,'https://abc.com',

If(ID =2,'https://qwe.com,'https://asd.com'))

Can I add multiple links like this by using If?

Any advise will be great help!

Re: Multiple URL in single field

Or — Wed, 01 Mar 2023 10:48:34 GMT

I don't see why not, assuming each cell has a single URL associated with it.

Re: Multiple URL in single field

tango — Wed, 01 Mar 2023 10:56:45 GMT

Yes, but IF doesnot work in this. Any other way ?

Re: Multiple URL in single field

Or — Wed, 01 Mar 2023 11:16:23 GMT

If() does indeed work this way:

=if(Dim2=1,'http://google.com','http://bing.com')

Re: Multiple URL in single field

tango — Wed, 01 Mar 2023 12:26:52 GMT

So 3 different links for 3 IDs but same field.

Re: Multiple URL in single field

Or — Wed, 01 Mar 2023 12:42:05 GMT

That doesn't look like a valid if() statement.

Re: Multiple URL in single field

tango — Wed, 01 Mar 2023 12:51:57 GMT

Sorry , I corrected it ,Thanks. That works.

But what in case if I have string values

Can you please help me with this , like using wildmatch and then the links

Re: Multiple URL in single field

Or — Wed, 01 Mar 2023 12:56:36 GMT

Same thing, just a different If() statement. It doesn't matter if the ID is numeric or string, and it doesn't matter if you use ID = 1 or Match(ID,1).

Re: Multiple URL in single field

tango — Wed, 01 Mar 2023 13:27:28 GMT

Actually I have something like this

ABC124

ABC345

BCV111

BCV567

QWERTY900

QWERTY220

so for

Re: Multiple URL in single field

tango — Wed, 01 Mar 2023 13:27:42 GMT

Got it sorted
=If(WildMatch(ID,'QW*'),'https://www.yahoo.com',
if(WildMatch(ID,'A*'),'https://www.google.com','wikipedia.com'))