Okay
  Public Ticket #1550624
wpdatatables function
Closed

Comments

  • Ryo started the conversation

    Good morning,

    Can you tell me if your software would allow me to achieve the following objective?

    create 03 web forms table :

    1) with an authentication page and password for accounts (Service 01, Service 02, Service 03)

    2) a basic entry as on excel, in line by line mode with pre-formatted fields, some of which are mandatory (such as only numbers, letters, date, or multiple choices etc.)

    3) with a display of all entered lines and with the possibility to modify a line in case of error.

    4) with an option on the web page to export the desired table (Service 01 and/or Service 02 and/or Service 03)

    and that these 03 forms are linked to a Mysql database ( I am under XAMP).

    Example : - service 01 create a line filling in the column "ISSUE DATE" and "SERVICE". - service 02 create another line by filling in the column "CITY" and "TOTAL". - as soon as service 01 or 02 validates its line, I wish that service 03 can have the concatenation of all the ranges of columns that services 01 and 02 will have filled over the water (in real time of course, it is the goal to do it through a database).

    In other words, what interests me is that the columns are "data ranges" that I can transpose onto "simple entry pages" and then pass them on to a "general pages" comprising all the data at once.

    And when I speak about page of seizure, I speak of course of a page of seizure through a single Web page ! Each to his web page with these data to fill and a final web page includes the visualization of all data.

    In short, I just need a basic web entry sheet that should look like an excel entry sheet (with fixed columns and rows that increment as they run).

    is that possible?

    Sincerely,
    Ryo

  • [deleted] replied

    Hi Ryo,
    Thank you for your request.

    1. Unfortunately we do not have authentication page at this moment but it shouldn't be a problem to find other plugin to do this part.
    2. We support two table engines which both support inline editing and one of them support editing through form in modal as well
        Creating editable tables in WordPress using wpDataTables
        Excel-like editor in WordPress
    3. All entered data could be edited later

    4. Only tables created with first table engine could be exported - Documentation

    All data entered through editable tables (either manually created or from MySQL query) are stored in MySQL. If you want to have one table with all the data and three tables that contains only part of that data best way to do it would be to create one table in MySQL which will hold all the data and then create three tables in wpDataTables from MySQL query which will contains only the columns that are relevant to that table. And then when you populate those three tables data will be stored in one place