Hello Glide community. Please help me think through how I can approach this.
I am building a livestock record keeping app. Farmers create an ID and onboard their cattle. I need to record chronological data for each head of cattle for when the farmer adds to the record so that I can plot parameters over time. Like weight gain, or vaccination schedule.
All ideas welcome. Thanx a mil!
This one should be easy for you to build.
You need 2 tables.
Then you’ll always be filtering records from data log table on the basis of current screen (live stock) row ID.
Hope that helps 
You can also use a mutliple relation. Then use that relation to power the chart/collection.
Thank you so much @Mariusz and @ThinhDinh
I went about it the 2 table way. It works GREAT!
List with cattle onboarding info with row IDs and a next number generator to create LivestockIDs. Including the baseline parameters like baseline weight etc. I set a submit action that copies the LivestockID and the baseline information to the data log table. New information is added chronologically in that table (SUPER!). All data entries are dated. So I can plot a growth path for cattle (don’t mind the dodgy date)
Now my issue is the highlighted number in the collection is the baseline weight. I need it to be most current weight, which is added as part of the chrinological data entry. In other words, when a user saves the data entry, it should update the onboarding information to the latest parameters.
Thanx again for your valuable thoughts
Use multiple relation, value lookup and then single value getting the last added value from the array
Perfect!! I changed both the image and the weight to the current image and weight as opposed to the onboarding image and weight.
Thank you @Mariusz It’s great learning from you.
You’re welcome 
