I have an event app that has an event based on the calendar date, so for example, in the month of October, each day would be an event - that would require its own unique list. How do I create an action that everytime a “New List” is added, a new google sheet tab is created and ALSO a new separate google sheet that can be sent to the venue.
Because if we want to send the venue a list on Google sheet that is dynamic and is changing constantly with names, I cannot send them the MASTER SHEET with all the other information
Not sure I completely follow, but I feel like a google script would be required here. Write a script that creates a new sheet tab and a new sheet whenever a value in your app is changed, which can trigger the script.
I trust that the new sheet tab and new sheet wouldn’t wouldn’t be connected to the app at all?
But this entire data goes into a Guest List sheet tab on the MASTER Google Sheet, but I cannot send the Master sheet to the particular venue, I want to control and restrict the data sent so I need to create an entire new Google sheet and send it
Would this new tab be part of your app, or accessible by the app in some way? I ask because for every new sheet tab (table), you would have to build new screens, components, actions, to display data from that table. If that’s the case, it’s going to be a nightmare because you’ll constantly be in the glide builder making changes to your app.
So are you saying here that anything your app uses is in the Guest List table, but you still want to create another table as well as a separate Google sheet? Am I understanding that data will ultimately be duplicated 3 times?
Do the Venue Owners have access to your App?
If yes, couldn’t you save all the duplication and just present them with a filtered list through the App?
If no, could you just export a filtered list from the App and send that?
Either way, all this duplication really smells of bad design.
No, the venue owners or their admins or front desk staff won’t have access to the app. Hence it just needs to be a URL (A google sheet preferably) that can be sent to the generic inbox, and whoever is working that day gets to read the list — which by the way, has names constantly being added till the start of the event.
I think what I would do is just keep one master sheet that is connected to the App, and then use an automation tool such as Make to create and update the Event specific Google Sheets. It wouldn’t be too difficult to setup, you’d just need to trigger a webhook to Make with every change, and then you could build logic within a Make scenario to either add to an existing Google Sheet, or create a new one.
The other option (as Jeff originally suggested) would be to use Apps Script to create and update the Event specific sheets as new data is added to your master sheet.
But I feel that Make would be a simpler solution, depending on how proficient you are with Apps Script. You could also trigger emails from Make to send the links to your venue owners.
I am not too familiar with Apps Script but will take a look at that.
Thank you for all your help. Assuming there will be a significant delay time when the button is clicked and the trigger hook makes all this happen
