We have an existing Monday board and submission form. New entries go into a “new entry” table. Once approved, they are moved into basically an “in process” table on the same board.
We have about 100 rows already in our “in process” table and those rows have a couple subitems each from when we first designed out this board.
However, today we decided that we wanted to start automating about 9 subitems to be generated every time someone submits a form. That’s not a problem for all the “NEW” rows that go into our “new entry” table. The problem is, backfilling all the existing rows in the “in process” table with all these new subitems.
Is there a way to somehow backfill all the all the “in process” rows with the subitems structure? Not worried about the data itself (we don’t have it yet), rather it’s trying to avoid having to go into each row in the “in process” table and create all these new 9 subitems over and over and over.
Is there a way to do this somehow? I tried to export the “new entry” table into excel, do a bunch of cut and past of the new subitem column names, then re-import, that didn’t work out so well. Monday didn’t seem to know how to import the table and retain the subitem hierarchy. (Or, maybe it was user error???)
Anyway, any help will be GREATLY appreciated!