Iโve been working on this app for days! I canโt figure out workflow rules to change status of both shipments and driversโฆ When a shipment is assigned to a driver I need the driver status to show busy and the shipment status to show in progressโฆ And then vice versa when shipment is deliveredโฆ I have shipment and driver tablesโฆ I can not figure this outโฆ Please help meโฆ
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.
I tried the virtual comlumn thing but no luck. As of now, I can get the driver to show busy when they are assigned to a shipment. But the shipment does not show In progress when they are assigned. In Driver table the driver email is the key. In the shipment table the driver column REF the driver table. Maybe because its a REF column but I canโt find a way to change status on shipment table to In progress when adding the driverโฆ
The thing about virtual columns is that you need to learn to use the โexpressionsโ (formulas) that make them work. Thatโs the hard part. Iโve gotten better but the learning curve with expressions has been fairly steep for me.
I think that following up with @Lynn is probably the best strategy. Learning from apps that other people have put together has been a primary way in which Iโve learned.
Thank youโฆ Iโll try to get with @Lynnโฆ
Hi @Pcullc Ipt the app in my protfolio. It may give you some ideas for changing data in other tables.
https://www.appsheet.com/portfolio/129805
Also check out this doc.
Thanks for sharing @Lynn!
Hi @Pcullc I have recently made a demo app to show how this is done as I hadnt done this before and wanted to know how it worked. If you havent figured it out and would like to have a look let me know and I will put it in my portfolio. There is a very long how to page in Info>Properties> Details of app documentation section.
Yes, that would be VERY helpful! Thank you!.
@Pcullc, the example @Lynn provides is spot on (nice example Lynn!)
She has a workflow rule that fires when a new Job is added. https://www.appsheet.com/Template/AppDef?appName=TrucksWF-129805#Behavior.Workflow.On%20Adding%20New...
This fires an action called โGet Drivers to Updateโ on the Jobs table. WHat does that action do? Check the definition here: https://www.appsheet.com/Template/AppDef?appName=TrucksWF-129805#Behavior.Actions.Jobs.Get%20Drivers...
Youโll see that it gets a list of Drivers and then on each of them, applies the action โUpdate Drivers Tableโ
Thank you so much @Lynn
That is helping very much.
@Pcullc Great. The Info tab has step by step instructions .
User | Count |
---|---|
42 | |
34 | |
26 | |
23 | |
15 |