Date and Time Field from Child to Parent

Question

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 filter for data that I have brought over to the parent table from the child table.&nbsp;Ex. team members work a project. I need to summarize the # of project per team member for a specific period of time. but I would like to pick the time frame in the parent table.Is this possible?thank you in advance.​------------------------------Zana S------------------------------

markshnier__you · Answer

It's not so clear from the question, but I will assume that
One Team member Has Many Projects.

You want to enter a date range on the Team Member table (ie two fields called [Analysis Star] and [Analysis End] and you want to know how may projects they worked on during that period.

Is that the question? if so, do the child projects record have a start and stop date on them?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

zanaskenderi1 · Answer

Hi,yes that is correct one team member has many projects. in the child table for Projects I do have a completed date and time and that is what I want to bring over. I want to be able to report projects by time frame for the team member, but seems I can only summarize the fields by time frame, I have not found a way to bring everything over and then create reporting in the parents table so I can filter by timeframe.hope this makes sense.thank you------------------------------Zana S------------------------------

markshnier__you · Answer

I suggest that you turn your thinking upside down. Create a summary report on the child projects table and you will be able to group it by team member say down the page and then across the top you can have Date by week project completed and in the Cells will be the number of projects.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

zanaskenderi1 · Answer

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.&nbsp;This is the formula I am using but it is limiting to the time frame of the fields I am bringing over.&nbsp;((([# 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 · Answer

If 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 ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

Date and Time Field from Child to Parent

8 Replies