This page would show the running totals of remaining inventory. The starting inventory for the running total could be changed based off the above steps, but all inventory previously shipped still needs to be subtracted from those totalsĮditable gallery to enter the daily qty shipped This is the form I would like to have to record the daily inventory being shipped- once the save button is selected it would update the running total of inventory remaining at the supplier shown in the next picture. This is where we edit the starting inventory, added supply, and changes- the patch equation updates the excel the above screen pulls fromĮdit starting inventory, updates the inventory at suppliers page Inventory at suppliers shows the starting inventories and will be updated as we buy product or convert bags into totes Hopefully these screenshots will make more sense.

However, this inventory box can be updated to change the starting inventory. Thank you for your help, could use some help with a very similar problem, I am trying to create a daily inventory shipped form, once the form is submitted I would like it to subtract from the inventory box. Not the fanciest workaround, but it worked Office365.SendEmail(User().Email,'Email Notification - Inventory Used', InvAmount & ' ' & checkedout.ProductName & ' taken.', InvAmount,0) Navigate(HomeScreen,ScreenTransition.None) ResetForm(ReserveForm) Then preventing the user from taking more than available:Īnd then deducting the given value at the press of a 'Confirm' button:

Nonetheless I manage to work around it by setting the TextInput OnChange property to: For some reason it refuses to gather the info from that TextInput field in particular, even though other Labels can. Yes, inventory.Available was formula for the remaining stock

Powerpoint add.subtract button