@Stephen_Mattison Hi, I have taken on board everything that you have said. Just to confirm that I have reviewed the layout of the App a little so that all the variables are stacked on the Left hand side, with a Minus / Plus keys in the middle and right. Due to a misunderstanding, I don’t want to select / enter the Stage number every time, just set it and keep it for the cars going through that Sage. Likewise, The App will be used at the Start with the Post setting of SS by one Operator. There will be another Operator at the Finish using the Post Setting of SF.
Both App locations will be submitting time data to the Spreadsheet regularly every minute approximately., [ and every 30 seconds for the 30 second starts ]. To avoid these setting to be changed in error during that stage, it would be good if they could be LOCKED.
The Car numbers will normally be sequential, but it may also have the odd change. By using the + / -, the car number can be stepped up manually. I don’t want the App to seek the next available number. I don’t want to seek a Car # from a drop down list of 1 - 99
or scan through a table of numbers as you have suggested.
I would anticipate that when one car leaves the Start Line, the plus button can be pressed once to register the next number.
For simplicity, I could use the Minimum of ’ 1
’ and the Maximum of, say ’ 105 ', where the numbers 100 - 105 are used for the Course Cars, etc.
It would appear that the number range may be simpler than a Validation List approach.
For the Time, I want to set the Hour from a range of 0 - 23 and normally leave it, unless the hour changes during the
running of the stage, when it will only step up one.
I don’t want to use a drop down List or table, as you’ve suggested. For the Minutes, the Start times will normally be at minute intervals, so when one car departs, I want to manually step up by one minute and not use a drop down list or table for the range of
0 to 59. The seconds are a little more difficult. Generally, the same comments apply, as for the Minutes.
However, I would like to find a fast track way to switch from 00 to 30 for the 30 second starts.
Lets get it working overall first and puzzle that problem out later. I note that some builds of the App refer to a separate reference file held on Google Sheets. Could that hold the Validation Lists and be drawn on to allow the extended range that I am looking for. I would anticipate that the HH:MM:SS would be concatenate the three elements into the full time function for transmission to the spreadsheet.
I hope that the detailed task is starting to fall into place.
I do appreciate your contribution and I know that I can be a little pedantic sometimes. John B