# Chronological log of activities

**URL:** https://community.glideapps.com/t/chronological-log-of-activities/80368
**Category:** Ask for Help
**Created:** [February 26, 2025, 3:33pm UTC](https://community.glideapps.com/t/chronological-log-of-activities/80368 "2025-02-26T15:33:24Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![FloMo](https://avatars.discourse-cdn.com/v4/letter/f/f19dbf/32.png) [@FloMo](https://community.glideapps.com/u/FloMo)
#### Post date: [February 26, 2025, 3:33pm UTC](https://community.glideapps.com/t/chronological-log-of-activities/80368/1 "2025-02-26T15:33:24Z")

</div>

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!

---

<div class="post-metadata">

### Author: ![Mariusz](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mariusz/32/89415_2.png) [@Mariusz](https://community.glideapps.com/u/Mariusz)
#### Post date: [February 26, 2025, 5:27pm UTC](https://community.glideapps.com/t/chronological-log-of-activities/80368/2 "2025-02-26T17:27:08Z")

</div>

This one should be easy for you to build.

You need 2 tables.

1. Live stock general info with row IDs
2. Data logs with live stock row IDs assigned to them.

Then you’ll always be filtering records from data log table on the basis of current screen (live stock) row ID.

Hope that helps 🙂

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [February 27, 2025, 1:41am UTC](https://community.glideapps.com/t/chronological-log-of-activities/80368/3 "2025-02-27T01:41:16Z")

</div>

You can also use a mutliple relation. Then use that relation to power the chart/collection.

---

<div class="post-metadata">

### Author: ![FloMo](https://avatars.discourse-cdn.com/v4/letter/f/f19dbf/32.png) [@FloMo](https://community.glideapps.com/u/FloMo)
#### Post date: [February 28, 2025, 1:16pm UTC](https://community.glideapps.com/t/chronological-log-of-activities/80368/4 "2025-02-28T13:16:27Z")

</div>

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)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/c/dca986e6055059a4df56ad558d381b0422d88d6c.jpeg)  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/d/6d8e9f3a08c9471d955b32a48b9b04c698282001.jpeg)

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

---

<div class="post-metadata">

### Author: ![Mariusz](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mariusz/32/89415_2.png) [@Mariusz](https://community.glideapps.com/u/Mariusz)
#### Post date: [February 28, 2025, 2:02pm UTC](https://community.glideapps.com/t/chronological-log-of-activities/80368/5 "2025-02-28T14:02:39Z")

</div>

Use multiple relation, value lookup and then single value getting the last added value from the array

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/9/a9f138e8b3057187286e3996b75a690c25226d75.png)

---

<div class="post-metadata">

### Author: ![FloMo](https://avatars.discourse-cdn.com/v4/letter/f/f19dbf/32.png) [@FloMo](https://community.glideapps.com/u/FloMo)
#### Post date: [March 2, 2025, 8:00am UTC](https://community.glideapps.com/t/chronological-log-of-activities/80368/6 "2025-03-02T08:00:37Z")

</div>

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.

---

<div class="post-metadata">

### Author: ![Mariusz](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mariusz/32/89415_2.png) [@Mariusz](https://community.glideapps.com/u/Mariusz)
#### Post date: [March 3, 2025, 11:24pm UTC](https://community.glideapps.com/t/chronological-log-of-activities/80368/7 "2025-03-03T23:24:59Z")

</div>

You’re welcome 🙂
