Can a deluge script run on user input in a form?
I have an application which creates a form
Temp_Inv that is used to input monthly inventory & orders. at the end of the month, the following fields are exported to a form
Month Summary be added to the Inventory form:
Item ID
Yesr Month
Inventory Amount
Order Amount
All records in the Temp_Inv form are then deleted and new records are exported from the Products form.
I want the
Temp_Inv form to have fields
Last Inventory and
On Order which would be the values in
Month Summary form for each item, but it only needs to run once.
Could there be a button on
Temp_Inv or
Month Summary labled "Update for Last Month" which would run the deluge script to do the update?
Thenks
Alex Scott