Help

Re: Formula to check if a certain record exists

3276 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Mario_G
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi everyone,
I have a table that has a list of people. There’s a field called “parents”.
I want to create a view on that table that shows only people without children. To do that, I’d use a formula that checks if the person is present on the “parents” field of any record. If the result is false, it means the person is without children.
The problem is that I can’t figure out how formulas can use values from other records. I’m proficient in SQL and to do that I would use the clause "WHERE NOT EXISTS ".

Does anyone have an idea on how to do that?

10 Replies 10
Mario_G
5 - Automation Enthusiast
5 - Automation Enthusiast

I’ve an interesting follow-up: Display a list of linked fields