Request: Events list

  • Resolved archesis

    (@anchises)


    7 years ago

    I was thinking about using TablePress to display a simple “calendar” or rather an “events list”. I know there are other plugins, which can do that but they are too comprehensive, I would really prefer a simple solution.

    In general it would be doable with TablePress, I can enter the date for example as “yyyy-mm-dd” and sort it that way (or enforce sorting with extension “Table Row Order”)

    The only problem is of course, that ALL dates are displayed in the output, you need to delete past events manually, you can’t set a (variable) date-range for the frontend. For example: Show only dates starting from today, so that events from the past are not displayed. Or in the backend: Delete all rows before a certain date to clean up the table.

    So basically what is needed:

    1) Designate a column as containing dates (either in the backend table editor or via shortcode, like “date_column=A”)

    2) Use a setting in backend or even better a shortcode to regulate the output, for example “startdate=-3” to show dates starting three days before today and “enddate=21” to display the next 21 days.

    3) Optional: Have a function in the backend like “Delete events before yyyy-mm-dd” to clean up the table.

    I think people (including me) would pay money for such a simple, yet effective solution.

    • This topic was modified 7 years ago by archesis.
Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    thanks for your question, and sorry for the trouble.

    Unfortunately, I don’t have a solution for all these requirements, but the TablePress Extension from https://tablepress.org/extensions/row-filter/ and its cousin https://tablepress.org/download/extension/tablepress-row-filter-date.zip (see inside the PHP file for some usage instructions) might be a starting point.

    Regards,
    Tobias

    Thread Starter archesis

    (@anchises)

    Thanks. I will look into it.

    I guess the minimum requirement would be to display all rows, which include a date in the future. Do you think this is possible?

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    that’s what the second extension that I mentioned can do ??
    If you install it, you can then use a Shortcode like

    [table id=123 filter_date=future /]

    Regards,
    Tobias

    Thread Starter archesis

    (@anchises)

    Sorry, I tried and it does not work.

    Which format does the date have to be?

    I guess it would be easier if I could specify which column contains the date I would like to filter.

    • This reply was modified 7 years ago by archesis.
    • This reply was modified 7 years ago by archesis.
    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    the filtering should actually recognize quite a few formats, including standard formats like MM/DD/YYYY.
    To set a specific filter column (by default, all columns are searched), you can use

    [table id=123 filter_date=future filter_date_columns=1 /]

    If it still doesn’t work, can you please post a link to the page with the table where this problem happens, so that I can take a direct look? Thanks!
    And just to be sure, you have installed and activated the TablePress Row Filtering based on date Extension as a WordPress plugin on your site?

    Regards,
    Tobias

    Thread Starter archesis

    (@anchises)

    Thank you, setting the column did the trick – my suspicion was correct ??

    I am using YYYY-MM-DD and it is working now.

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    no problem, you are very welcome! ?? Good to hear that this helped!

    Best wishes,
    Tobias

    P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Request: Events list’ is closed to new replies.