How can I do to duplicate fields from a table to another ?

​@Carcasonne 

That is actually not the proper way to setup your database system. Setting up your database system like that will cause you an endless amount of problems in the long run.

The proper way to setup your database would be to keep all of your books in the same table, and then create a single-select field where you can choose each book’s status of being “New” or not.

Then, you would use filters to just see the books that you want to see at any given time.

Hope this helps!

If you have a budget and you’d like to hire the best Airtable consultant to help you with this or anything else that is Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Thanks for your answer ! It help me à lot. This is for a scolar homework.

As ​@ScottWorld mentioned, this is not the right design approach in most cases.

However, in some situations, you might need to validate information coming in from a form before putting that into the main table.

For example, in your case, if you want to add only a unique new book into the “Books” table, you need to check if a book exists or not in the Books table before you insert that Book into “Books”. In this situation, your form will first populate the “New Books” table with whatever information is coming in.

After that, you will trigger an Automation that will check if the Book with the same name already exists in the main “Books” table or not. If no, then only you will create a new record in the “Books” table with values you received in “New Books” table.

So basically, you can use Automations to copy information from one record to another or even one record from a table to another record in some other table.

Yes, and another fantastic way of checking for duplicates before entering a new record into Airtable is to use Fillout’s forms with their duplicate checking capabilities.

The cool thing about using Fillout for this is that Fillout PREVENTS the record from ever going into Airtable if it’s a duplicate, so no automations are necessary and no extra tables are necessary in Airtable.

And Fillout even lets people update Airtable records with a form, if you need non-Airtable users to edit Airtable records that already exist.

Hope this helps!

If you have a budget and you’d like to hire the best Airtable consultant to help you with this or anything else that is Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld