Google Spreadsheet to Google New Sites Script -- 2

Fermé Publié le il y a 2 ans Paiement à la livraison
Fermé 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

CSS HTML Scripting Google Sheets Google APIs

Nº du projet : #31311508

À propos du projet

11 propositions Projet à distance Actif il y a 2 ans

11 freelances font une offre moyenne de 466 $ pour ce travail

AwaisChaudhry

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

$750 USD en 14 jours
(22 Commentaires)
6.7
tushchak0716

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

$425 USD en 6 jours
(11 Commentaires)
4.7
umairkaramat24

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

$750 USD en 11 jours
(8 Commentaires)
4.3
vw1342868vw

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

$650 USD en 7 jours
(10 Commentaires)
3.2
bijoykdas

Hi, I just read your project description. Please message me so I can start your project now and finish it asap.

$500 USD en 7 jours
(3 Commentaires)
1.5