Keeping airtable synced automatically. Below is an airtable structure that pulls via airtable script automation an affinity list, populates all the data throughout the list, populates the org data, people data and interlinks all records together directly via Affinity API. This can be adapted easily to populate Opprotunity and other objects from the affinity API. Feel free to share and contribute back.
- 'Name' type of Single line text (should be default left side)
- 'entity_id' type of #number
- 'person_ids_json' type of Single line text