Google Spreadsheet to Google New Sites Script -- 2
Budget: $250 – $750 USD
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
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