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
MarkShnier__You
Qrew Legend
Qrew LegendYou 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
------------------------------
------------------------------
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
------------------------------
------------------------------
Paul Peterson
------------------------------
- MarkShnier__YouOK. So what is in the reference field on the tickets table. Is there data populated there? Are you using a formula? What is the formula?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------ - The reference is currently the default, Related Day and there is no data being populated in the Schedules table.
------------------------------
Paul Peterson
------------------------------ - MarkShnier__YouOK, so you need to "get" relationships.
If you run a report of that reference field for [Related Date] it will be blank if it's just a data entry field because no one has populated it. So you need to populate it by using a formula or by defaulting it Today in the field settings and then updating all existing records to the date of the record using say grid edit.
I don't know how many existing records you have to know if grid edit is practical.
Do you have a ticket date field, or do you just have the native [Date Created] date / time field.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------ - Did you receive the email I sent this morning?
------------------------------
Paul Peterson
------------------------------ - MarkShnier__YouNo, Sorry, I do not see any email from you recently. Please use the email in my signature line below.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------