Fermé

Registration Through Google Forms + Sheets

Hello Everyone,

Hope this message finds you well. I'm trying to collect data from one sheet that are located in a different locations and post them in another sheet as a list. Please find the attached file to work on it:

Registration Sheet - 2017 Q4

[login to view URL]

In this file we I would like to collect information from this sheet "Client Profile" and post them to this one "Client Profile List View"

I would like to collect from "Client Profile" this information:

1. Full Name, found in cell "i2, i24, i46, i68, i90, and so on..."

2. Email Address, found in cell "AR2, AR24, AR46, AR68, AR90, and so on..."

3. Mobile, found in cell "BW2, BW24, BW46, BW68, BW90, and so on..."

4. ID Number, found in cell "i3, i25, i47, i69, i91, and so on..."

5. Nationality, found in cell "AC3, AC25, AC47, AC69, AC91, and so on..."

6. Gender, found in cell "AO3, AO25, AO47, AO69, AO91, and so on..."

7. Medical Condition, found in cell "BD3, BD25, BD47, BD69, BD91, and so on..."

8. Blood, found in cell "BK3, BK25, BK47, BK69, BK91, and so on..."

9. T-Shirt Size, found in cell "BU3, BU25, BU47, BU69, BU91, and so on..."

10. DOA, found in cell "CA3, CA25, CA47, CA69, CA91, and so on..."

And post them to this sheet "Client Profile List View" under the following order:

1. Full Name, to be posted under "B9"

2. Email Address, to be posted under "D9"

3. Mobile, to be posted under "C9"

4. ID Number, to be posted under "E9"

5. Nationality, to be posted under "F9"

6. Gender, to be posted under "G9"

7. Medical Condition, to be posted under "H9"

8. Blood, to be posted under "i9"

9. T-Shirt Size, to be posted under "J9"

10. DOA, to be posted under "K9"

Please help me with this as I have tried many times but I'm not that expert in formula writing or script.

your support is highly appreciated

Compétences : Excel, Java, Programmation, Scripting

en voir plus : MS WORD , Excel, power point, flash , photo shop , Google sheets , Google forms, Writing skills , data entry , form filling , co, google sheets, excel, google forms, edit google forms data, create online registration form google docs, free online registration form creator, create online registration form, google event registration tool, using google forms for event registration, how to create a registration form in google forms, google docs registration template, how to create a signup sheet in google forms, excel, create order form google forms, registration form google database services, google forms excel, google forms api asp net, create ssl form google forms, captcha google forms, google forms parameters url, google forms ssl

Concernant l'employeur :
( 0 commentaires ) Qurtoba, Kuwait

Nº du projet : #15623572

19 freelance font une offre moyenne de $111 pour ce travail

shamalk

I would need few more details regarding the google sheet to complete this project. Relevant Skills and Experience I'm a Java professional with 8+ years of experience. Please check my LinkedIn (ID: shamalk) for more de Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(13 Commentaires)
5.6
Nidhijain123

Hello, I have read and understood what has to be done in this task. I have sound experience in performing such kind of work Relevant Skills and Experience Excel, Java, Programming, Scripting Proposed Milestones $10 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(78 Commentaires)
5.7
khudammunir

Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking and Content Writing experience with Advance MS Excel Dashboards, MS & Google Office, WordPress, Social Me Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(16 Commentaires)
4.3
mohamedkaram93

Hi Jarrah! I will be happy to help you with that. We can write a script that iterates over all cards in Client Profile sheet and add the add the data to Client Profile List View Relevant Skills and Experience Special Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(13 Commentaires)
4.4
shantasfiq

Ahmed khaled testemail1@ 27528752 98476398460 Hello there, Consider it as done!! Able to start right now and finish within your deadline. Relevant Skills and Experience Ready for sample as well (If neede Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(10 Commentaires)
4.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(21 Commentaires)
3.9
ketas

Dear , I'm have finished many tool using Google Script on Google Sheet . So , I could help you to make your request done in a short time. Only get paid when you happy with my work. Pm for more detail Relevant Skills a Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(12 Commentaires)
3.8
abhi98041

i am a expert in this and have done them before i can start immediately.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(16 Commentaires)
3.6
techsoftpk

Hi there, I am professional SEO friendly web designer & developer. Please send me message so that we can discuss the project in detail Relevant Skills and Experience I have 5+ years of experience with more than 500 su Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(4 Commentaires)
2.7
jebintrasheed

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(3 Commentaires)
1.4
mdyounuskhan726

Hello I am interested in your project.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(2 Commentaires)
1.3
jackbaskin93

I suggest a python script, which uses the Google Sheets API, that runs locally and takes the information from "Client Profile" and posts it in list form in "Client Profile List View". Relevant Skills and Experience I Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
1.0
celalaybar

Hello. I can collect data from a Google Spreadsheet sheet and move them to another sheet by using Google Apps Script. Relevant Skills and Experience I have done with similar projects. https://www.freelancer.com/projec Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
1.1
prabj

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
mdorseyc1

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(1 Évaluation)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(0 Commentaires)
0.0
vieexavi

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0