Google Sheets Javascript Button to export to new row in another sheet

เสร็จสมบูรณ์ โพสต์แล้ว 6 ปีที่ผ่านมา ชำระเงินเมื่อจัดส่ง
เสร็จสมบูรณ์ ชำระเงินเมื่อจัดส่ง

I have a large project that will likely require several google sheets javascripts to be created if I find the right person. The first need I have requires me to take the inputs from one (third party facing) sheet and create a new row in another sheet. Basically, I need to have a client facing document which allows inputs with the calculations being done on a different document and outputting back to the first (client facing) document. The new row will take the inputs (vertically listed) from the first document and transpose them to a row in a completely separate google sheet document. This new row will also need to copy down the formulas from the above row as if they were filled/dragged down (references will need to update to current row if they are not absolute references) (I am still building these and I'm not sure if it can be done down the whole row or if I will need to figure out how many columns there will be with formulas to copy down). This button (which will be located on the third party facing sheet) will also need to take some of the calculated rows and copy them over to a template which is in a separate sheet within the second document and output a pdf of that template sheet. (I am open to other options on how to make this happen as long as none of the formulas or data are seen by the third party other than their inputs and specific desired outputs). Feel free to message me with questions, I will be online sporadically today but will respond as soon as I can

Google App Engine Google Chrome JavaScript

หมายเลขโปรเจค: #16635900

เกี่ยวกับโปรเจกต์

11 ข้อเสนอ โปรเจกต์ระยะไกล ใช้งาน %project.latestActivity_relativeTime|แทนที่%

มอบให้กับ:

mohamedkaram93

Hi there, I will be happy to help you with that. We will actually create two Google Scripts, one bounded to the (third party facing) sheet "and there may be multiple sheets of this type and you can simply copy the s เพิ่มเติม

$150 USD ใน 3 วัน
(46 รีวิว)
6.1

freelancer 11 คน กำลังเสนอราคาในงานนี้ โดยมีราคาเฉลี่ยอยู่ที่ $175

cgullapalli

Hi, I am good at Google sheets Scripts. Please share the google sheet link to review the requirements further. I have gone through the requirements in the description. Looking forward to work on the project. - เพิ่มเติม

$150 USD ใน 2 วัน
(36 รีวิว)
5.9
pindianwebhub

Dear hiring manager I have read your description and i must say i can provide you your desire results ShAll we chat more ? Thanks

$200 USD ใน 2 วัน
(37 รีวิว)
5.6
ajoy3freelancer

Hi, I have 13 years experience in PHP, JS and VBA. I have checked your requirement and strongly believe we can do it either using direct google sheet or else via PHP. The ideal solution will depend on some factors and เพิ่มเติม

$200 USD ใน 5 วัน
(9 รีวิว)
4.4
manojtacty

Dear Hiring Manager! I have gone through your job post and tried to understand what you want but unable to get exact point. Please specify your requirement more specifically. I got your idea but I want to make it co เพิ่มเติม

$250 USD ใน 3 วัน
(2 รีวิว)
3.6
helloStack

Hello , i am expert in this field i can do this project easily and will guide you like how to proceed So let us do some healthy discussion and made the project possible according to you :) Thanks

$155 USD ใน 3 วัน
(0 รีวิว)
0.0