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 ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendI 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
------------------------------
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
------------------------------