How can you insert the time of day [ HH:MM:SS...

(John Broughall) #1

How can you insert the time of day [ HH:MM:SS ] from the Smartphone Device into the App field ?

(Aleksi Alkio) #2

Add a Time type field to your table and use TIMENOW() as an initial value. Every time when you create a new record, it will save this value to your database.

(Suvrutt Gurjar) #3

Hi @John_Broughall, If you mean to capture the current time

from the device into an app field by tapping an action


by the app user, yes you can do so by creating an action on a time type column that updates the time column with TIMENOW()

(John Broughall) #4


(Aleksi Alkio) #5

Do you want to capture the time or the duration?

(John Broughall) #6

@Aleksi_Alkio Hi

I want to capture the time at the Start and the Time at the Finish [ which could be 5 miles apart ] and send them to the spreadsheet to calculate the Elapsed Time.

(Aleksi Alkio) #7

May I ask how can you do that from the same place? Would you please describe the process with the time(s), thanks.

(John Broughall) #8

@Aleksi_Alkio A Rally Stage has a Start and a Finish. I attach a diagrammatic stage as an example.

One Operator has one smartphone with the Scoring App at the Start and another Operator has a second Smartphone with the Scoring App at the Finish, both feeding into the same Results spreadsheet. Photo

(John Broughall) #9


The Results spreadsheet is monitored by the Scorer [ the Results Manager ].

He will full editorial rights to change / amend / correct the Start and Finish times, if they incorrect.

If he only had the Elapse times, he would have no audit trail to check.

He will will be the Data Moderator.

(Aleksi Alkio) #10

Do they fill the same record or are they two different records?

(John Broughall) #11

@Aleksi_Alkio The Stage #, the Post [ SS / SF ] and the Car #

are concatenated to form a unique Code in the spreadsheet [ such as 2SS13 for the second stage, the stage start for car # 13 ]. That Code with the time is used to put the Time in the correct cell in the spreadsheet.

The Start may TX a time with the code 2SS13. The Finish may TX a time with the code of 2SF13. These time are put automatically into adjoining cells and the Elapsed time computed.

(Aleksi Alkio) #12

Sorry… badly explained from me. I try again… when you save the start and end time, are they two different records or do you open the existing record and then add the end time into that same record?

(John Broughall) #13


On some events, there may be, say, four different locations for the Stages, each having a Start Operator and a Finish Operator. There could be eight inputting Apps operating at the same time, but each would have a distinct Stage # and district Post, so their respective Codes would be unique as far as the single Results spreadsheet was concerned.

I just need your help to capture the raw data of Stage #,

Post, Car # and Time into a Google Spreadsheet and I know what I want to do downstream of the data inputting to get to the Results summary to be Posted on the Web.

(John Broughall) #14

Thank you

  • this is part of my Rally Timing Project. I would like to create the Timenow() and then be able to amend the minutes and seconds.

It would be a simpler way to insert the time, as the data capture would be within a minute of the Rally Time and just need to be fine tuned to the actual time for Posting into the Sheet.

Is that Possible. ?

(Aleksi Alkio) #15

I will try again… You have one record for one Stage# and Car#. You add the start time when you create that record. When the car is finishing the same Stage#, do you save the end time into the same existing record or not?

(John Broughall) #16

@Aleksi_Alkio I need to keep it simple and transparent to get it accepted by the old Scorer, [ who is a little set in his ways ].

Each Record [ Data string ] will be submitted independently to the Spreadsheet. The Start and finish times are separate entry Records in the spreadsheet.

I need to do this now, because any calculations ’ behind the scenes ’ will confuse the Scorer.

I do have future ambitions for the App, but I can’t work on them now.

At some time in the future, I would like the smartphone to actually time the car using Satellite time, so you only enter the Car # at each end.

The ultimate goal would be automatic timing to automatic Results

but NOT YET !.

(John Broughall) #17

@Aleksi_Alkio No

They are separate records.

The attached photograph shows what I expect to receive into the spreadsheet. There are a succession of Start

times and then interspersed times of starts and finishes.

The stage takes about

6 minutes.

The Stage, the Post and the Car # are concatenated in the spreadsheet into the first column to form the Unique code.

That photo shows the vlookup Table, where the first column is the reference and the inputted time to the subsequent sheets is in column 5.

(John Broughall) #18


The vLookup table feeds the Results Calc sheet. The grey font column will be hidden. The Elapse time is calculated.

(John Broughall) #19


The Results Calc sheet feeds the Results Summary sheet, which will be Posted onto the Internet for everyone to view…

(John Broughall) #20


I would appreciate your assistance.

I seem to be going around in circles with Stephen Mattison relating to my Application using appsheet to collect time data at the Start and Finish of, say, 12 stages, for up to 99 cars, to compute the elapse times [ Finish - Start times ] to produce a table of elapsed times with the lowest cumulative score winning. Stephen thinks that I should do all the computation in the App and I was expecting to use the App to gather time Data at two or more locations into a Google spreadsheet.

We seem to be running into a small problem by not having a column for HH:MM:SS for a 24 hour clock

Do you know anyone who could help me sort this matter out ?