Hi,
I have recently built an app for my e-commerce business which manages order processing. Till now everything seems ok, but Iโm stuck with automations where I need some expert advice.
App Description
Iโve got these Tables -
Problem
Iโm trying to change the status of โOrder Statusโ in Sale Table from โNewโ to โPackedโ when I change the โPacking Statusโ in Sale details Table to โPackedโ.
I know this has to be done with actions and workflow, but Iโm not sure how to do it. Iโve seen a lot of videos and read a lot about it, still no help.
Looking for solution with steps (if possible). Thanks in advance
Solved! Go to Solution.
You need to use two actionsโฆ the one which update the sale record and then another one that is triggered from Sale Details record and this action needs to be triggered as โExecute an action on a set of rowsโ. Please check a sample app called โUpdate Parentโ from www.appsheet.com/portfolio/531778.
You need to use two actionsโฆ the one which update the sale record and then another one that is triggered from Sale Details record and this action needs to be triggered as โExecute an action on a set of rowsโ. Please check a sample app called โUpdate Parentโ from www.appsheet.com/portfolio/531778.
I am trying to understand how to update the Parent table but the expression is not working.
Have you checked that sample app already how itโs built?
Thanks, works like charm!
Youโre welcome
May I ask what kind of formula have you tried and where?
Hi Aleksi,
im having the same problem. Can you help me to fix it. Here's some screenshots about my app.
Im trying to update de column "Proyecto Ubicaciones" (ref by table 'Proyectos Ubicaciones') of my table Products.
Iโm trying to change the value of โProyecto Ubicacionesโ in Products Table when I set the โNameโ Column in Orders Table.
Proyecto Ubicaciones column of Product Table and Name column of Orders table, are both referenced to the same table that is Proyectos Ubicaciones table.
Thanks in advance!
Please start a new topic for help with this.
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |