I have a Formula Field that creates a custom URL from my airtable. In the past, if a piece of data was missing in the airtable that was referenced in the Formula field … the data would just be empty. Now though, it’s throwing an error unless all of the data is populated. Does anyone have experience with this? Can you do something like =if(isnull, “noData”) in the formula?
Solved
Formula Field for Custom URL has changed behaviors
+2Best answer by Kamille_Parks11
Thank you for the information. I don’t think I did it correctly, as it’s still kicking back an error. Here is the custom URL:
'https://form.jotform.com/xxxxxx?’
& ‘brand’ & ‘=’ & ({Brand})
& ‘&email’ & ‘=’ & ({Email})
& ‘&name’ & ‘=’ & ENCODE_URL_COMPONENT({Name})
& ‘&last4’ & ‘=’ & ENCODE_URL_COMPONENT(IF{Last 4 of payment}=Blank(),“noData”)
& ‘&lastPayment’ & ‘=’ & ENCODE_URL_COMPONENT({Payment Type})
& ‘&loyaltyNumber’ & ‘=’ & ENCODE_URL_COMPONENT({Loyalty Number})
& ‘&ccparecordid’ & ‘=’ & ENCODE_URL_COMPONENT({RecordID})
I need to test everything after and including the bolded rows for a blank.
Looking at your bolded line, notice how you have missing parentheses for the IF statement and you aren’t attempting to fill in the Last 4 if there is a value to insert.
IF({Last 4 of payment}, {Last 4 of payment}, "noData")
+27IF({Field Name}, x)
^ replace x with your computed url formula. If the referenced field is blank then the url will not appear. Airtable formulas do not start with an equal sign.
+2IF({Field Name}, x)
^ replace x with your computed url formula. If the referenced field is blank then the url will not appear. Airtable formulas do not start with an equal sign.
Thank you for the information. I don’t think I did it correctly, as it’s still kicking back an error. Here is the custom URL:
'https://form.jotform.com/xxxxxx?’
& ‘brand’ & ‘=’ & ({Brand})
& ‘&email’ & ‘=’ & ({Email})
& ‘&name’ & ‘=’ & ENCODE_URL_COMPONENT({Name})
& ‘&last4’ & ‘=’ & ENCODE_URL_COMPONENT(IF{Last 4 of payment}=Blank(),“noData”)
& ‘&lastPayment’ & ‘=’ & ENCODE_URL_COMPONENT({Payment Type})
& ‘&loyaltyNumber’ & ‘=’ & ENCODE_URL_COMPONENT({Loyalty Number})
& ‘&ccparecordid’ & ‘=’ & ENCODE_URL_COMPONENT({RecordID})
I need to test everything after and including the bolded rows for a blank.
+27Thank you for the information. I don’t think I did it correctly, as it’s still kicking back an error. Here is the custom URL:
'https://form.jotform.com/xxxxxx?’
& ‘brand’ & ‘=’ & ({Brand})
& ‘&email’ & ‘=’ & ({Email})
& ‘&name’ & ‘=’ & ENCODE_URL_COMPONENT({Name})
& ‘&last4’ & ‘=’ & ENCODE_URL_COMPONENT(IF{Last 4 of payment}=Blank(),“noData”)
& ‘&lastPayment’ & ‘=’ & ENCODE_URL_COMPONENT({Payment Type})
& ‘&loyaltyNumber’ & ‘=’ & ENCODE_URL_COMPONENT({Loyalty Number})
& ‘&ccparecordid’ & ‘=’ & ENCODE_URL_COMPONENT({RecordID})
I need to test everything after and including the bolded rows for a blank.
Looking at your bolded line, notice how you have missing parentheses for the IF statement and you aren’t attempting to fill in the Last 4 if there is a value to insert.
IF({Last 4 of payment}, {Last 4 of payment}, "noData")
Looking at your bolded line, notice how you have missing parentheses for the IF statement and you aren’t attempting to fill in the Last 4 if there is a value to insert.
IF({Last 4 of payment}, {Last 4 of payment}, "noData")
Wonderful! That’s really helpful! Worked Perfect!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.