I would like to create an automation that when a record in table-1 is created, a record in table-2 is automatically generated. And the key field in table-1 is copied over to Key field in table-2. I hope this is a fairly easy automation. I appreciate your help.
This is possible with automations, but is there a specific reason for why you want to do this? Most people who think they want this actually just need to create separate views in a single Airtable table.