Help

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.

Blank Linked record into conditional formula

Topic Labels: Formulas
Solved
Jump to Solution
1540 1
cancel
Showing results for 
Search instead for 
Did you mean: 
David_Ohanessia
6 - Interface Innovator
6 - Interface Innovator

Hello to the community,

And happy 2022 for everyone who reads this topic :winking_face:

Maybe I’m the only one to face this situation but I’ve created a pretty simple formula field which should provide a simple 1/0 boolean answer based on 3 conditions. One of those conditions is if one linked field to another table (Order_ID) is still blank/empty.

IF(AND({Payment Status}!=“paid”,Order_ID=BLANK(),REGEX_MATCH(Email, “(\W|^)[\w.\-]{0,25}@[A-Za-z0-9.-]+\.[A-Za-z]{2,}(\W|$)”)=1),1,0)

Guess what ? It doesn’t work.

I’ve also tested the NOT(Order_ID) based on what I’ve read and it doesn’t work either BUT it works on a separate formula cell (see below the second line) :

Capture d’écran 2022-01-10 à 14.16.47

Other 2 conditions work perfectly. I assume this is due to the structure of a linked record by itself but I’m not sure.

Thank you for your help.
Best,
Y

1 Solution

Accepted Solutions
Williams_Innova
7 - App Architect
7 - App Architect

Hi @David_Ohanessian,

This is interesting and not sure why it wouldn’t work. My first thought for a work around, as clunky as it may sound, is to have a formula field that creates a text string from the link, so in this case something like…

CONCATENATE(Order_ID)

…would make “rectdhowUFxWXYovM” and then use the conditional field to see if the text string is empty (Order_ID="") or not.

Like I said, not the cleanest approach but I believe it would work.

Thanks,
Chris

See Solution in Thread

1 Reply 1
Williams_Innova
7 - App Architect
7 - App Architect

Hi @David_Ohanessian,

This is interesting and not sure why it wouldn’t work. My first thought for a work around, as clunky as it may sound, is to have a formula field that creates a text string from the link, so in this case something like…

CONCATENATE(Order_ID)

…would make “rectdhowUFxWXYovM” and then use the conditional field to see if the text string is empty (Order_ID="") or not.

Like I said, not the cleanest approach but I believe it would work.

Thanks,
Chris