I have created my spreadsheet with all of the questions I need to be answered. I then want to have the system create a new document/template for every row/ form fill, then I would like the data to be used to add to a cell in sheet #2 (I can do this with template setup). Once it is created, I would like to be able to attach that data to an email and send out.
I have created the app, the template for the email now I just need to have the system create the xls sheet and attach it to the email to be sent. I'm having a bit of confusion on how to get the data to the new xls sheet.
Does it automatically create a new document/xls when saving with the file name that I have setup?
If so how can I have the new document be an attachment? I just need a bit of guidance on how to get this setup once. I've just learned about these child tables, would this be required to get all of this done?
Thank you so much for any help you can give, I'm not a coding expert so I'm having a bit of trouble.
LinkedIn
Twitter
