Re: Reset Value every day?

Paul, did you try this?  I see that my Siri dictation was not the best so I have edited it below.

Building on what Don posted above, you can have a relationship where a table is loaded up with all the days for the next 10 years or so.  Make a relationship back to ticket with a formula date field equal to your date field. 

Note that it may not let you use the [Date Created] field as a basis for the formula for the date so you may need an automation or a form rule to populate the date field with today.  Or i guess just a date field which defauts to Today would be good enough.

You can then have a summary field to total the number of tickets for that day look that up down to the ticket and then create a snapshot value to freeze the value. That Snapchat field will then be sequential for each day. 

So Ticket #1 for a given day will get a snapshot value of 1
So Ticket #2 for a given day will get a snapshot value of 2
So Ticket #3 for a given day will get a snapshot value of 3

Here is some help on setting up snapshot fields.
https://help.quickbase.com/user-assistance/setting_up_snapshot_fields.html

​

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------