WebSite X5Help Center

 
P-A Solberg
P-A Solberg
User

How to get a Google Sheet to show  en

Autore: P-A Solberg
Visite 876, Followers 1, Condiviso 0  

Hello!

I have created a Google Sheet (*.gsheet), and can't find a way to embed/show it on my X5 site...

I have tried Google Forms Object and the HTML Code Object. None works the way I want! The one that shows something on the site after publishing is the HTML Code Object (the Google Forms Object shows nothing!). But I can't edit it to look good and display everything.

What am I doing wrong? How should the process look for it to work?

Please see attached files for more info.

Hope someone has an answer!

//P-A Solberg

Postato il
16 RISPOSTE - 1 UTILE - 1 CORRETTO
John S.
John S.
User

In Google sheets there is the possibility to get the code needed for embedding

Leggi di più
Postato il da John S.
John S.
John S.
User

Here I have it - sorry it is in Danish - but you should see the same just in your own language.

And then allow public and integrate and you will get the code.

The code is for an iframe.

You just put the code in a html-object in X5 and you will see the document on the page where you place the html-object.

Leggi di più
Postato il da John S.
John S.
John S.
User

You should not download the document. All happens online.

If you choose to let it be published on the web then new content of the sheet, will be seen in the X5 page.

This is a kind of emulating a CMS-system.

You can give extern users access to the online document and then when a client has changed the content it will be published on the X5 page with the html-object with the code for embedding.

Leggi di più
Postato il da John S.
P-A Solberg
P-A Solberg
User
Autore

Great, thanks John!

I follow what you say/mean, and that's what I have done. I need to be more clear. Sorry.

Did you look at the screenshots in the attached file? It's all there, and it follows what you propose... Without working... Unfortunately.

Shall I use the HTML Code Object or the Google Forms Object? And how can I edit the display/visuals?

//P-A

Leggi di più
Postato il da P-A Solberg
John S.
John S.
User

This is the code you should copy and paste into a HTML-object on the X5 page where you want the sheet to be shown.

Once this is done and the project is uploaded to the web, then the sheew will be shown on the X5 page.

It is not the sheet you shall insert on the page - it is the code that Google presented for you

The code in the red circle.

Leggi di più
Postato il da John S.
P-A Solberg
P-A Solberg
User
Autore

John,

it is the code i put in the right field... It does not work anyway...

//P-A

Leggi di più
Postato il da P-A Solberg
John S.
John S.
User

Could you supply with screenshots:

- Screenshot of the page layout for the page in X5

- Screenshot of the content of the html-object

- Link to the page on the web

Leggi di più
Postato il da John S.
Daniel W.
Daniel W.
User
Utente del mese DEUtente del mese EN

I took John S.'s iframe code, added width=70% height=500 and placed it in an HTML object on my test page, see screenshot

-----

Leggi di più
Postato il da Daniel W.
John S.
John S.
User

Yes - either a height should be set in the html-object or a height should be specified for the iframe.

Leggi di più
Postato il da John S.
P-A Solberg
P-A Solberg
User
Autore

Hello!

Thanks for your input. I solved, but I am not pleased. Would love to get some answers. Please look at the attached file.

//P-A

Leggi di più
Postato il da P-A Solberg
John S.
John S.
User

I can not understand you wonder why the code functions in the X5 html-object and does not function in the X5 Google Form object...

I told several times that you should use the html-object. The html-object can be used for CSS, JS and HTML code. And the code given by Gogle is html code. That is why the html-object functions and the form-object does not.

The w3schools.com is a very good site to be familiar with HTML and CSS.

Here is something for the iframe: https://www.w3schools.com/tags/tag_iframe.ASP

Leggi di più
Postato il da John S.
P-A Solberg
P-A Solberg
User
Autore

Thank you John!

Did you happen to see my questions about the width/height field and the Show Scroll bar function in the HTML Object.

And the possibility, or not, to hide/delete some of the things that is showing except just the cells in the gsheet (you can see what I mean in the attached file)?

Sorry about the misunderstanding regarding gsheets and forms... Now I know - thought craze!

//P-A

Leggi di più
Postato il da P-A Solberg
P-A Solberg
P-A Solberg
User
Autore

Thanks once more, John!

Just some thin lines left to get rid off.

Please see attached file.

Can you help or point me in the right direction?

//P-A

Leggi di più
Postato il da P-A Solberg
John S.
John S.
User

I have several suggestions on directions - but the styling of what is inside the iframe has nothing to do with the X5.

I will try to help you, but the non-X5 things should not be on the X5 forum.

You can contact me by using the contact form in bottom of this page: https://bramminginfo.dk/

The answer is "kat"

Leggi di più
Postato il da John S.
P-A Solberg
P-A Solberg
User
Autore

To sum it up:

John gave me a lot of good feedback and suggestions - thanks!

Finally, I decided to stick with and keep on trying the Google Sheet Object and found after testing a lot that it works regarding content but not 100% graphically... So now we use the Table Object instead.

//P-A

Leggi di più
Postato il da P-A Solberg