This involves three applications:
1. Job Sites application (master app of realm which connects to all other apps)
2. Inspection application (various inspection forms)
3. Scorecard application (aggregation application which connects to all other apps and pulls in key data for monthly/quarterly/annual reporting)
Job Sites have a one-to-many relationship with tables in Inspections. Job Sites have a one-to-many relationship with tables in the Scorecards.
I’m almost complete building a scorecard application that will pull data via summary fields from multiple applications. I’m trying to find a way to let the user set a period via two date fields in a Scorecard record which can then be used as filters in one of the aforementioned summary field.There are 12 ‘metrics’ that will be reported on and all have values somewhere in a Quick Base application, and all will have a parent Job Site, as will each Scorecard record.
I attached an image that I created that shows the summary field and the date fields that I would like to use. THANKS!