I have a database of contacts and I would like to keep a record of the activities or meetings in which they participate (I don't know if in each activity I should adjust the form for this action). But it would only be to add this new column, not to create duplicates of people each time they attend an activity.
Thanksss!!!
You would create a new table called “activity log”, and you would create a “linked record” field that links to your contacts table.
Airtable will automatically create the reverse linked record field in the contacts table that links to the activity log.
So each contact will only exist once, but they will be linked to one or more activities in the activity log table.
Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.