Google Scripts: keep spreadsheet data up to date in variable places in Google doc
$30-250 USD
Maksettu toimituksen yhteydessä
When a row is added or edited on any of these three source spreadsheets...
https://docs.google.com/spreadsheets/d/1cUFJz0nippnHge1byNeIubbRh0sggEBcKufcyMqT_iI/edit#gid=1777582606 (Bronze Raw Data 10_27 copy)
https://docs.google.com/spreadsheets/d/1ul-k-ZRY_7hkkescMQxfkPTZ0dZjkVKACBSPSkrd92I/edit#gid=1711134167 (Silver Raw Data 10_27 copy)
https://docs.google.com/spreadsheets/d/1Au8tVQQeSH3bgUeEvqE_XJBv5krAYJs8FCMy-fxQD7c/edit#gid=2123049995 (Gold Raw Data 10_27 copy)
.... Add or edit the following at a variable location...
[{Event Title}; {Your Name}] {Event Start Date in [login to view URL]}; {What is this event all about?}
>> {Event Start Date / Time} at {Location}
... on this Document.
[login to view URL] (Master Sunday Announcements)
The variable is the number of weeks prior to {Event Start Date in [login to view URL]}, on a Sunday:
Gold: 8 weeks prior to the event start date
Silver: 5 weeks prior to the start date
Bronze: 3 weeks prior to the start date
...And, in each case, add
[{Event Title}; {Your Name}] {Event Start Date in [login to view URL]};
to every Sunday leading up to the start date, inclusive.
The Google Doc needs to stay up to date if ever an existing event in the Spreadsheet is manually edited.
Projektin tunnus: #14695145
Tietoa projektista
6 freelanceria on tarjonnut keskimäärin $170 tähän työhön
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. I can do this google spreadsheet script task as per your requirement Relevant Skills and Experienc Lisää
I have experience in Excel, VB, VB.net, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Relevant Skills and Experience Google Doc Script Proposed Milestones $166 USD - d
Hi, I can do this project accurately and deliver in few days..................................................................