table-options
table-options


Table template allows you to make from your Google Sheet as a nice looking table on your website. You can embed it to your existing website or create full a website.

Using your own table

table-options

If you have your own table, please select a Teble template first and paste your table into the Cards tab. Template data will be deleted.

Default Sorting

When the user loads the webiste, the initial sorting of the table is the same as in your Google Sheet. If you will change the sorting in your Google Sheet, the website's table sorting will change as well

Column Sorting

Each column can be sorted separately when you click on Table's header. Data type of the column is reacognizing by default.

Current types that are supported:
  • String
  • Date
    • 2020-03-21
  • Number
    • 20000
      20,000
  • Currency
    • $100,000
      40%

Important!
To identify column types correctly please do not add different data types in the cell. For example: You can have a "$100,000" and "Not exist". This will do the sorting not correctly. Please leave the cell empty.

To remove errors like N/A you might use IFERROR formula.

Cell types

If the cell has there data it will shot this cell in a spefific way like a link or an image.
  • Images Links - if the link has .jpeg, jpg, png, unsplash, unsplash table will show the image
  • Links - if the link has http, mailto: it will be shown as a link with a highlighted color.

Search

Searching is executing by all cells in the sheet. If the data is exist in any cell it will be shown.

Filters

Filtering works same as search. It's executing by all cells in the sheet. When the user press a filter button search this it's name. You don't need to add "Filter by this." column as for other templates. Just add your filters into filters tab and it will work.


Table Options

Here are some options that you can use in columns headers.

table-options

  • -Button Make a button for each cell of the column. Example of how you need to name a column header: Learn More-Button.

  • -Hide Hide each column. Might be useful for some calculations. Example of how you need to name a column header: Current Year-Hide

Special Columns

  • $color this column will change the hex code color of the row. It's hidden. Example of how you need to name a row: #f5f5f5