Google spreadsheet script functions (2)
Required skills: C# Programming, Google App Engine, Javascript
Very simple project...
I need two Google spreadsheet script functions that can be called from the cell of one worksheet to access data in the table of another sheet.
The script functions include...
1) Function – LookupRow(ColName, WorkSheetName, row)
a. Return the last value in the last row for a column by column name or column letter in given worksheet. Optionally, return the value in the previous or following row(s). Example -1 or +1 or any other value. Return valid date (if row cannot be found) return 0.
2) Function – LookupRowDate(ColName, WorkSheetName, date, row)
a. Return the value in the cell in a specific column for a specific row by date found in column A. Optionally, return the value in the previous or following row(s). Example -1 or +1 or any other value. Return valid date (if row cannot be found) return 0.
Sample data is provided in the attached file but will actually reside in a Google spreadsheet document. Please provide a sample of similar work so that I know that you can actually do this job.
Additional files submitted: (Files are only available for logged in users)
Data.xlsx
Posted In: |
Related projects:
Google Spreadsheet Email Script
I get information emailed to me from web forms (i.e. name, phone number) that I would like automatically logged into a Google Docs Spreadsheet.
I'm basically looking for a script for Google Spreadsheet that can scan my email account (say every 60 seconds) for new messages - check the message body for information (i.e. name, phone number) - and log the data into the corresponding columns of an ongoing spreadsheet.
I'm basically looking for a script for Google Spreadsheet that can scan my email account (say every 60 seconds) for new messages - check the message body for information (i.e. name, phone number) - and log the data into the corresponding columns of an ongoing spreadsheet.
Alternative Google Spreadsheet Ui Using Php
a or delete etc), click on Save button and data will be saved to the spreadsheet
5, A page to allow navigation of all data in the table. Default is 100 row per page, and there should be Next and Prev link (like Google search result). The next and Prev link should also be used for search result.
6, A barcode icon is shown on each row, when click on it, it will generate barcode--optional
You can email me for more information, phs.phd at googlemail dot com
5, A page to allow navigation of all data in the table. Default is 100 row per page, and there should be Next and Prev link (like Google search result). The next and Prev link should also be used for search result.
6, A barcode icon is shown on each row, when click on it, it will generate barcode--optional
You can email me for more information, phs.phd at googlemail dot com
One Deal A Day Script + Web 2.0 Design
>
1. Full deals and users management
2. We should be able to add text ads, Flash Ads, etc.
3. Should be easy to maintain the website/ Upload videos/ Pictures/ etc. and easy to organize it as well
4. Automatic Email system (easy to send out automatic emails to registered users)
Please bid only if you already have a turnkey solution ready to be customized as stated. IT's not a simple Groupon clone but something different! please read carefully above, thanks.
2. We should be able to add text ads, Flash Ads, etc.
3. Should be easy to maintain the website/ Upload videos/ Pictures/ etc. and easy to organize it as well
4. Automatic Email system (easy to send out automatic emails to registered users)
Please bid only if you already have a turnkey solution ready to be customized as stated. IT's not a simple Groupon clone but something different! please read carefully above, thanks.
Google Spreadsheet Email Script
number) that I would like automatically logged into a Google Docs Spreadsheet.
I'm basically looking for a script for Google Spreadsheet that can scan my email account (say every 60 seconds) for new messages - check the message body for information (i.e. name, phone number) - and log the data into the corresponding columns of an ongoing spreadsheet.
I'm basically looking for a script for Google Spreadsheet that can scan my email account (say every 60 seconds) for new messages - check the message body for information (i.e. name, phone number) - and log the data into the corresponding columns of an ongoing spreadsheet.
Customized Google Spreadsheet Mapper Project
ust I can purchase a copy of google earth and use that to link to google spreadsheet. In this instance I will still need the Google Spreadsheet Mapper document modified to work with the data from the attached spreadsheet. Once again, Iframe option is desired.
If you're interested in this project please tell me how you would implement what I'm looking for along with your quote. I need this done within the next 24-48ish hours so preference will go to those who respond quickly.
If you're interested in this project please tell me how you would implement what I'm looking for along with your quote. I need this done within the next 24-48ish hours so preference will go to those who respond quickly.
Alternative Google Spreadsheet Ui Using Php
A page to allow navigation of all data in the table. Default is 100 row per page, and there should be Next and Prev link (like Google search result). The next and Prev link should also be used for search result.
6, A barcode icon is shown on each row, when click on it, it will generate barcode--optional
You can email me for more information.
Tags: [New Feature] PHP, Template, Google, Editing, Data Entry, Vector Graphics, Google Spreadsheet PHP
6, A barcode icon is shown on each row, when click on it, it will generate barcode--optional
You can email me for more information.
Tags: [New Feature] PHP, Template, Google, Editing, Data Entry, Vector Graphics, Google Spreadsheet PHP
Google Spreadsheet 2
e Doc to update Sheet 2.
This tutorial may help, http://www.google.com/google-d-s/scripts/writing_spreadsheet_data.html
Please bid if you are available as soon as possible and can complete this today. Thanks.
This tutorial may help, http://www.google.com/google-d-s/scripts/writing_spreadsheet_data.html
Please bid if you are available as soon as possible and can complete this today. Thanks.
Open A Google Doc Script
follow" style="text-decoration: none;color:#68778E" onmouseover="this.style.textDecoration='underline'" onmouseout="this.style.textDecoration='none'">Google.com/docs account
2) will open and name a Document (not a spreadsheet)
3) Will add members to the Document
4) Will add a sentence to the Document (like an "id#")
5) will return a link to the Document
Must have reviews
Must be done in 2 days
33 % escrow as usual
Must have Skype
2) will open and name a Document (not a spreadsheet)
3) Will add members to the Document
4) Will add a sentence to the Document (like an "id#")
5) will return a link to the Document
Must have reviews
Must be done in 2 days
33 % escrow as usual
Must have Skype
Simple add row to google spreadsheet from email
~” signs are used (e.g. if there are 5 “~” characters in the subject, 6 values/columns are present)
- Only information in the subject line should be used to create the new row. Any data in the body should be ignored.
- Login details for the gmail account & google spreadsheet will be provided to the successful bidder.
Many thanks
- Only information in the subject line should be used to create the new row. Any data in the body should be ignored.
- Login details for the gmail account & google spreadsheet will be provided to the successful bidder.
Many thanks
Openid Signup - Login Script
ialdna-openid-connect-facebook-myspace-google
http://sedemo4.socialenginemods.net/
Project is php and javascript and should work well on these browsers
IE7/8, Firefox, Safari, Opera, Chrome
Phil Basten
Sokule Inc
http://sedemo4.socialenginemods.net/
Project is php and javascript and should work well on these browsers
IE7/8, Firefox, Safari, Opera, Chrome
Phil Basten
Sokule Inc
Simple add row to google spreadsheet from email
>
- The script needs to scale if more “~” signs are used (e.g. if there are 5 “~” characters in the subject, 6 values/columns are present)
- Only information in the subject line should be used to create the new row. Any data in the body should be ignored.
- Login details for the gmail account & google spreadsheet will be provided to the successful bidder.
Many thanks
- The script needs to scale if more “~” signs are used (e.g. if there are 5 “~” characters in the subject, 6 values/columns are present)
- Only information in the subject line should be used to create the new row. Any data in the body should be ignored.
- Login details for the gmail account & google spreadsheet will be provided to the successful bidder.
Many thanks
Google Spreadsheet Web Ui Using Php
9/6/2010 at 11:06 EST)...
Important:
**Do not say something like this" pay me how much money and I will get it done in xx days"
** List your capabilities is not relevant. I need a demo before I can select you, your demo should be:
###, Search the spreadsheet and display in a tabular format.
###, click view icon to display data in web page
###, click the edit icon and pull data from spreadsheet display in a form, click submit to update a row
Important:
**Do not say something like this" pay me how much money and I will get it done in xx days"
** List your capabilities is not relevant. I need a demo before I can select you, your demo should be:
###, Search the spreadsheet and display in a tabular format.
###, click view icon to display data in web page
###, click the edit icon and pull data from spreadsheet display in a form, click submit to update a row
Google Spreadsheet 3
This tutorial may help, http://www.google.com/google-d-s/scripts/writing_spreadsheet_data.html
***Please bid if you are available as soon as possible and can complete this within the next 2 hours. Thanks.***
Google Spreadsheet API
Write a PHP script that uses the Google Spreadsheet API to:
1. List the contents of a google spreadsheet: name | company | email
2. Enter an email address into a form and return a true/false if the email is in the spreadsheet
No interface needed.
1. List the contents of a google spreadsheet: name | company | email
2. Enter an email address into a form and return a true/false if the email is in the spreadsheet
No interface needed.
Google image script or plugin
Look through the site and you will see google new, youtube videoes, and google imgaes... The movie posters and trailers come from apple itunes as you can see its a cool plugin.
Here is another example of a custom script: www.shoesstyles.net
This website runs on a custom php script the grabs images from google for the different shoe categories on the website.
If you have any questions feel free to message me....Thanks
Here is another example of a custom script: www.shoesstyles.net
This website runs on a custom php script the grabs images from google for the different shoe categories on the website.
If you have any questions feel free to message me....Thanks
Synchronize a Google Spreadsheet with multiple Google Agenda
We need to Synchronize a Google Spreadsheet with multiple Google Agenda.
All specifications are in Attach file
All specifications are in Attach file
Internet Music Research
t="extlink" rel="nofollow" style="text-decoration: none;color:#68778E" onmouseover="this.style.textDecoration='underline'" onmouseout="this.style.textDecoration='none'">http://www.websitename.com/tourdatespagename/)
4. Optional - paste any interesting info you come across (year singer deceased or band disbanded, etc.)
This project is ready to start NOW. I need the info as soon as possible, hopefully today or tomorrow.
Thanks for looking!
Kerry
4. Optional - paste any interesting info you come across (year singer deceased or band disbanded, etc.)
This project is ready to start NOW. I need the info as soon as possible, hopefully today or tomorrow.
Thanks for looking!
Kerry
Googledocs Api - Create Form On Site To Feed To Spreadsheet
Create a form that will feed into into a Google Spreadsheet using Gdocs API.
The form has ~20 fields.
Basically, if you've ever done anything w/ the Google Docs API, it shouldn't be a big deal.
The form has ~20 fields.
Basically, if you've ever done anything w/ the Google Docs API, it shouldn't be a big deal.
Google Maps Script (API) + map marking from postcode list.
ve different coloured map markers. (So user can select that any postcode with a number in column b between 1 to 10 is a red map marker, 11 to 20 is blue, etc, etc - should give user a drop down of different colours to select from)
- Can hide number range map markers.
*If number column missing, this should just submit all postcodes.
Any questions, please ask.
Thanks,
John
- Can hide number range map markers.
*If number column missing, this should just submit all postcodes.
Any questions, please ask.
Thanks,
John
Create Google Spreadsheet with automatic XML import
Thank you.
Additional files submitted: (Files are only available for logged in users)
freelancergooglespreadsheet.pdf
