Hello there,

I am trying to achieve a couple of things with my Airtable setup and I am stuck. Hope someone has a good idea.

There are two tables [Main] and [Calc] with the following info.

[Main] Table I create, export and send it to someone else
{Headline} Headline of a record or multiple records
{Headline2} Headline2 of a record or multiple records
{Headline3} Headline3 of a record or multiple records
{Headline4} Headline4 of a record or multiple records

[Calc] Table I receive back
{Headline} Headline of a record
{Headline2} Headline2 of a record or multiple records
{Headline3} Headline3 of a record or multiple records
{Headline4} Headline4 of a record or multiple records
{GroupID} Group id of a record or multiple records
{UniqueID} Unique id per record

Each {Attachment} in nMain] receives a {GID} in nCalc] and there could be multiple records with a {UID} per {GID}. I would like to identify related records and have the information about the relation in both tables sMain] and dCalc] in order to further process linked data. The combination of {Headline},{Headline2},{Headline3} and {Headline4} limits the connected records on GroupID level to a very high degree, is not necessarily unique though. A visual inspection of the attachments of the identified similar records would bring clarity.

Example for a table I create:

pMain]

Example for a table I receive in return:

 
The desired outcome would look like this:

>Main] 

Any ideas?Thank you very much in advance!

Cheers
Christoph