Timestamp task worked on per user

I think it should be done in a JSON trebuchet sense.

  • Have two user-specific fields for “start time” and “stop time”. Then a JSON object with those two fields.
  • Have a multiple files column to store the JSON array.
  • Have a “Make array” column to combine the multiple files column with the JSON object.
  • Create two buttons with two actions, “start” and “stop” for your front end.
  • Start button would be visible when the “start time” field is empty. It would set the current timestamp to the “start time” field.
  • End button would be visible when the “start time” field is not empty. It would set the current timestamp to the “end time” field, set the “Make array” column value to the “Multiple files” field, then clear both the start and end time.

I will record a video later for this.