I have a Google Sheet that hosts numerous sheets (tabs) within it. The sheets are being created through JotForm so they can appear any time as new forms are created. What I’m trying to figure out:
- How to watch for new sheets to be added and then create a new Coda table for each (or is this even a best practice? Each sheet is for a different use case).
- Would it be better to create a single table and then use the name of the Sheet to update a title field in a “catch-all” Coda table? This way I can connect the different row entries to the correct form?