FRE003 – An onOpen function for a Google spreadsheet

The Google spread sheet below has one sheet, Requests, which, at the moment, has four columns: date, time, id and category and may be invoked by :

[url removed, login to view]

I will generate URLs such as that above but with additions such as &id=271&category=GER007, etc.

[url removed, login to view]

Although Google displays a slightly different URL, the added values are preserved.

I require an onOpen function that extracts the defined values (in this case id and category) and writes them into the next empty line in the Results sheet in columns whose headers correspond, in this case to id and category. The data and time of the entry are similarly written. Once this done the default is that the spreadsheet is closed (and thus not displayed at all. There is no reply to the calling process that invoked the entry. If, however, the URL contains the phrase &visible=true, then the spreadsheet is displayed and the user must close it themselves.

The aim is to include URLs (or aliases) in emails with appropriate id and category values that enable the user to click or not as they wish.

The above sheet is quite open, please look at it. I would be grateful if you did not change it.

I believe this to be quite a simple project for a Javascript developer familiar with working in a Google environment.

Habilidades: Google App Engine, Javascript, PHP, Arquitetura de software

Veja mais: spreadsheet javascript, spreadsheet in javascript, onopen google spreadsheet, look for a developer, google-docs.com, google docs.com, google developer javascript, docs google com, docs. google, developer google com, google spread sheet, google docs sharing, google docs is, docs.google.docs, google spreadsheets, google sheet, javascript spreadsheets, php edit google spreadsheet, google spreadsheet sheet, google spreadsheet function

Acerca do Empregador:
( 265 comentários ) United Kingdom

ID do Projeto: #7495038

7 freelancers estão ofertando em média $486 para esse trabalho


Hi Thanks for your valuable time. :-) Just reply with 'Yes' and We will come up with a. Detail project plan with our comments/queries. b. Best-feasible-real COST & TIMELINE We will provide you a. Best Mais

$747 USD in 30 dias
(537 Comentários)

Hello, I am happy to help you with this task. I will need access rights to your sheet, my Google ID is not allowed to post here (since it is an email), I will send it to you once the project starts. Please let me Mais

$333 USD in 5 dias
(54 Comentários)

========Please Don't award this project to us without discussing this project in detail============ Hi, I (Myself a senior PHP, ASP.NET programmer using C# and VB) have a team having experience of more than 10 years i Mais

$793 USD in 15 dias
(27 Comentários)

Hello, I can help you, I have skill with Google App Engine with the PHP/Python/Java. We can create one applications hosted in GAE. I working with Google apps products have a been 3 years, I already worked in one the pr Mais

$500 USD in 7 dias
(3 Comentários)

Greetings, We have gone through your requirement and would to take this opportunity to work on this project. Can you send a detailed requirement about your project. Feel free to browse through given below po Mais

$526 USD in 10 dias
(9 Comentários)

Hello, I'm an experienced google apps developer. If you look at my project history my last project is done in google apps and I got a one work in progress that is done and I'm waiting to get reviewed. I'm currently Mais

$250 USD in 3 dias
(3 Comentários)

Hello There, This is Jennifer. I have just read your brief and found it to be falling in our expertise domain. We are very well versed in Our team has 4 years of experience in website designing and develo Mais

$555 USD in 10 dias
(0 Comentários)

Change your plan don't use an on open function! Use Google forms instead (created in around 10mins) These can be automatically populated in a url which submits immediately adding a line to a spreadsheet exactly as Mais

$250 USD em 1 dia
(0 Comentários)