Feb 21, 2023 08:46 PM
Hello and thank you for your help in advance,
My question: I have my main table "Schedule" where we create all new appointments coming in. Now, I want to know how many appointments we actually created per day. Another words, how many new records created for a certain day. Do you think it is possible to create this automation and if yes, what are your thoughts about it.
I was thinking of creating another new table where all the data would be collected, lets say the name for this new table is "Counter" where we have first field "Date" and then next field is the field for the actual number of new records for each given day.
I have no idea how to calculate new records and input this date in some field.
Feb 21, 2023 10:03 PM
Hm, if I were you I'd:
1. Create a "Created time" field
2. Create an automation that ran once a day, and its actions would be:
2a. "Find records" in the data table that were created yesterday
2b. "Create record" in the "Counter" table, with two pieces of data:
- Date and time of the trigger event
- Number of found records
You could also use a repeating group action to link all of the found records to that one new record in the "Counter" table too
Feb 26, 2023 06:56 PM
Thank you for your reply, I tried to do everything you suggested but for some reason nothing is happening, I will show my screenshots,
4. New Table "Counter 2.0" created
Feb 26, 2023 06:58 PM
I forgot 1 more screenshot
Feb 26, 2023 07:33 PM
You don't need the conditional I think. Also, you need to populate the following two fields:
Feel free to DM me an invite link to your base and I can do this for you