Help

Comparing two arrays to check if they contain an equal record

1674 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Michal_Yechieli
4 - Data Explorer
4 - Data Explorer

Hi,
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.