Reset Value every day?
I am trying to create a ticket number that seems very basic, but part of it is not working well. The ticket structure is simple, the last two digits of the year, the two digit month, two digit day p...
Forum Discussion
I finally cleared enough other tasks out of the way and had a change to return to this. I don't think I explained my objective clearly enough. I am not looking to keep track of the tickets created each day. The objective is to assign a number to each ticket created that day Starting with 0001 and incrementing for each successive ticket and resetting to 0001 the next morning.
------------------------------
Paul Peterson
------------------------------
------------------------------
Paul Peterson
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendPaul, did you try this? I see that my Siri dictation was not the best so I have edited it below.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
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
------------------------------
- Yes, I tried that, and believe I am trying to create the summary field incorrectly. All of my attempts have ended up with a 0 in the summary field.
------------------------------
Paul Peterson
------------------------------- MarkShnier__YouYou need to set the Key field of the 10 years dates table to be the Date field and not Record ID#
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- The date is already the key:
------------------------------
Paul Peterson
------------------------------