Dispatch app - best design when job claimed

AppSheet AppSheet Q&A
1

I’m making an app that will be used by a dispatcher to announce new delivery jobs available and enable drivers to claim the job or see that it was already claimed. I’m thinking that only the dispatcher will have the app. When a new job comes up, each driver will get an email with a custom link to a publicly available form. Once the first driver has claimed the job by clicking the link and saving the form, subsequent drivers who click a a link for the same job should not see the form, but instead a message that lets them know the job was already claimed. (Essentially mimicking a simple web service).

To do this, I suppose I could create a text field that would hold the “sorry, claimed” message and use calculations to show that field and hide all the other fields when the job is already claimed. But it feels kinda weird so wondering whether there a more elegant way?

2

What form service are you using?

3

Well, I was thinking that I could make a public link to an AppSheet form.
Is that not true? If not, I guess I will just make a php page.

4

You can create a new Public app, on another account, for $50 per month.

If you do that, or any other form within an Appsheet app, then yes, this:

I suppose I could create a text field that would hold the “sorry, claimed” message and use calculations to show that field and hide all the other fields when the job is already claimed

is fine. You could use a Show column instead of a basic text field, but same idea. You could also set a valid_if and display the message as the invalid error message.

1 Like