Tracking status

AppSheet AppSheet Q&A
,
1

Hi all,

I just wanted to find out if it anyone might know of a way we would be able to send someone a link or direct them to a page where they would be able to track a job that was logged with our drivers? Something like the image attached would be great.

On our side it has a column “Status” that changes between Booking, Logged, Started, Picked up etc.

All jobs are logged with a uniqueid() that we could maybe use to reference the row?

Using Google Sheets for the data currently.

If we could have something like this, that would be perfect:

tracking-solution.png
tracking-solution.png2560×1708 140 KB

We do have a couple of websites where this could be hosted, I’m just not sure how to start looking into the functionality

2

There are a few things you can do, though I have very little experience in either:

  1. You can host a small version of your app in an iFrame on a web page. Go to this article for more details to get started: Run your app in an iFrame on a web page

  2. AppSheet has the ability to send an app view embedded in an email: Send embedded app view email from automation

  3. You could provide links, in an email or push notification, to specific views in your existing app or to views in a taylored app that minimizes app data access - i.e. only gives access to view the tracking status.

1 Like
3

Thank you very much for the replies.

I will see try these and see if I can get something working :grin: