WebSite X5Help Center

 
P-A Solberg
P-A Solberg
User

How to get a Google Sheet to show  en

Auteur : P-A Solberg
Visité 1358, Followers 1, Partagé 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

Posté le
16 RéPONSES - 1 UTILES - 1 CORRECT
John S.
John S.
User

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

Lire plus
Posté le de 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.

Lire plus
Posté le de 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.

Lire plus
Posté le de John S.
P-A Solberg
P-A Solberg
User
Auteur

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

Lire plus
Posté le de 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.

Lire plus
Posté le de John S.
P-A Solberg
P-A Solberg
User
Auteur

John,

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

//P-A

Lire plus
Posté le de 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

Lire plus
Posté le de John S.
Daniel W.
Daniel W.
User
Meilleur utilisateur du mois 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

-----

Lire plus
Posté le de 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.

Lire plus
Posté le de John S.
P-A Solberg
P-A Solberg
User
Auteur

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

Lire plus
Posté le de 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

Lire plus
Posté le de John S.
P-A Solberg
P-A Solberg
User
Auteur

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

Lire plus
Posté le de P-A Solberg
P-A Solberg
P-A Solberg
User
Auteur

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

Lire plus
Posté le de 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"

Lire plus
Posté le de John S.
P-A Solberg
P-A Solberg
User
Auteur

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

Lire plus
Posté le de P-A Solberg