This is new to me, a 0-based row number return in filtered Get Rows request reponses.
I encountered this trying to do a simple sample of logging Arrivals and Departures in the same row.
I used my NYC Marathon sample as a framework, with an extra sheet for Arrivals/Departures:
Notice how this bug overwrote the Departure Time heading on column D, and logged Departures one row too high (-1 row) for each update.
Adding Arrival Times is straightforward:
- Add a new row with just the arrival time and other details, departure time 0.
Adding Departure Times is a two phase operation,
- ask for a filtered list from the Arrivals/Departures log for the runner in question
- Take the last row number from the returned row number list.
- Use it to update column 4 (D) of that row number.
Here are the blocks:
The incriminating Do It result for the first occurence, where the column 4 heading got overwritten:
The exported .aia file, if you want to play:
MarathonSheetsWithArrivalDeparture.aia (20.0 KB)
The sheet:
If you have a previous thread where this error was found, please point to it.