Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

IF statement for field condition with URL Encoding options

Topic Labels: Formulas
705 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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