Hi Chris! Welcome to AppSheet!
I can understand your frustration. I’m an ordinary AppSheet user who’s been around for a couple of years now but I still find myself getting confused on a fairly regular basis – though I’ve gained a fair amount of knowledge and skill thanks to the help I’ve gotten on this forum.
It may be necessary to know more about the structure of your tables, etc. but I can try to start by making some general observations.
On an app I’m working on, I use a workflow rule to change the value of one column when something happens in another column. The workflow rule triggers an action that does the actual changing. If that’s what you need to do, the first thing you’ll need is one or maybe two actions (if you’re new to AppSheet and don’t know what an action is, let me know): One to change the value of the “driver” (or whatever the name is) column on its table and another to change the value of the “shipment status” column on its table. Then, the workflow will trigger those actions when a shipment is assigned.
Also, sometimes it’s not necessary to write something to a table to get a change in display. AppSheet has something called “Virtual columns” that can use values from real columns to determine what should be displayed. So, you might be able to have a virtual column that displays “busy” as the status for your driver when he/she gets assigned based on information in other columns. If a virtual column will work to do this in your case, that will probably be better. If my experience, the less writing to and reading from the spreadsheet the better.
All of this depends on the structure of your app. If you can add descriptions and/or screenshots of tables etc. that will probably make it easier for us to help you.
LinkedIn
Twitter
