How to automate a new table from new data input
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!
