# Multiple Entries for timestamps

**URL:** https://community.glideapps.com/t/multiple-entries-for-timestamps/38198
**Category:** Ask for Help
**Created:** [February 6, 2022, 10:29pm UTC](https://community.glideapps.com/t/multiple-entries-for-timestamps/38198 "2022-02-06T22:29:00Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![heyitsjorbs](https://avatars.discourse-cdn.com/v4/letter/h/35a633/32.png) [@heyitsjorbs](https://community.glideapps.com/u/heyitsjorbs)
#### Post date: [February 6, 2022, 10:29pm UTC](https://community.glideapps.com/t/multiple-entries-for-timestamps/38198/1 "2022-02-06T22:29:00Z")

</div>

Hi glide community.  
I’ve got a lawn care business app where id like to punch a timestamp when I complete a lawn and would like to keep a summary log for each clients. I’ve accomplished a single timestamp function but am struggling to find a way to log multiple timestamps and view those timestamps for the associated client.

Im not sure if i maybe need to make a new “Timestamp” table to accomplish the multiple entries and filter after? Any help would be appreciated.

 ![glide2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/4/94570f7c20a980d2bb84e5d342408e7c6dac5c06.png)

 ![glide1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/2/32bbabfd5493f32ef0a6999a387aa2eb92fed477.png)

---

<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 6, 2022, 11:45pm UTC](https://community.glideapps.com/t/multiple-entries-for-timestamps/38198/2 "2022-02-06T23:45:35Z")

</div>

> [@heyitsjorbs](#):
>
> Im not sure if i maybe need to make a new “Timestamp” table to accomplish the multiple entries and filter after? Any help would be appreciated.

Yeah, I think this is the way to go. You log a new row for each “click” of the button, taking the timestamp and some unique info (saying the user’s email, the lawn’s ID, etc.), then create a relation to show the list of related logs.

---

<div class="post-metadata">

### Author: ![Carl\_Johnson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carl_johnson/32/75656_2.png) [@Carl\_Johnson](https://community.glideapps.com/u/Carl_Johnson)
#### Post date: [October 15, 2024, 12:14am UTC](https://community.glideapps.com/t/multiple-entries-for-timestamps/38198/3 "2024-10-15T00:14:07Z")

</div>

I have the same need as heyitsjorbs but would like to use the trebuchet method to avoid making more rows of data.

I have a set column action that records the item as well as the current time stamp when the job was marked completed but the items in question are shared between all the users so i need a way to associate that user 1 completed item 6 at x time. user 2 completed item 6 at time y.

my set column update is capturing the user rowId as well as the time stamp and writing this array into the item list.

I have “userrowId” “datetimestamp” as array elements in the items list

**I need to know how many times the user worked on an item and when**

I _think_ I need a way to pull those two values apart so i can get an inline list that shows that user 1 worked on item 1 at datetime-1 as well as at datetime-2, item 2 at datetime-3, 4 and 5.

User 2 worked on item 3 at datetime-1, etc

If there is a way to do this please point me to the info. I looked at Bob’s miracle method but don’t see a fit.

thanks!

---

<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: [October 15, 2024, 12:17am UTC](https://community.glideapps.com/t/multiple-entries-for-timestamps/38198/4 "2024-10-15T00:17:28Z")

</div>

Assuming you have a set up with multiple files, you can pre-construct a JSON containing all the info you need, then on a click, write them to the multiple files column.

Then use Bob’s miracle method to transpose the JSON and display them using helper table’s rows.

---

<div class="post-metadata">

### Author: ![Carl\_Johnson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carl_johnson/32/75656_2.png) [@Carl\_Johnson](https://community.glideapps.com/u/Carl_Johnson)
#### Post date: [October 15, 2024, 3:56am UTC](https://community.glideapps.com/t/multiple-entries-for-timestamps/38198/5 "2024-10-15T03:56:17Z")

</div>

thanks - I am following the docs at [JSON | Glide Docs](https://www.glideapps.com/docs/automation/integrations/json#json-template)

Very easy to create the JSON structure. Will go over Bob’s video - that looks like exactly what i need [https://youtu.be/1QbKTccN850?si=dpWdXfPqlFD\_ktLP](https://youtu.be/1QbKTccN850?si=dpWdXfPqlFD_ktLP)
