Tablepress usage

  • Resolved hergimenez

    (@hergimenez)


    7 years, 6 months ago

    Hello
    I find this plugin pretty nice and I would like to use it to manage a flight school. Based on that, I have a couple of questions that I could not find an answer here. I will appreciate any help.

    I need 5 tables. Planes, Instructors, Pilots, Students, Flight history.
    Lets supposed that flight school administrative employee wants to charge in tablepress 1 flight in flight history table.
    Is there any chance to:
    1- From flight history table, pick up value from Instructors/Pilots/Students/Plane involved in that flight?
    2- Once loaded flight duration in flight history table, Sum that flight time to: Instructor flight time, student/pilot flight time , Plane flight time,etc.
    3- Have a clear visibility of the flight history table, where administrative employee can filter by date and see every flight performed on that date?

    Thanks very much in advance,
    Looking forward to implement Tablepress on my site and start working with it.

    • This topic was modified 7 years, 6 months ago by hergimenez.

    The page I need help with: [log in to see the link]

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.

    1) No, sorry, such a combination of data in the tables is not possible. For this, you would need an actual database management system, e.g. based on mySQL and then use e.g. JOIN SQL queries.

    2) TablePress does support basic math formulas, but not for times/hours/minutes, unfortunately.

    3) Filtering is possible by typing in the date, or maybe by also using the TablePress Extension from https://tablepress.org/extensions/datatables-columnfilterwidgets/

    But as 1) is the major requirement here, I think, TablePress will probably not be the best solution here.

    Regards,
    Tobias

    Thread Starter hergimenez

    (@hergimenez)

    Tobias. Thanks very much for your response.
    1- so sad that cannot use this great plugin with that purpose ??
    2- That would not be an issue. I just need to sum decimal numbers. 1 , 1.2 , etc. I assume that is possible?
    3- Filtering options might be very helpful. Will try that extension and see if as a whole this package of things can work for me.

    Thanks again

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    2) Yes, see https://tablepress.org/tablepress-features-formulas/ for an explanations of how formulas work.

    Regards,
    Tobias

    Thread Starter hergimenez

    (@hergimenez)

    Thanks Tobias
    Sorry to bother. Do you know any way to work on requirement number 1 with WordPress?

    Hernán

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi Hernán,

    no, sorry, I’m not aware of a solution that would not require custom programming ??

    Regards,
    Tobias

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Tablepress usage’ is closed to new replies.

Tags