Skip to main content
Question

Weekly summary field

  • October 6, 2021
  • 0 replies
  • 73 views
Hello,
I have one table called "Tests" which has one record for each Test and some results. One numeric result field is called "Efficiency." There is a field "Type" which is multiple-choice and can be "A", "B", "C", and each Test record also has a "Date Created," of course. 

I have a separate table called "Parts." This has two fields called "Ref Type" and "Ref Date." I want to have a field in "Parts" which shows the average Efficiency for ALL Tests where Test "Type" = Part "Ref Type" and where Test "Date Created" = "Ref Date." 

This seems straightforward but I am struggling with how to create this. I'm happy to have an intermediate table for the summary records, but the "Ref Type" and "Ref Date" fields in a summary record aren't available to select for matching criteria in the summary field. 

Please let me know if you have any suggestions. Thank you!
Graeme

------------------------------
Graeme
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
Can you describe your tables in their relationships. Which is the one in which is the many for each relationship?

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
MarkShnierYou
Forum|alt.badge.img+24
It sounds to me that all you need to do is look up this field  Part's "Ref Date" 

down to testrs.

Then have a checkbox formula field for 

FirstDayOfWeek([test date]) = FirstDayOfWeek([Part's Ref Date])

and limit the average in the summary field to where that  checkbox is true.  

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement