API's, Websites and adding a button for customers to book collections

mattyg · 4 Sep 2024 at 11:37

Hello, You clever lot!

We've been asked by one of our contracts to add a electronic booking option to our system. We currently use a call centre to make 600 calls a day to our customers which then gets collated and sent via sms to 50+ drivers and they want this streamlining.
We've been looking at other systems as well (new tracking, Planning + ePOD systems)

We dont have an IT dept (apart from myself and I'll **** this up if I try)

How hard?
Whats needed?
One of the systems we are looking at has an open API. We just really need a button that the customer can click to order a collection that then adds the job to our system.

Any ideas guys?

Matt

mattyg · 4 Sep 2024 at 18:27

Cromulent said:
Can you link to the API documentation? Hard to tell without seeing what is required.

Clicky - Open API doc

kaku said:
Honestly sounds like a liability without an IT department or anyone to support it.

Is there not a company offering a white label solution?

There's only 2 of us.... Having an IT dept might be overkill..

Apart from when I forget passwords... :rolleyes:

mattyg · 9 Oct 2024 at 18:17

Ok, So revisiting this.
Looking at what a competitor does. They have a Form Field on their site. Customers use that to book collections.
So, Whats the easiest way to get the info from the Form field into an excel file for importing onto our system.
We'll create a website specifically for the booking of collections. hopefully only need a landing page with the form

mattyg · 10 Oct 2024 at 12:47

radderfire said:
As above, the best way would be your system having an API, and the form using the API to submit data into your system. If your system doesn't have an API then it needs one.

Excel isn't a web technology, so getting data into it and out of it into your system automatically would be cumbersome, and maybe not automatic.

Thanks.

So the Courier management system (routing etc) holds the database of clients and has an API.

I've tested a web form field (JotForm) and have managed (with my very limited experience) to get the form onto out testing website

Jotform can send an email with the details But as pointed out by you guys an email or excel sheet is not really what we need.

However My website has a Form that can be modified.

I dont really know anything about API's other that its name. So i'm trying to catch up.

mattyg · 10 Oct 2024 at 13:31

Dup said:
It's possible to send data to a Google Sheet via your own form on your website. Have a look at this guide: https://github.com/levinunnink/html-form-to-google-sheet

I haven't looked at it closely, I just know it's possible and pulled that up as a potential guide, there may be better out there. You'll certainly want to make sure the users gets feedback of successful/failed submissions.

The Courier software will send a booking confirmation once it allocates to a route.
We've a zoom meeting with them tomorrow which will shed light on it. It'll probably be a simple solution at their end and i've been panicking about this for nothing..