Duplcating part of a recored using an automation or form or button?

Hi @Robert_Croydon

I would take the time to reconsider this :winking_face: It isn’t that difficult to create new linked tables based on your already existing data.

Is there an easy guide somewhere on splitting a table into 2 parts and doing this?

You can have a shared view with a button that opens an Airtable form prefilled with the name, address, and email of the original record. The non-collaborator can then fill in the date, amount, and other fields in the form.

The you can use the “Prefilled Forms Url” part of the Ready-Made Formulas app to build the URL.

Allowing non-collaborators to edit the record after it is created is a bit more complex, but possible.

On the other hand, I also recommend looking into creating a separate [Customer] table and using a linked record field. Make a copy of your base to play around with until you are sure you know what you are doing.

1. In that copy, decide which field uniquely identifies a customer. Often it is the email address.
2. Convert the email field to a linked record field in a new table. Airtable will create the table and populate it with the emails.
3. Create lookup fields in the new table to bring the name, address, etc. over to the [Customers] table.
4. Convert the lookup fields to single line text fields so they are no longer calculated.
5. Go back to the original table and convert the name and address fields into lookup fields (or delete them.)

Note that creating a customers table can have other implications on your workflows, especially on how your data is entered. Make sure you understand the ramifications of the new data structure before making the changes in your production base.