Đã Hủy

Script to update Google Sheets data and export content to CSV on Google Drive

Hi there,

I have a Google Sheets spreadsheet in the following format:

TimeStamp Date Adjust from Adjust to Amount

2/15/2017 19:09:20 15-Feb-2017 Cash Dining Out 5

When a new row is added via AppSheet, I'd like for the data to be extracted to a new sheet and then saved as a CSV file in the same Google Drive folder. A new file for each time it's run is fine. The CSV format should look like this:

Date Desc Amount

15-Feb-2017 Backout Cash 5

15-Feb-2017 Adjust to Dining Out -5

The original row in the first sheet can either be deleted, or you could use an additional column and update this with a flag to indicate it's already been processed.

Prefer use of an onEdit trigger, although a time-based trigger will also be acceptable if it's the only viable solution.

Cheers,

Matt

Kỹ năng: JSON, MySQL, PHP, Kiến trúc phần mềm, XML

Xem thêm: update cell script google sheet, excel export data multiple sheets, export data multiple sheets, asp net vb export data csv, export data exchange 2003 csv file, vba excel export data csv, export data script vbs excel, php script data update, software write edid, free software write company profile, software write websites idea, software write book images, php data update script, software write books, software write protection, free software write book, csv data update, software write book, sugarcrm export data csv, sql job schedule export data csv, howto export data csv excel format php mysql, run php script data update, software write protect software, software write technical manual

Về Bên Thuê:
( 1 nhận xét ) Spotswood, Australia

Mã Dự Án: #10270409

20 freelancer đang chào giá trung bình $15/giờ cho công việc này

rajeshsonisl

Hello! With 98% to 99% completion rate, 900+ successfully completed projects, and a 4.99 reputation (maximum possible, 5.0) (can be verified on my profile page [url removed, login to view] !!)... y Thêm

$33 AUD / giờ
(752 Đánh Giá)
8.2
bdsiddhi

Hi, Greetings !! We are a team of 39 full-time, dedicated developers having expertise on native iOS & Android app development, Core PHP, Joomla, Magento, Wordpress, Moodle, Expression Engine, Prestashop, OpenCart, Thêm

$15 AUD / giờ
(169 Đánh Giá)
8.2
softsolution2000

I am ready to get started right away.... Can we discuss the project details? My distinction, payment after your complete satisfaction with the resulted task.

$12 AUD / giờ
(247 Đánh Giá)
8.1
shivmirthyusl

ABOUT US "IT FLEX SOLUTIONS has focused exclusively on the Web Development/Designing projects with 10+ years of service. Our Web Development/Designing expertise has helped clients to create e-commerce, social networki Thêm

$15 AUD / giờ
(178 Đánh Giá)
7.8
pointlogic

Hello, I always provide fastest results with quality,I have done more than 250 projects here..I have an experience of more than 10 years in web development and maintenance. I have in-depth knowledge of php, mysql, jque Thêm

$8 AUD / giờ
(237 Đánh Giá)
7.8
Shopify

Hello, I want to show you all relevant Demo and Designs which is similar to your project completed previously. To make sure about the requirement set and customization, I want to discuss this project with you furthe Thêm

$15 AUD / giờ
(19 Đánh Giá)
6.8
searcheverything

Greeting Matt ! I have read & understood this requirement . I can write script for your given requirement . I like to discuss briefly so I can give best solution for you , Looking for your positive response . Thêm

$13 AUD / giờ
(113 Đánh Giá)
7.0
prashushinde9

Hello, We have accomplished 90% of the project which is similar of your requirement. All we need 10% customization as per your requirement set and specifications. I want to discuss in personal chat in order to explore Thêm

$15 AUD / giờ
(50 Đánh Giá)
6.9
letshappy

hello, i have more then 6 year experience in this field and ready to start work now thanks..............................................

$14 AUD / giờ
(109 Đánh Giá)
6.7
RubyOnRail

Hello, It's a pleasure to let you know that I've Completed and Delivered similar project before. All I need to work on customization part if we can proceed towards more discussion. I have gone through your project Thêm

$16 AUD / giờ
(7 Đánh Giá)
5.6
FutureTechno1

Hi there, I’d like to be considered for your job position. I’m a Web Developer with a strong background developing with back end & front end. I can turn your requirement in a way that represents your brand and appe Thêm

$11 AUD / giờ
(11 Đánh Giá)
5.2
acronymsolutions

Hi, I am 18+ years experienced Database Programmer at CMMI-5 level company. I have 12 member team of different Technology. We are working on : RDBMS :Oracle,MySQL,PostgreSQL, MSSQL Server 7.0/2000/2008R2 and Onwards. D Thêm

$13 AUD / giờ
(35 Đánh Giá)
5.8
cracken

Hi, I am competitive to this kind of task, can take good care of this project. In fact, I already done related to this job before. Let me know the best of your time so we can discuss further based on your requirements Thêm

$15 AUD / giờ
(15 Đánh Giá)
4.6
engmalaa

A proposal has not yet been provided

$11 AUD / giờ
(25 Đánh Giá)
4.7
tarunmehan

EXPERT DEVELOPER with 5+ YEARS EXPERIENCE:: Thank you for posting this job. I can assist you in this job as I have completed numerous similar jobs in past. I am available for interview and start working on you Thêm

$12 AUD / giờ
(13 Đánh Giá)
4.8
hawkscodeaus

Hi, I can start work on your project immediately once you confirm me and i am also open for further discussion if you want. I have 7+ years in web designing & development with good experience in following skills Thêm

$18 AUD / giờ
(7 Đánh Giá)
4.5
nileshbakotiya

Hi, Thanks for the opportunity. As per your requirement, i would like to tell you that I have a very strong experience of more than 7 years in this field of design and development. Please spare a moment to discuss t Thêm

$8 AUD / giờ
(39 Đánh Giá)
5.0
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Thêm

$12 AUD / giờ
(10 Đánh Giá)
4.4
$16 AUD / giờ
(9 Đánh Giá)
3.5
$12 AUD / giờ
(3 Đánh Giá)
3.0