Google Spreadsheet to Google New Sites Script -- 2
$250-750 USD
Paiement à la livraison
We need a script which makes it possible to use Google Spreadsheet (corporate account) as a lookup database for Google New Sites.
We need a GET command for n columns in Google Sheet to be posted in Google New Sites.
*Google New Site, Search Field
Script should include two search options/fields.
1. a search field which search in 4 columns (column w, x, y, z) to pick and show matching posts
4. a predefined search button with latest changes (data format: "MM/dd/yyyy hh:mm")
2. a drop down menu with the pick of letters in the alphabet
3. a drop down menu with the pick of column x
Search result shall display column x, y and z for all matching rows in a table. One result per row. Limit results to 25, with a show more drop down for 50 and 100 rows.
Latest changes shall display column x, y and z and be limited to 25 results, with a show more drop down for 50 and 100 rows.
Search field layout shall match the table layout (see below)
Search result shall match the table layout (see below)
When post is selected it should post column x to n in a table.
*Google New Sites, Table
The selected content should be posted in a table on Google New Site, below Search Field
Table should be with 2 columns and n rows.
Column 1 should be row 1 in google sheet (heading)
Column 2 should be selected row from search field
*Google New Sites, Table Layout
Row 1 (header) should be #737373 Dark Grey background, white bold text
Row 2 should be #f2f2f2 light grey background, black text
Row 3 should be white background, black text
Row 4 should be #f2f2f2 light grey background, black text
etc.
Column border in #ddd medium grey
hover colour in #ddd medium grey
font-family: Arial, Helvetica, sans-serif
font-size: 14px
text-align: left
td
border: 1px solid #ddd
padding: 6px
th
padding-top: 12px
padding-bottom: 12px
background-color: #737373
color: white
tr
background-color: #f2f2f2
hover background-color: #ddd
*Google Spreadsheet
The text should be imported as rich text to keep the formating in google new sites as in google sheets. Linebreak should be dynamic according to table width.
*Expected result
1 script to paste into google spreadsheet script editor
1 script to paste into google new sites script
Both working together according to the above specifications.
Script with explaining comments.
No external script sources.
Remember European characters; ";" instead of "," etc
Nº du projet : #31311508
À propos du projet
11 freelances font une offre moyenne de 466 $ pour ce travail
Hey there, I have 4 years of working experience in web technologies and I have a strong working knowledge of every possible framework which is in the market. In terms of client-end I know: Scripting, HTML, CSS, Google Plus
Hi greetings from Tushar!! I am interested in taking up your project related to related to creating a search functionality for your google site with google sheet as backend database. I have hands on experience of work Plus
Hello, I read your project details and really interested in your mentioned job. I have 5+ years’ experience doing similar jobs related to these skills HTML, Scripting, Google APIs, Google Sheets and CSS. I think its do Plus
Re: Google Spreadsheet to Google New Sites Script -- 2 Hey there, I have 5+ years of working experience in web technologies and I have a strong working knowledge of every possible framework which is in the market. In Plus
Hi, I just read your project description. Please message me so I can start your project now and finish it asap.