Need to change a value of one table to another table

Ask for Help
1

Hi

I have a product table and store pickup table.

The business owner updates the available status after a product as bought.it should update the store pickup table. - Happening

But i want the product table too should change to bought.

How to do it.

2

Try creating a relation column between the two tables on a common data column and then use lookup column on that relation.

3

How does one CHANGE the value in the related table?

For example I have a table of items that needs to be decremented when an item is included in the order.

I can lookup for the value from the orders table to the items count but don’t have a way to change the value?

Thanks

4

As long as you have a single relation to that item, you can perform actions through the relation.

5

in the set column action editor as you know i can select this item (which is the orders table). If I have a relation to the items table in orders I am able to select the count column in from the list of columns?

6

If the action is executed from the orders table and and you have a single relation from the orders table to the items table, then you can select the relation as the data source and set values through that relation.

7

I’m sure if it was you entering this it would work first time. i see the relation i orders from action editor. select my relation decrement the count value and no change when I look in the data editor. will pound my head against this wall a bit more as there is something i am missing.

thanks for the help

8

So you were able to configure the action to use the relation? What’s calling the action?

9

Jeff - i deleted the action I was previously using and created it from scratch and and it is working. I have seen this behavior in Glide before so I start over and things seem to work better. I have specified a negative increment value -1 but i noticed it add to the count.

Hey - I’ll take the win but wanted to confirm that i can increment negative values?

THANKS

10

there are many updated another table posts on the site. This fix is SO easy - if there is a tutorial on this let me know.

Have a great T-Day if you celebrate

11

Interesting. A negative number should work and the docs mention the same.

Not sure if there is a specific tutorial, but here is a post from when the feature was implemented back in 2021.

Happy Thanksgiving to you too.