Google Apps scripts
- Tình trạng Đã Đóng
- Ngân sách min $50 USD / hour
- Tổng Lượt Chào Giá 14
Mô Tả Dự Án
I need a couple Google scripts to integrate workflow among Google Drive/Sheets/Forms.
1. GOOGLE DRIVE -> GOOGLE DRIVE
Drive link: [url removed, login to view]
When a new folder is added to 'Campaigns' folder, identify any existing folder inside folder 'Archive - Recurring Events' that RESEMBLES the folder just added to 'Campaigns' (i.e. the two folder titles contain an identical string of at least two words AND the two folder titles contain a date that falls within one month) and merge the contents of this existing folder with the new folder just added to 'Campaigns'. Add a subfolder to the newly merged folder and entitle it according to the current calendar year (i.e. '2017'). Finally, add a fixed template series of subfolders to the folder entitled according to the current calendar year.
2. GOOGLE SHEETS / FORMS -> GOOGLE SHEETS
Form link: [url removed, login to view]
Sheet link: [url removed, login to view]
When Form receives date/name data in Columns I and W that RESEMBLES data in Columns E and D in Sheet (i.e. when 'EVENT TITLE' contains an identical string of at least two words AND when 'SHORT START DATE' falls within one month), select the Sheet row and replace data in columns G and L of the Sheet with 'Yes' and 'Pending Review', respectively.
Nhận báo giá miễn phí cho dự án tương tự
Các kỹ năng yêu cầu
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Thuê những Freelancer đã đặt giá trong dự án này
Bạn đang tìm việc làm?
Làm việc cho những dự án như dự án này và kiếm tiền tại nhà!Đăng ký ngay
- The New York Times
- Wall Street Journal
- Times Online