WebSite X5Help Center

 
Alan C.
Alan C.
User

Financial Table with Totals  en

Author: Alan C.
Visited 462, Followers 1, Shared 0  

Hi, Is it possible to create a Financial Table in Website X5 that will calculate Totals.

Thanks Alan

Posted on the
21 ANSWERS - 2 USEFUL - 1 CORRECT
Daniel W.
Daniel W.
User
Best User of the month EN

Describe exactly what the table is supposed to calculate, maybe the Javascript experts can create a code or say where this code exists.

I'm not a Javascript expert and only after a long search on Google can I possibly find a code that roughly corresponds to what you looking for.

Here I found a simple calculation function and pasted the code into an HTML object. This is just an example, as it is not known exactly what you are looking for.

Test page >> https://findelinks.de/123shop-hosteurope/mit-javascript-rechnen.html

Read more
Posted on the from Daniel W.
Alan C.
Alan C.
User
Author

Hi Daniel, I am looking for something like an Excel Spreadsheet to total 5 currency amounts in one column. The amounts could be debits or credits.

Read more
Posted on the from Alan C.
Daniel W.
Daniel W.
User
Best User of the month EN

Should the "Financial Table" look something like this?

-----

Currency 1 [____]

Currency 2 [____]

Currency 3 [____]

Currency 4 [____]

Currency 5 [____]

       [ Calculate ]

       Total [_____]

-----

Then the Javascript experts would have to write the code to process the entered numerical values, which can be positive or negative, into a final sum, which can be positive or negative.

Read more
Posted on the from Daniel W.
John S.
John S.
User

You could use GoogleSheet for that.

Create a table in Google sheet.

Make that sheet public (view, not edit) and then let Google give the link to the sheet.

Mage a page in X5

In/on that page you place a html-object in which you define an iframe. For the iframe use the url given by Google.

You will then find that your sheet is shown on your X5-page.

When you in Google edit the sheet, the changes will be shown on your page without the need to upload your project. If you share the sheet (edit) with someone else, then this other person will be able to edit the sheet and it will be shown on your page as well.

No special code is needed for this, apart from the "code" for an iframe.

Read more
Posted on the from John S.
 ‪ KolAsim ‪ ‪
 ‪ KolAsim ‪ ‪
Moderator
Best User of the month FRBest User of the month PL
Alan C.
Hi, Is it possible to create a Financial Table in Website X5 that will calculate Totals. Thanks Alan

... this is an old, simple and elementary INTERACTIVE example of mine, made with OO.o.Calc and exported to Google Spreadsheet:
>> google_online_calculation_K
...can be loaded with a click in the ShowBox, or via elementary IFRAME...

.

ciao

.

.

Read more
Posted on the from  ‪ KolAsim ‪ ‪
John S.
John S.
User

@Alan

I advice you to use the "clean" GoogleSheet and use the code that then is supplied from Google for the document.

The ontent will then only be the "table" without all the stuff around it. It is the normal way to use Google docs or sheet.

Here: https://www.gordingarkiv.dk/arkivpersonale.html You can see an example where GoogleDocs is used.

You only see the content of the document. It uses the URL that GoogleDocs supply for the document.

Read more
Posted on the from John S.
John S.
John S.
User

It is rather simple:

If you dont have a Google account, then get one.

Create a GoogleSheet with the content you need.

Make the sheet publish.

Share online (Google supply you with the code to use on your page)

And that's it.

If you are having trouble with that, then we can guide you.

Read more
Posted on the from John S.
John S.
John S.
User

Example

And then you get the code for the iframe.

:

Read more
Posted on the from John S.
Daniel W.
Daniel W.
User
Best User of the month EN

I found a simple code on a German site that works on the site, but when I paste the code into an HTML object in WebSite X5, the code no longer works.

Maybe the Javascript experts know where the error is or what needs to be changed.

The code would be ideal and could easily be extended to 5 or more input fields if it worked too.

>> https://werner-zenk.de/javascript/zahlen_autom_addieren.php

----- Website werner-zenk.de -----

----- My Test page -----

Read more
Posted on the from Daniel W.
Daniel W.
Daniel W.
User
Best User of the month EN

I have now found the error, the code shown on Werner Zenk's website is incomplete.

I copied the code from the source, added more input fields and changed the label.

The code in the HTML object can only be used once per page, otherwise errors will occur.

Information on how to use the code and the code used can be found on my test page, see

>> https://findelinks.de/123shop-hosteurope/mit-javascript-rechnen.html

-----

Read more
Posted on the from Daniel W.
Daniel W.
Daniel W.
User
Best User of the month EN

I changed the look of the table in WebSite X5 settings.

----- Screenshot -----

Read more
Posted on the from Daniel W.
Alan C.
Alan C.
User
Author
John S.
You could use GoogleSheet for that. Create a table in Google sheet. Make that sheet public (view, not edit) and then let Google give the link to the sheet. Mage a page in X5 In/on that page you place a html-object in which you define an iframe. For the iframe use the url given by Google. You will then find that your sheet is shown on your X5-page. When you in Google edit the sheet, the changes will be shown on your page without the need to upload your project. If you share the sheet (edit) with someone else, then this other person will be able to edit the sheet and it will be shown on your page as well. No special code is needed for this, apart from the "code" for an iframe.

