Update value in another table after form submit

[lior_zioni_danc]

i have a CUSTOMERS Table and ORDERS Table and Orders Form
every Product have “End Date”
Customers Table looks:
“NAME” “PHONE”…“END DATE”
Orders Table looks :
“DATE” “COS_NAME”(ref to customers Table) “PRODUCT”…“END DATE”

I want to Update The value of “End Date” CUSTOMER in the Customer table, from Orders from “End date”
tnx

[Steve]

help.appsheet.com

Actions: The Essentials

Learn how to use actions to modify data and navigation in your app.

[lior_zioni_danc]

Tnx steve
I know this article i read it few time and i also looked here in the community
But i tried few times and didn’t succeed to understand how to do it…
I saw some of u answer about 2 action 1 update data and 2 is an execute tried but didn’t really understand how

[lior_zioni_danc]

Hi @Steve
I tried this
Update form action?
This is what i need to do?
If yes i didn’t understand how to do it

[Aleksi]

@lior_zioni_dance Please check the sample app “EventAction” how it’s done. www.appsheet.com/portfolio/531778

[lior_zioni_danc]

Tnx @Aleksi i saw this app but still tried to figure it out… 1 i think i didnt understand the logic of the 2 actions, what i accomplish from each action
What i accomplish from the the execute action and the update action and where do i put each of them? And how do i tell app sheet to get the end date value from the orders table from that fill by one customer and update the same customer name in the customer table? Do i need add any virtul culomn in order to make it happen… Sorry if im annoying but im new with this… And maybe i have some luck of knowledge… Tnx