Suggestion: combine or merge tables

  • Resolved WPChina

    (@wordpresschina)


    7 years, 6 months ago

    I have a suggestion for the future: combine tables.

    I am creating a daily table of information. Each day I have the same 10 columns, and then 5-10 rows of data.

    In the future, I would like to display all the tables together, or export all the tables together. Basically think of this as a “merge” operation.

    I think I will have hundreds of small tables eventually, so I am thinking of ways of better managing the tables.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks for your question, and sorry for the trouble.

    The best solution might then be to just use one big table, but only display the relevant rows when you want to show small tables.
    You can do that either by using the show_rows, etc. Shortcode parameters, or maybe by using the TablePress Extension from https://tablepress.org/extensions/row-filter/

    To actually merge tables, I recommend to export one of them to a CSV file and then import that again, and choose to append it to an existing table.

    Regards,
    Tobias

    Thread Starter WPChina

    (@wordpresschina)

    Hello: that looks like a great extension and I will buy it if it can handle things in this situation:

    So I will add a new column for “Date”. That way I can keep track in a large table all the info based on Date. But I will “Hide” that column from the frontend because I only need the date on backend.

    If I hide the Date on backend but use the date as the search term like the following, will it correctly filter based on date? I mean, since it is a hidden column can it still be used? Here is a sample shortcode:

    [table id=1 filter="2017-09-22" /]

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    yes, that’s correct ??
    It should be possible to hide the column on the “Edit” screen, or via CSS code.

    Regards,
    Tobias

    Thread Starter WPChina

    (@wordpresschina)

    Ok thank you. I am already implementing~

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    great ?? Good to hear that this will help!
    And thanks again for the donation, I really appreciate it!

    Best wishes,
    Tobias

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Suggestion: combine or merge tables’ is closed to new replies.