Forum Discussion

JohnBaker's avatar
JohnBaker
Qrew Member
5 years ago

Relating records

I have an application I am building that uses the average weather data for the 8760 hours in a year.  The weather bin data is a parent record.  



 I have external data that has a time stamp with several records within the hours of the year.  I have created a formula field that identifies what hours in the year the records belong to on the child record.  


This is all external data from our Building Automation systems and machines in the form of CSVs that gets imported into the tables.  
I am trying to relate this data so I can average my external records within the specific hour of the year.  I have  60 records per hour of the year.  Any ideas on how to get to the desired result?  Any assistance would be greatly appreciated.

------------------------------
John Baker
------------------------------
Data import and export
Relationships
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    I  but you were saying that you have or would like to have a relationship where one The weather bin data is a parent record of many Child Weather reading entries.   The child records know what hour of the year they belong to. But presumably these readings are going to cross over an annual year boundary.  

    The parent Weatherby in record will need to be set where there is a key field in the format  YYYY-HHHH for example the current year is  2021 and the hour of the year around today is about hour 672.  so 2021-672.

    So you will need to use excel for example to load up a parent record table with 8,760 records per year in that syntax for say 10 years ahead.  Then you would said that to be the key field of the table and relate them to the child records. 

    Child record would have a formula field to calculate the YYYY-HHHHH to use in the right side of the relationship.

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