Hello Airtable Community,
I have two Long-Text Fields associated with the same record.
I would like to make a comparison between both Long-Text Fields, which allows me to:
I appreciate any leads on this, and thank you in advance for your help.
If the texts are identical, I assume you need a third field indicating so. A simple field comparison is all that is needed, and a formula can handle this easily.
We have a few automations in our On2Air Actions app for Airtable that can accomplish what you need (without having to code.)
Depending on exactly what you need, here are some options:
Field Diff Log - It will keep a running log of changes to any field within a Long Text Field and track changes made to fields.
Items in One List But Not in Others - It will extract values from one field that are not found in multiple other fields and add it to another field. This is useful for searching fields and finding any values that are not present and adding it to another field.
Unique Arrays – Search 1 or multiple fields for unique data and store the unique values in another field. Useful for filtering out duplicates.