🢐  Back

Stop Sheet

Stop sheet is where all of our stops will be sent to web portal.

We can manually input the stop data in the sheet, here are the fields for stop sheet :

Details for each field below :

StopIDThis field will be updated with stop id if successfully sent to web portal and error message when it failed. Should be left blank for new data.
NameData should be our team member name
CustomerCustomer name
AddressData should be valid address and must not be empty
PhoneData should be in number
EmailData should be in email format
TripDateFormat should be YYYY-MM-DD (Ex. 2020-11-30)
AppointmentTimeFormat should be HH:mm (Ex. 15:30)
DurationFormat should be number of minutes
NotesFree text

Once we have the data ready, we can manually send the data to our web portal/apps by triggering the sheet.

Click Locate2u -> Upload Stops.

Once completed, stop id will be filled with number.

If upload has error, error message will show instead.

We can also automate the trigger, so we don’t have to go to the google sheet and trigger it manually.

To do it, please referĀ here.