Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Comparing two arrays to check if they contain an equal record

678 1
Showing results for 
Search instead for 
Did you mean: 

I have a table with two “linked record” fields, connected to another table on my base.
I need to compare the arrays in these two columns, and show a specific value in a third field (formula) if these two arrays contain the same record.
Is there a way to compare two arrays using a formula?
Again, I don’t want to check if the whole array is equal to the other array, but - to check if the two arrays contain an equal record.
Thanks :slightly_smiling_face:

1 Reply 1

Welcome to the Airtable community!

In general, this requires scripting.

If you will always have a only a small handful of linked records in one field, and the primary fields are very simple, it is theoretically possible with a massive formula. But even if your data is simple enough to use such a formula, it would be very fragile.