Table data whereabouts

  • Resolved hj

    (@hj)


    9 months, 2 weeks ago

    I’m just trying out the free version of Tablesome. I’ve imported a table from an Excel (.xlsx) file – a 4 column table with 1000 rows. This seems to have gone rather well, I’m impressed.

    But I’m curious to know where all the data in this table (all text fields) is stored? Does Tablesome create its own MySQL tables within the WP database? Or is the data held in wp_meta or somewhere? It’s less than 100kb I think, but I’m still curious to know where the data is?

    Still exploring, but looks like a promising plugin for my use case.

    thanks
    HJ

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author Essekia

    (@essekia)

    @hj

    Tablesome creates its own tables with names like wp_tablesome_table_100

    Thread Starter hj

    (@hj)

    Thanks for confirming that – I prefer for data to be stored in new tables like that; some other plugins throw the data into wp_posts or wp_terms, which I’m not so happy about because it mixes up regular posts with table data.

    So that’s a plus for me, thanks.

    One further question: the pro version suggests you can add an extra ‘checkbox’ column to a table. Could the checkbox be styled so that when checked it is red, when unchecked it is green? I’m thinking of a booked-in/booked-out system for a small library. If an admin user could check a box when an item is out on loan, that would be very handy.

    Thanks.

    Plugin Author Essekia

    (@essekia)

    @hj You can use some custom css like:

    .tablesome__cell input[type=”checkbox”]:checked { accent-color: red; } to achieve this:

    https://postimg.cc/ZBW9kQ4h

    For unchecked state, you can try this: https://stackoverflow.com/questions/58792366/cannot-set-background-color-for-unchecked-checkbox

    Will try to add in-built support for this.

    Thread Starter hj

    (@hj)

    Thank you for those ideas, your red ‘checked’ box is perfect. When I think about it, it’s not absolutely necessary to have any color for an unchecked box – if any item is ‘red checked’ it simply means it’s out on loan.

    To be honest I don’t quite understand the use of checkboxes in a table display. On the plugin page under PRO, one of the PRO benefits is…”Add clickable Checkbox columns”. For whom would these checkbox columns be of use? For an admin? Or for a public viewer? In my library scenario, a checkbox might only be ticked or altered by an admin; a public viewer would have no interaction with a checkbox, it would simply indicate the loan status of an item (book or pamplet etc.)

    I looked in the docs but couldn’t find anything to explain the usage of the checkbox column. So although it sounds good, I’m not sure I understand it!

    Plugin Author Essekia

    (@essekia)

    @hj Typical the checkbox is used only by the admin and is read-only for the users.

    Using frontend editing feature, you can choose to let specific users update all or their own entries.

    Thread Starter hj

    (@hj)

    OK, thank you for clarification. Perhaps it might be best to try it under the free Pro trial, first. I think I’ll do that.

    HJ

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Table data whereabouts’ is closed to new replies.