I have a form that has records which include information on each unique product we sell. Each of these products have their information updated frequently, and thus need new reports printed out each time they're updated.
Currently we have to edit the record, submit the update, reopen the record, and click the link that sends us to the report to print.
Is there a way that I can click a decision box, have everything in the form update, and then have an openURL pull up the report with updated information in a dialog box?
I know I can create a custom function to update every single value individually, however each record has around 40 values that would need to be updated. I was hoping there was something similar to openURL("#Script:page.reload","same window") but for submitting a form. Please let me know if there is.
Thank you very much for any help.