Sorting a HTML column

[kitty77]

I'm using the export html feature and I get a static html page. I would like to be able to sort the html columns.
But I can only seem to export a static html. Any way to do what I'm asking?

Thanks...

 

[arnelgp]

you create a Query from your Table and Sort it on the Column of your choice.
Export the query instead of the table.

 

[kitty77]

Yes but the exported html is only static.

 

[arnelgp]

i'm afraid it is static.
if you know javascript or ado programming you can make it dynamic/updateable?

 

[kitty77]

Was hoping I could find a tool that would convert it. Maybe from excel to html or something.
I don't know javascript or ado to the level.

 

[theDBguy]

Was hoping I could find a tool that would convert it. Maybe from excel to html or something.
I don't know javascript or ado to the level.

HTML pages are static. To make them dynamic, you'll need to use something like JavaScript. If you do that, you'll also need to store the data to sort them. You could try storing them into an array. In addition, you'll need a sorting routine.

 

[arnelgp]

here is a demo of what i found.
i frankenstein some code and create a Function to
create an HTM file out of table/query.
the resulting HTM is sortable.

you call the function:

Call TableToSortableHTM("yourTableName")

open the .htm (on Document folder).
you can Click on the Header and it will sort.

 

[oleronesoftwares]

The link below explains is simple terms how you can add sorting functionality to a html table, you can copy the code, but little knowledge of java script is needed

https://www.w3schools.com/howto/howto_js_sort_table.asp

 

[kitty77]

here is a demo of what i found.
i frankenstein some code and create a Function to
create an HTM file out of table/query.
the resulting HTM is sortable.

you call the function:

Call TableToSortableHTM("yourTableName")

open the .htm (on Document folder).
you can Click on the Header and it will sort.

Thanks for the example! Can you explain how I make the module work? Not familiar on how to call it or use it. Sry...
I think this will work.

 

[kitty77]

Just now sure how it produces the html?