Automatically update field value based on input from another table using workflow

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 -

  1. Products (Fields- Product Id, Product Name, Type, Price and Image)
  2. Sale (Fields- Sale ID, Date, Order ID, Order Status)
  3. Sale Details (Fields- Sale ID, Product ID, Order ID and Packing Status)

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

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.

1 Like

Thanks, works like charm!

1 Like

You’re welcome