Using Relative Dates and App level variables
Hi all: I have what I think is a simple problem and I probably have even solved it in the past but would like some help advancing my skills. I have field that counts records when a particular date...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendI personally dislike Application Variables as they are too obscure and no one but the Admin can see them or change them. So IO will suggest a way I would suggest.
Make a new table called Fiscal Year Dates.
Make two date fields here for [Fiscal Year Start] and [Fiscal Year End].
Create 1 record and then lock down permissions so no one, even the Admin can Add or Delete. Decide which Roles are allowed to Modify.
The record will be Record ID# = 1.
Make a relationships to your detail record so 1 Fiscal Year Dates has many Details. Let it create a relationships field for Related Fiscal Year Date, but rename it after creating the relationship to be called [Link to Fiscal Year Dates (=1)]. Then change the field type to be a formula Numeric and the formula will be
1
That will connect to Record ID# = 1 in the dates table.
Lookup those two date fields and use them in your formula.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Make a new table called Fiscal Year Dates.
Make two date fields here for [Fiscal Year Start] and [Fiscal Year End].
Create 1 record and then lock down permissions so no one, even the Admin can Add or Delete. Decide which Roles are allowed to Modify.
The record will be Record ID# = 1.
Make a relationships to your detail record so 1 Fiscal Year Dates has many Details. Let it create a relationships field for Related Fiscal Year Date, but rename it after creating the relationship to be called [Link to Fiscal Year Dates (=1)]. Then change the field type to be a formula Numeric and the formula will be
1
That will connect to Record ID# = 1 in the dates table.
Lookup those two date fields and use them in your formula.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- mark;
Thanks, yes, I agree that app level variables are nebulous and not easy to use. I am assuming that I could change record 1 to a different fiscal year when necessary based on what you described above?
------------------------------
Melissa Freel
------------------------------- MarkShnier__YouYes, that is the whole point of exposing it on record in a table. That way you can give everyone visibility but control who has edit ability.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
