I need some script coding within Google Sheets
- or -
Post a project like this828
£363(approx. $456)
- Posted:
- Proposals: 22
- Remote
- #3475438
- OPPORTUNITY
- Awarded
data scrapping | responsive web | custom website | website scrapping | magento database migration | database autobackup
Ahmedabad
Quick Graphic Designer + Animator + Video Editor + Photo Editor + Logo Designer + Autocad Designer
Sydney
Excel | Google Sheets | Google Apps Script Automation | VBA Macro | Dashboard | Data Analysis
Karachi
413602567096142082706642216647690663847676290279536505050415914928387
Description
Experience Level: Expert
I have a Certificate Generator set up within Google Sheets which pulls in data from my master database.
From my Certificate Generator I can filter based on several criteria. This using a query function. Once this is filtered, this normally narrows the filtered options to a much lower level. I use this data based on the "Surname" and several VLOOKUP functions to pre-populate a template Certificate which populates the data. Each surname will then create a separate certificate (print and save as PDF).
I'm looking for someone to code within a script within Google Sheet; so that when I press 1 button it will automatically print and batch of Certificates from the initial query filter. E.g. if the query filter returns 10 results. The one button will produce 10 Certificate PDFs all saved as "RESULTS_FIRSTNAME_LASTNAME_DATE".
Hope this makes sense?
From my Certificate Generator I can filter based on several criteria. This using a query function. Once this is filtered, this normally narrows the filtered options to a much lower level. I use this data based on the "Surname" and several VLOOKUP functions to pre-populate a template Certificate which populates the data. Each surname will then create a separate certificate (print and save as PDF).
I'm looking for someone to code within a script within Google Sheet; so that when I press 1 button it will automatically print and batch of Certificates from the initial query filter. E.g. if the query filter returns 10 results. The one button will produce 10 Certificate PDFs all saved as "RESULTS_FIRSTNAME_LASTNAME_DATE".
Hope this makes sense?
Daniel C.
100% (15)Projects Completed
15
Freelancers worked with
13
Projects awarded
22%
Last project
4 Mar 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies