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
thank you Mark, the challenge I am having is that I need to make a formula field that adds the project per team member in addition to 2 other variables. I have not been able to make a formula field in the child table that can add the number records in the child table plus the other variables in one field.
I tried Summary formulas in the reporting, but I cannot get all the fields to cooperate. but it works in the parent table.
This is the formula I am using but it is limiting to the time frame of the fields I am bringing over.
((([# of Chart Previous Week]+([Extensive Logged Report Types Previous Week]*0.1)+([Total # of No Info/Search Fee Previous Week]/[Quota Multiplier]))/[Previous Week Duration in Seconds])*3600)
------------------------------
Zana S
------------------------------
I tried Summary formulas in the reporting, but I cannot get all the fields to cooperate. but it works in the parent table.
This is the formula I am using but it is limiting to the time frame of the fields I am bringing over.
((([# of Chart Previous Week]+([Extensive Logged Report Types Previous Week]*0.1)+([Total # of No Info/Search Fee Previous Week]/[Quota Multiplier]))/[Previous Week Duration in Seconds])*3600)
------------------------------
Zana S
------------------------------
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
------------------------------- 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
------------------------------
