Закрыт

Post Form Data to Google Sheets and Format Sheet So Data Can Easily Be Calculated

NOTE: I won't respond to copy/paste entries!

UPDATE: After reading some of the bids I'd like to clarify something: This is a simple project. Just make a connection between Zapier and Google Sheets and then format the sheet so the data is easy to read.

Form: Made with Cognito Forms. Need someone who can do basic data extraction from a web form and put it in Google Sheets.

Survey/Voting Form. I created a web form (hosted at an un-used, but active web host account of mine) for an employee awards banquet where I work. The employee's (about 50) will have three days sometime next week to vote for the winner in each of seven categories. I need the input data posted to a Google Sheet and formatted so I can sum the columns.

However, it's a little bit tricky to calculate the winner and I want the person who takes this project to make sure that's figured out too. It's easiest to explain if I tell you the rules:

The form can be viewed here: [login to view URL]

There are 7 categories (Employee of the Year, Most Improved Employee, etc.). The navigation button to the next page won't appear until the 3rd choice is completed...but there are 7 pages.

I need to be able to calculate the winner of each category. However, there are 3 choices for each category. Here's what each is worth:

First Choice = 3 points

Second Choice = 2 points

Third Choice = 1 point

The person with the most points in each category wins. I need to show the Top 3 in points in each category.

Also, I haven't made the multi-line text fields ("Reason") mandatory yet, but it will be mandatory that each of those fields have at least 10 characters so you'll have to make room for those in the sheet and it should be readable.

(Maybe you can post the results to a Google Sheet and also to an application where the data can be formatted like a letter. Idk. Only if it's too difficult to read the comment data in Google Sheets).

Anyway, I guess you can use Zapier or Microsoft Flow. Or you can use a script.

IF INTERESTED IN THIS PROJECT: Please send a short proposal telling me how you plan on doing the project so I know it's not just a copy/paste response and so we're on the same page. It doesn't need to be long. Two or three sentences should be enough.

Квалификация: Электронные формы, Excel, Web API, Web Development

Показать больше convert flv format dvd player can view, post form vb6, post form ajax php, how to use google forms to collect data, google sheets templates, create google form from google sheet, how to add submit button in google form, google forms spreadsheet, google sheets formulas, google sheets advanced tutorial, google sheets calculating formulas, automatic php post form submit, javascript onsubmit post form, ajax asp post form net php, php referre post form, post form data php automatic, xml post form php, visual basic post form data, paypal post form fields, curl post form value

О работодателе:
( 0 отзыв(-а, -ов) ) Chagrin Falls, United States

ID проекта: #18764980

19 фрилансеров(-а) в среднем готовы выполнить эту работу за $37

KulfiSoftwares

Google Apps Script Expert!! I can write a Google Apps script to calculate and show the top 3 entries as requested. Can we export the results of submissions of the form, to a CSV or excel file, if so, I can write a scri Больше

$200 USD за 5 дней(-я)
(273 отзывов(-а))
7.5
ferozstk

Hello, After reading your project details I believe I'm suitable for this project. As I'm expert on this with more than 7 years experience. Please feel free to contact me. I am looking forward to hear from yo Больше

$30 USD за 3 дней(-я)
(34 отзывов(-а))
5.6
MosesWanjala

Hello there, I have read your project description and I have seen this is something I can easily handle due to my expertise in data entry, Kindly award me. Regards. Moses Wanjala Virtual assistant

$20 USD за 1 день
(14 отзывов(-а))
3.2
siddiquiuns

My obsession for writing is endless, as it is mounting swiftly. I endeavor to write for you, professional, productive and compelling content that delivers your significance in a way which reflects your brand values and Больше

$30 USD за 1 день
(1 отзыв)
0.2
namrata1991

I have long term experience working with Google sheets, Google forms etc. I can provide you a free sample of my work from this task.

$25 USD за 5 дней(-я)
(1 отзыв)
0.0
sattarbd19

Dear Sir, I'm interested to complete your project if you choose me. your best regards Abdus Sattar

$20 USD за 10 дней(-я)
(0 отзывов(-а))
0.0
Mohsensiraj1

Go through the project details. You just need data on to the google sheets. With the complete input data from the forms so you can easily find the best employee from each category. Its a simple task, I have check the f Больше

$20 USD за 10 дней(-я)
(0 отзывов(-а))
0.0
Akhilraj20

Sir, your project is simple and experience in related filed. I am experience in this type of work and my past client are satisfied with my work. my key skills- 24×7 availability work dedication for more details visi Больше

$20 USD за 1 день
(0 отзывов(-а))
0.0
TechTayyab

Will do the work as per your orders. You will be satisfied. Will communicate along the way. Needed the project to grow in freelance market.

$32 USD за 1 день
(0 отзывов(-а))
0.0
omarepon

Hello! can deliver the project as soon as possible and hope you will be satisfied.i am fresher in data entry but i have skill in Ms word,excel,power point, average typing speed and things need to done the [login to view URL] wil Больше

$32 USD за 10 дней(-я)
(0 отзывов(-а))
0.0
Baloch1718

Hi! i am here to enter your data on excel and Ms word. i am the student of software engineering . I hope that i will fulfill your dream

$32 USD за 10 дней(-я)
(0 отзывов(-а))
0.0
$25 USD за 2 дней(-я)
(0 отзывов(-а))
0.0
josephlacsamana

Hi! I'm a Software QA Engineer, I've checked your website. I'm ready for this. I can finish it in 1 or 2 days depending on the data. I'm experienced Google spreadsheet User I'm using it in creating TC Relevant Skills Больше

$25 USD за 2 дней(-я)
(0 отзывов(-а))
0.0
Hridoy966

Hello,I'm very interested to work with you. And I promise I will try my best.

$25 USD за 1 день
(0 отзывов(-а))
0.0
kshitiz305

I think it is a very nice project and suddenly Falls veryon big living selection of the person according to the points at a given and then random number which has done in the description

$32 USD за 10 дней(-я)
(0 отзывов(-а))
0.0
lanremujib17

Hi there, I am Lawal. I can do the work for you and deliver you with an exceptional result within a short notice. Relevant Skills and Experience I am an experience creative writer, data entry and a researcher. I put t Больше

$32 USD за 8 дней(-я)
(0 отзывов(-а))
0.0
rahelnigus98

hello I have done a project in data entry, and I have experience in excel. I can provide this project with the list of all the 7 categories and the winner(has better points) in each category. thanks

$35 USD за 10 дней(-я)
(0 отзывов(-а))
0.0
matrixdataentry

Hello, I just read your proposal and I'm very interested in the position you recently posted. I believe I might be useful for you, as I am very capable of delivering the expected results. It will be a pleasure Больше

$32 USD за 10 дней(-я)
(0 отзывов(-а))
0.0
mercin12

I've created a sample with a data table, summary scores, and the top three rankings for each of the seven categories. Here is a proof of concept: [login to view URL] Больше

$32 USD за 10 дней(-я)
(0 отзывов(-а))
0.0