The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

IF statement for field condition with URL Encoding options

posted Apr 23, 2020 12:17:59 PM

Topic Labels: Formulas

0 1903 3

Hi Community,

Appreciate if someone can help comment about this statement as its not working. Thanks.

IF(
{Event Type} = ‘Partner Tech Talk’,
CONCATENATE(“URL/YYYYYYYYYY”,"?prefill_id=",ENCODE_URL_COMPONENT({Feedback Key}),
CONCATENATE(“URL/XXXXXXXXXX”,"?prefill_id=",ENCODE_URL_COMPONENT({Feedback Key})
)

NOTE: I concealed actual URLs - assuming URL/YYYYYY works. In other words CONCATENATE statement works by itself. However, when trying to create IF statement picking the right URL based on Event Type field this doesn’t work.

3 Replies 3

I tried replicating this but it gave me a link everytime!

Formula (it’s just using dumb test date but it outputted a link everytime):

IF(test3="late",CONCATENATE("airtable.com/","?prefill_id=",ENCODE_URL_COMPONENT({Field 12})),CONCATENATE("airtable.com/?","prefill_id=",ENCODE_URL_COMPONENT({Field 11})))

See Image 2020-04-24 at 9.54.26 AM

Could you share with dummy data?

Thanks Aron,

So my syntax is correct then? Event Type field is a multiple choice. Did I use correct quotes ’ ’ vs. " "?

The only difference in your code segment is string logic vs. field object I think.

Aron thanks for the rapid response! I figured out… I was missing couple of closed brackets :slightly_smiling_face: It works now