Skip to main content

Compare same field in linked records

  • October 17, 2024
  • 2 replies
  • 29 views
S
Forum|alt.badge.img+3

Hi all,

I have two tables: Projects and Tasks. Each task has one or more municipalities. What I'd like to do is check if all the municipalities in each task associated with a particular project are the same. I initially thought I could do this with a rollup and ARRAYUNIQUE(values) and a comparison of the Municipality field with the rolled up field. As you can see below "Glenville, Rotterdam" is a match, but that is not what I am looking for. I only want a match if all the fields are exactly the same.

Any ideas on how to achieve this?

 

2 replies

TheTimeSavingCo
Forum|alt.badge.img+31

Hmm, so only the second record matches, is that right?  Could you provide screenshots of how the data's set up in the original base so that I can try to recreate your setup and figure out a solution for you?  If you could provide an example base that'd be ideal

Adam, Airtable Consultant - thetimesaving.company
S
Forum|alt.badge.img+3
  • s_t_mac81
  • Author
  • New Participant
  • October 22, 2024

Thank you for the response. I realized the solution as I was typing out an explanation. I had some "yes" and some "no." I just needed to roll up that "yes", "no" field and reject any that had at least one "no." Thank you again. 

Terms & ConditionsAccessibility statement