Hello there, rookie here. I have an Order Capture app (based on the Order Capture How to app) with a table โCatalogueโ of items we hire out columns โNameโ, โItem Idโ, โPriceโ, โStockโ etc. A table of โCustomersโ, โNew Hires/Ordersโ, with โOrder Detailsโ and slices for โOpenโ and โCompleted Ordersโ.
In the Catalogue table I have a virtual column called โRelated Order Detailsโ REF_ROWS(โOrder Detailsโ, โItem Idโ) and I set up another virtual column โStock Calculationโ with formula [Stock] - COUNT([Related Order Details]), which drops the โStockโ of the โItem Idโ that I add to an โOpen Orderโ. This works fine but Iโm struggling to find a way to reset the โItem Idโ stock to its original value once the Order becomes Complete and the item is returned.
At the moment the only workaround I managed to find is to have the โStockโ column (name displayed โRestockโ) as a stepper number, find each Item Id that was hired and restock it manually. That sets the โStock Calculationโ to the right value but Iโd like to know if there is a way to automatically restock an item without having to delete the order and related details once the order becomes Complete? I would like to be able to keep a record of all the Hires we have.
Thank you and apologies for the poem, Iโm pretty new to all this and donโt know how to word things efficiently
Solved! Go to Solution.
You may wish to take a look at the reference actions that can implement conditional updates across tables on events such as form save. The sample app below updates children records based on the parent record changes. You could do a reverse way- update parent record โCatalogueโ when an Order is complete in โNew Hires/Ordersโ.
You may wish to take a look at the reference actions that can implement conditional updates across tables on events such as form save. The sample app below updates children records based on the parent record changes. You could do a reverse way- update parent record โCatalogueโ when an Order is complete in โNew Hires/Ordersโ.
Thank you @Suvrutt_Gurjar that worked beautifully!
Thank you for this @Suvrutt_Gurjar , Iโll give it a try and report back!
User | Count |
---|---|
38 | |
34 | |
27 | |
23 | |
17 |