Đã Đóng

Google Form/Spreadsheet expert - repost 2

We have created 2 google forms. These forms populate to 2 spreadsheets, A & B. A= "CRA Responses" B="LCRA Responses"

Spreadsheet B's data is imported automatically into spreadsheet A, all in one tab so they can be compared in a row. Although the import occurs, I believe these rows must be indexed and matched so that the whole row is bookended to it's respective row, linked into one row using the data found in column titled "Report Title" (seen in both CRA Responses and LCRA Responses".

The row data includes email addresses, dates, and text.

In general, here are the problems:

1) 2 forms will submit 2 different sets of data, where one unique id in the data is the text (limitations of text matching is understood). We want these sets to line up on one row in a summary tab.

2) After submitting a form, google forms allows the user to see a url which allows users to return for edits in the future. I'd like to automatically collect this url each time a form is submitted.

2) Lastly, we want a script which sends an email reminder to an email address in the spreadsheet if certain conditions are not met. (ie: a cell is not populated)

We intend to pay $25USD for the project.

Please download a copy to your google drive to imbed formulas: [url removed, login to view]

Please submit screenshots of your local project to prove the project is complete. please replay with dear ben.

-Ben

Kỹ năng: Nhập liệu, Excel, Google App Engine

Xem thêm: spreadsheet forms, using google spreadsheet, spreadsheet script google, spreadsheet script, script google spreadsheet, script google forms, prove excel, indexed data, excel formulas expert, cra i, spreadsheet google, google script spreadsheet, google excel spreadsheet, problems data entry, excel expert google, row spreadsheet, google spreadsheets, google forms, google form report, google drive, google text data, copy excel spreadsheet email, script google drive, url import data, import excel data form

Về Bên Thuê:
( 0 nhận xét ) Hyderabad, India

Mã Dự Án: #4545339

7 freelancer đang chào giá trung bình $183 cho công việc này

emilianojn

Hi, please see PM.

$263 USD trong 30 ngày
(0 Đánh Giá)
0.0
ubayad

Dear Hiring Manager, I'm interested in the position of lead for your job. I have six month experience on the freelancing sector & am very good in Data Entry Sector. Also you can see my profile. I'm very excited to as Thêm

$55 USD trong 3 ngày
(0 Đánh Giá)
0.0
Azmary

Sir , Thanks for your project. I am ready to start. I will make you 100% satisfy.

$250 USD trong 20 ngày
(0 Đánh Giá)
0.0
niku2811

Hi I am ready to take this opportunity.

$111 USD trong 3 ngày
(0 Đánh Giá)
0.0
Exilexus

Hello, I have gone through the requirement and would like to take it further . Please consider our proposal for the project and we are really looking forward to work for the same . Being a new freelancer, it would be Thêm

$223 USD trong 3 ngày
(0 Đánh Giá)
0.0
harinathptpd

working more than 6 years on spreadsheets

$222 USD trong 3 ngày
(0 Đánh Giá)
0.0
amazon823

I am an IT Graduate and I know myself as a dedicated worker. I am frank and if I say I can do it, I will and I can do it, whatever it takes.

$155 USD trong 3 ngày
(0 Đánh Giá)
0.0