Skip to main content

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

  • April 12, 2026
  • 2 replies
  • 33 views

Forum|alt.badge.img

Hello,

i want to know if is possible to copy automatically fields from a table New Books to anther table Books.

They will have the same fields. 

The table Books contents all the existing books on a library and the table New books, all newly purchased books.  A form in softr will be filled with new books and it will be showed in table Books. 

 

 

2 replies

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • April 12, 2026

@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


Forum|alt.badge.img
  • Author
  • New Participant
  • April 12, 2026

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