Update a ref table when selecting from a dropdown

[supporteh]

Hello, I want to create an order form, with the productid selected in the form is a dropdown ref to another table with all the list of all the products and their productid.
when a productid is selected in the order form, i want to update the product table - only the row that matches the productid selected, to say that it has been ordered and no longer available for any future orders. is this possible?

[Marc_Dillon]

In the valid_if field of the dropdown column, set it to
SELECT(products[product id] , ISBLANK([Related order form]) )

Table and column names may need some editing.
This expression will only select products that do not yet have any order form records that reference them.

[supporteh]

Hello, thanks for your suggestion, it may not work as the order row will not stay forever on the orders table, it will be deleted after 1 week, so we need an actual update to the productid row, do you know if it can be done by actions?

[Aleksi]

Check the sample app “Event action” from here how it is done with actions… www.appsheet.com/portfolio/531778

[supporteh]

Thanks, that is excellent, just what i was wanting to achieve, thanks so much!

[Aleksi]

You’re welcome