Appscript program
Budget: $30 – $250 CAD
I have a google sheet. The main sheet is an order index which has a long list of sequentially numbered orders. Each row contains one order. The row contains all relevant information to that order. Date description, employee, etc. I have made a template in a second sheet with an Order Confirmation sheet. This can be printed / exported as a 1 page pdf. All the data on the index sheet have cooresponding fields to go in on the order confirmation sheet. I would like a menu item up at the top of the spreadsheet with the following the following 4 options.
Export with rate
Export without rate
Email with rate
Email without rate
It is really two different options, just the rate data field is omitted to iterate it to two options. Really the export is all that I need if email is too complex.
Basically this button should open a prompt box for a user to input an order number then create a pdf of the order confirmation. It would be ideal if it could save the pdf to a folder in the same drive directory with the folder named the order number.
On the email option the prompt box could ask for order number and then also take the data from the employee/driver field to know who to send the email to. We could make a third sheet with a list of employee names and their respective emails.
I have looked at some of the online material for Appscript and think this should be well within the realm of possibility. I just dont have the time to put it all together on my own. Please let me know if this project would be possible?
Export with rate
Export without rate
Email with rate
Email without rate
It is really two different options, just the rate data field is omitted to iterate it to two options. Really the export is all that I need if email is too complex.
Basically this button should open a prompt box for a user to input an order number then create a pdf of the order confirmation. It would be ideal if it could save the pdf to a folder in the same drive directory with the folder named the order number.
On the email option the prompt box could ask for order number and then also take the data from the employee/driver field to know who to send the email to. We could make a third sheet with a list of employee names and their respective emails.
I have looked at some of the online material for Appscript and think this should be well within the realm of possibility. I just dont have the time to put it all together on my own. Please let me know if this project would be possible?