READ BEFORE BIDDING: Automate a google sheet checkboxes and list results. Use Google Apps Script

We have a google sheet we use to get selections from clients. Currently only category checkboxes work to select each group (See screenshot and google sheet link). We need both group checkboxes to set state to ON or OFF and we need the individual checkboxes to work. Also all checked items should appear in the "Selected states" and "Selected Industries" columns. It should be real-time and not reply on pressing a button. There is also a similar structure needed on the tab "contact selection". The link to view the sheet is here. Make you own copy so you have edit ability and can test it.

You will need to use google apps script to make this work.

[login to view URL]

General Behavior of how sheet should work (READ)

example: checking "Agriculture" should add





Unchecking Agriculture should uncheck





Also, individual items should be able to be checked/unchecked.

All items appear in the list associated with the section. No blank lines in the lists.

To show that you have read this posting. review the sheet attached and put the name of one of the INDUSTRY GROUP headers as the first word in your bid. Please don't ask to do this project in Excel.

Good luck and be specific in your bid. We do not accept generic bids.

Beceriler: Google Sheets, Google App Motoru

Daha fazlasını gör: google maps marker list, sync google desktop todo list, service automate excel sheet companies, google map category list add marker, google maps based list cities, google map sharepoint list, google maps route list, dynamic google map sharepoint list, google map show list points, xls sheet exhibitor list contacts profile, google sites copy list page, google maps dealer list, ordered list order position google app engine, create list shops use google map api, read before bidding, read before bidding), twant to buy an existing bidding website (like freelancer) existing only! please read before bidding or you will be ignored, twant to buy an existing bidding website like freelancer existing only please read before bidding or you will be ignored

İşveren Hakkında:
( 221 değerlendirme ) Oconomowoc, United States

Proje NO: #27878204



Agriculture .. Hello, I can do it. I work lot in google app script which you can see in my profile .. Checked item should be on selected list on real time and if you check on the header then all of item which is listed Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 30%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(3 Değerlendirme)

Bu iş için 3 freelancer ortalamada $33 teklif veriyor


Agriculture I've gone through your description and read your instructions,and understood what you want and I'm ready to deliver.

$35 USD in 3 gün içinde
(0 Değerlendirme)

Hello I have gone through your requirements. I have 5 plus experience in these types of work. If you feel confident with me please let me know. I would be happy to assist you

$33 USD in 3 gün içinde
(0 Değerlendirme)