Currently, it is not possible within the AppSheet platform to schedule automated data changes - which includes adding rows to tables.
However, you may have some options. I can think of two ways you can work around this.
-
Add the row in your datasource directly. You can likely use some sort of scripting to perform the same task whether its in a sheet based system or a database. This is the next best option.
-
Create a workflow that simulates the automated adding of a row. You can create the trigger criteria for it to run on a specific date and create the row if it hasnโt been created yet based on some user activity - preferably something you KNOW will happen everyday. The downside of this approach is that a user has to physically use the app for the row to get added. There is also concern of multiple users triggering the workflow at the same time. But I think anything after the first will just silently fail. Of course, you want to build into the trigger detection that the row has been added AND you want to make that window tight. Meaning when the workflow runs to add the row, you want the next trigger of the workflow to detect that the row is being added ASAP. I would do this by setting a flag immediately once the workflow is triggered.
I hope this gives you some ideas!!
LinkedIn
Twitter
