Help

I need to count New Records per Day

Topic Labels: Automations
2047 4
cancel
Showing results for 
Search instead for 
Did you mean: 
bedjik
6 - Interface Innovator
6 - Interface Innovator

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.

Any thoughts?

4 Replies 4

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

Thank you for your reply, I tried to do everything you suggested but for some reason nothing is happening, I will show my screenshots, 

1. Automation1.png

2. Trigger

Trigger.png

3. Action 

Action 1.pngAction 2.png

4. New Table "Counter 2.0" created

Table.png

bedjik
6 - Interface Innovator
6 - Interface Innovator

I forgot 1 more screenshot

Action 2 Step 2.png

You don't need the conditional I think.  Also, you need to populate the following two fields: 

Screenshot 2023-02-27 at 11.32.23 AM.png
Feel free to DM me an invite link to your base and I can do this for you