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.
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.
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!
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.
thanks - I am following the docs at JSON | Glide Docs
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
