Now that we have the ability within the platform to add rows to other tables, can anyone think of a way schedule this action (add rows to other table)? For example: Every three months, add a row to this table.
Not with the new action, however it can be achieved using the API, either from an external source (Google Script), or a Report-Webhook.
Had a feeling it would need to be a webhook. Thanks @Marc_Dillon
Seems a Feature request should be made to include Data Change actions in the Report behaviors! I have had a couple occasions where it could have been useful.
Iโm sure there is a reason it wasnโt initially included, but if developers are working around it to make it happen anywayโฆmight as well โnip it in the budโ!
I think I solved the problem with this. I created an action that added rows to table, then I used the report function for a single record to trigger a change data, I then pointed it to the action I created to add rows. The trick was trying working with the โIf this is trueโ condition. For that I created a virtual column in my table that met the requirements to trigger the report.
User | Count |
---|---|
40 | |
36 | |
32 | |
23 | |
16 |