How to automate a new table from new data input

[chloecreatedthi]

Hi 😊 I'm trying to create an inventory system that works a bit like a CMS. I want to be able to create an automation when if I add a new item in Table 1, another table is created (duplicating fields from existing tables) and then if possible, linking the new table in a column by the new item in table 1. 

To make it easier to visualise, Table 1 is like a directory, and then Table 2 is a like a log of that item. Currently I have to: 1 - add a new item in table 1, create a SKU number for it, then duplicate table 2 (which has different field values) to create a new table for the new item. I then copy and paste this new table into a cell on table 1 that coincides with that same item.

Screenshots attached that show Table 1 with item catalogue, and then Table 2 with item 1 listed. You'll also see the duplicate tables of table 2 along the top, and the links to these in table1. Thanks in advance!

[TheTimeSavingCo]

I think you might need to use scripting for that: https://airtable.com/developers/web/api/create-table

I'm curious though, may I know why we can't use views for this?

[PedroCerrano]

When you add a new item in Table 1, are you doing that manually or through a form?

One thing I've learned from using Airtable is to leverage its strengths and not fight against it. If I understand what you want to do, the automation and scripting are simple if you add items through forms.

[Sachin_191]

I can help streamline your Airtable inventory system by automating the creation of new tables and linking them to your directory. We'll set up an automation that triggers when a new item is added to Table 1. This will automatically generate a new Table 2 duplicate, ensuring it inherits the required fields, and then link this new table back to the corresponding item in Table 1. This will not only save you time but also eliminate manual errors.