Hi John S
Thanks for the Google Sheet option. After getting the Google Link I added the HTML option to the webpage and then copied the Google Link.  However, all that I see is the URL and not the actual Google Sheet on view. See attached. Any ideas as to why it does not display as the Google Sheet?
Thanks   AlanC

Read more
Posted on the from Alan C.
Daniel W.
Daniel W.
User
Best User of the month EN

For anyone looking for an online spreadsheet for their website, here are some providers that are mentioned on the Wikipedia website.

I don't use any of these services myself and therefore have no experience with them.

----- Translated with Google -----

Online spreadsheets are spreadsheet programs that are designed as web applications , meaning they can be run in a web browser without a separate installation .

...

Provider (selection) 

  • EtherCalc is a service based on the open source software of the same name . The project is similar in nature to online spreadsheets as EtherPad is to collaborative text writing.
  • Google Sheets is free and easy to use. It saves automatically, but has limited functionality. As is usual with Google , the software goes througha long beta phase and is continually being developed further. A Google account is required to use it.
  • LibreOffice Online Calc
  • ThinkFree Office , the office package from the US-based ThinkFree Corp. , has almost the same range of functions as Microsoft Office including printing function, preview and spell checker. The ThinkFree programs are based on the Java platform and require a corresponding browser plug-in . In addition to the online service , ThinkFree also offers the software as a downloadable server edition.
  • Worksheet server from the German Jedox AG creates independent, multi-user web applications from Microsoft Excel workbooks. All common table functions, cell formatting and the most important Excel chart types are supported. Optionally, relational and multidimensional databases ( MOLAP ), SAP servers and LDAP servers can be accessed using an integrated ETL interface .

>> https://de.wikipedia.org/wiki/Online-Tabellenkalkulation (German)

-----

Read more
Posted on the from Daniel W.
Daniel W.
Daniel W.
User
Best User of the month EN

Here are excerpts from the Google instructions.

----- Translated with Google -----

Embed files

You can make a document, spreadsheet, presentation, or form available to view on an existing website by embedding it in your site or blog.

Embed a document, spreadsheet, or presentation

  1. Open a file in Google Docs, Sheets, or Slides.
  2. At the top, click Fileand thenShare and then Publish to web.
  3. In the window that appears, click Embed.
  4. Choose a publishing option:
  • Spreadsheet: Choose to publish the entire spreadsheet or individual sheets.
  • Presentation: Choose a presentation size and how quickly to change the slides.
  1. Click Publish.
  2. Copy the HTML in the text box and paste it into your site or blog.

Edit embedded spreadsheets

If you’re embedding a spreadsheet, you can show or hide parts of the spreadsheet after you publish to the web.

  1. Open a file in Google Sheets.
  2. At the top, click Fileand thenShare and then Publish to web.
  3. In the window that appears, click Embed.
  4. Click Publish.
  5. Copy the code in the text box and paste it into your site or blog.
  6. To show or hide parts of the spreadsheet, edit the HTML on your site or blog.
  • gid=: The sheet ID.
  • range=: The rows and columns that are published to the web. For example, A1:B14.
  • widget=: True or false. If true, the sheet tab is displayed at the bottom.
  • headers=: True or false. If true, row numbers and column letters are displayed.
  • chrome=: True or false. If true, the title and footer are displayed.

-----

Read more
Posted on the from Daniel W.
Daniel W.
Daniel W.
User
Best User of the month EN

Since I don't use any of the Google services mentioned, the copied code probably has to be pasted into an HTML object.

Read more
Posted on the from Daniel W.
Daniel W.
Daniel W.
User
Best User of the month EN

For a URL, an iframe code would have to be used in the HTML object.

----- Example -----

<iframe src="https://docs.google.com/spreadsheets/xxxxxxxxxxxxxxx"></iframe>

Read more
Posted on the from Daniel W.
John S.
John S.
User

@Alan

Could you show us the code you put into the html-object? Or give us a link to the page where the code is?

Read more
Posted on the from John S.
John S.
John S.
User

Oh - just saw your attachment. The code looks wrong. It should be something like this :

Read more
Posted on the from John S.
John S.
John S.
User

When you have it to function you will maybe find that the size of the iframe is not as you want it to be.

Tell what size you want and then post a link to your page and I will post the code to use in the html-object.

Read more
Posted on the from John S.
John S.
John S.
User

In this post: https://helpcenter.websitex5.com/en/post/264400#comment8

I have shown how to get the code from the sheet.

I am not quite sure how the terms is in English but I think it is much like:

In the menu line for the file choose File (fil)

Then choose Share (del)

And Publish on the net (Offentliggør på nettet)

Then choose Integrate (integrer)

And finally copy the code that is shown (<iframe scr="htt..............)

And copy this code into the html-object.

You should then see the sheet shown on your page.

Read more
Posted on the from John S.