Date and Time Field from Child to Parent
Hi, I am trying to get a date and time field from a child to a parent. I tried Maximum value, but it is not doing what I need it to do. Essentially I need the date and time field to be used as a fi...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendIf your calculations are all for children which are "during the previous week"., the you can make a summary field which counts children where a date field is During the Previous 1 week(s).
.
------------------------------
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
------------------------------
Hi,
That is exactly what I did, but I was trying to give my management team the ability to pull the totals at will for any dates without having to do a bunch of summary fields for specific time periods.
If it is not possible, understood, was just trying to find a workaround.
thank you so much for your help.
------------------------------
Zana S
------------------------------
That is exactly what I did, but I was trying to give my management team the ability to pull the totals at will for any dates without having to do a bunch of summary fields for specific time periods.
If it is not possible, understood, was just trying to find a workaround.
thank you so much for your help.
------------------------------
Zana S
------------------------------
- Zana,
If I understand your goal correctly, I think this can be done with the new Dashboards. You would create a report with the amount (currency) field and whatever other fields you want, add the report to the Dashboard, then add a global filter.
Mark also has a creative way using a 'User Focus' table, but for this you would want to work with him offline and have him consult. I highly recommend his consulting services!
------------------------------
Mike Tamoush
------------------------------ - MarkShnier__You
OK, if you want to set a global variable you can create a table called Admin Date with one record in it. Set the date there.
That record will be a record ID #1
make a field on your projects table called Link to a date tangle as a formula numeric with Formula of
1
make a relationship where one admin date has many projects based on that formula 1. field
Look up the Admin Date
use it in a formula or summary field using that date vs the Project Date
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
