Hi, I’m trying to make a script that counts the number of records based on the date created field. I don’t need any other information, just a count and would prefer not to have to make a view since my base is already cluttered. Any help would be greatly appreciated!
This thread has some scripts for counting the records in a table. However, if you want to count only records that meet a condition, you will have to add that logic in. These scripts were also not designed for automation scripts, so the output would also need to be adjusted for an automation.
Counting bases by date created can be a little tricky because the created time field actually has a time as well as a date, even if you do not display it.
You will need to get the value of the date field by using record.getCellValue().