So for example, we have to process phone orders at work, and the information for the orders needs to be submit into two to three forms depending on what is required.
One is for record keeping where the details of the requirements go (user name, SIM number, departmental cost code etc.).
One is for the charge sheet which is sent to the finance department to charge for the device.
The final one will go to the network provider for activation of the SIM (this one is dependent one whether they require a SIM).
I want to set it up so I can input the data once into the form and it will input it to the correct fields in the relevant spreadsheets. Is this possible? I mean, ideally I'd like a form to scrape the order submission from our ticketing system but that may be asking for too much at the moment. I may just use the form to replace the ticket and have the user submit the form themselves if I can set it up correctly but that's another conversation!
Thank you in advance.
