I need someone to create a script which basically does what the Create child records does but in reverse. So, I need to create a parent record from child records.
The workflow would be as follows:
We upload child records as CSV or XLSX into Airtable
The child records will have a column with an identifier which indirectly links them together
Based on this identifier and some other information, we will need to create a parent record and link the child records to it.
The scope should be pretty simple. We will also need to move over some more data from the child records, but it will always be the same data in all children, so taking it from one single child is sufficient. The only thing is to loop all children into the same parent creation so we do not create too many parents.
If that is something you feel able to do, please reach out to me.