I'm struggling to figure out how to do the following and would love some help!
I've built a base that tracks registered and onboarded people in a "People" table. "Registered" and "Onboarded" are options in a single select field. The end result of what I'm trying to build is a simple graph that has day on the X axis and a record count on the Y axis. I want to have daily snapshots of total number of registered and onboarded people as my Y Axis. I want to automate this somehow.
I think I should make a new table with dates as the primary field and then one field that is the total registered people for the day and another field that is total onboarded people for the day.
But how can I automate this so I don't have to check and update daily?
I figured automation would work, but the options are so limited with a time as a trigger.
I'm thinking I might need a script that runs daily?
Can someone help me out here?
Thank you!
-Taylor
Best answer by Dimitris_Goudis
Hi Dmitris,
Thanks for your reply. I understand how to make the graphs either in an interface or table/extension. Also, I don't want to get an email, I want it to write the days values to a field so I can build a chart based on those values.
The main issue is the automation. I tried having an automation with a time-based trigger, but I ran into the issue that it seems time based triggers don't let you use data besides trigger time. I would think the automation would look like:
Trigger = at a time Action = Update a record - (some way of seeing record count and updating the value in a number field)
___________________
but when trying to build that I got stuck at the Action. (See screenshot)
What am I missing? is there another way to accomplish this?
1. Use interfaces to create graph. The graph will show both subsets per day and you can filter it to exclude some dates and make comparisons also
2. Use Airtable extension that works in a quite similar way in the same table
3. Add an automation to trigger every day that will send you an email with the total numbers. To do this add a trigger as a scheduled time, two find actions to find both subsets and then on email text add the length of those findings
1. Use interfaces to create graph. The graph will show both subsets per day and you can filter it to exclude some dates and make comparisons also
2. Use Airtable extension that works in a quite similar way in the same table
3. Add an automation to trigger every day that will send you an email with the total numbers. To do this add a trigger as a scheduled time, two find actions to find both subsets and then on email text add the length of those findings
Would any of those work for you?
Thanks
Yours sincerely, Dimitris Goudis
Hi Dmitris,
Thanks for your reply. I understand how to make the graphs either in an interface or table/extension. Also, I don't want to get an email, I want it to write the days values to a field so I can build a chart based on those values.
The main issue is the automation. I tried having an automation with a time-based trigger, but I ran into the issue that it seems time based triggers don't let you use data besides trigger time. I would think the automation would look like:
Trigger = at a time Action = Update a record - (some way of seeing record count and updating the value in a number field)
___________________
but when trying to build that I got stuck at the Action. (See screenshot)
What am I missing? is there another way to accomplish this?
Thanks for your reply. I understand how to make the graphs either in an interface or table/extension. Also, I don't want to get an email, I want it to write the days values to a field so I can build a chart based on those values.
The main issue is the automation. I tried having an automation with a time-based trigger, but I ran into the issue that it seems time based triggers don't let you use data besides trigger time. I would think the automation would look like:
Trigger = at a time Action = Update a record - (some way of seeing record count and updating the value in a number field)
___________________
but when trying to build that I got stuck at the Action. (See screenshot)
What am I missing? is there another way to accomplish this?
