jQuery DataTables

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Contributor Kim L

    (@kimmyx)

    1 year, 3 months ago

    Hi @johanselbing,

    The Advanced Settings for the old legacy table builder should still be in the same place as the screenshot you linked.

    See here: https://share.zight.com/kpuzrmQR

    If you’re looking for a similar setting in the new App Builder, the alternative would be the Hooks feature.

    You can learn more about it here: Getting started with hooks | WP Data Access

    Let us know if you have more questions. 😊

    Thread Starter johans

    (@johanselbing)

    1 year, 3 months ago

    Thank you. I’m learning hooks and it seems like an easier option than to use the old legacy builder, but I’m running into some problems of how to implement it for a specific case.

    What I’m trying to do involves breaking up the user interface a bit, with a WordPress front-end with a single “Project edit” page containing a simple sidebar listing the names from a table projects, and next to it a data administration app for a row in the table projects + below a chart table with a list of all costs for the project. When clicking on a row in the sidebar, the data administration app jumps to edit that project and lists the costs of the project. So, basically I want to connect three apps on the same page with each other.

    My idea is to set up the sidebar as an app that uses a hook to link projects.name to the “Edit project” page with a PHP query containing projects.id. Possibly I could get the query with the Code Manager app, but how do I then pass projects.id to the shortcodes of the apps? Or are there simpler solutions?

    • This reply was modified 1 year, 3 months ago by johans.
    • This reply was modified 1 year, 3 months ago by johans.
    • This reply was modified 1 year, 3 months ago by johans.
    Thread Starter johans

    (@johanselbing)

    1 year, 3 months ago

    Or could I use hooks in one table to navigate and filter another table on the same page?

    Plugin Contributor Kim L

    (@kimmyx)

    1 year, 3 months ago

    Hi @johanselbing,

    I’ve forwarded your use case to Peter to see if it’s possible with hooks.

    I’ll let you know once I receive a feedback from him. 🙏

    We appreciate your patience!

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    1 year, 3 months ago

    Hi @johanselbing

    You can combine several apps into a single data app. A demo is available here:
    https://wpdataaccess.com/docs/app-demos/app-classic-models/

    Relationships can also be added to a data entry form, giving the user access to several detail tables from within the form. Using the link I provided above, you can observe this behavior in action. Click the hamburger menu, choose Customers, and edit one of the customers that appears.

    It is not yet possible to call another app from a hook, but it is planned. Form hooks will be included in the upcoming update. We can then begin adding a feature that allows us to call apps from hooks.

    Does this help?

    Best regards,
    Peter

    Thread Starter johans

    (@johanselbing)

    1 year, 3 months ago

    Thanks Peter, I built a fully operational database with different relationships between tables with the new App builder, and it works really well!

    But for the front-end it seems some features are not fully implemented or at least not documented. For example, I found out I can use filters on the wpda_app shortcode, which is great. If I create an app for the table projects, is there any way I can use a wpda_app shortcode for the app to jump directly to the edit page of a specific row in the table, instead of listing all the rows?

    Plugin Contributor Kim L

    (@kimmyx)

    1 year, 3 months ago

    Hi @johanselbing,

    Thanks for the response.

    Shortcode parameters are mainly used as filters, so they can’t directly open a row’s form view.

    You can read more about the shortcode parameters here: Shortcode parameters | WP Data Access

    Have you tried modal forms in your data administration apps? It might work a bit for your use case.

    Here’s a demo: https://share.zight.com/Apuo2Bky

    Hope that helps! Let us know if you have other questions.

    Thread Starter johans

    (@johanselbing)

    1 year, 3 months ago

    Thanks, I guess modal forms is enough at this point, but it would be handy if it would be possible to somehow jump to the edit page in a form. Anyway, thanks for now.

    Plugin Contributor Kim L

    (@kimmyx)

    1 year, 2 months ago

    Hi @johanselbing,

    Thanks for the response!

    Peter is still developing form hooks so it might be possible in the future as development progresses.

    Let’s keep our fingers crossed. 😁

    Let us know if you have other questions!

Viewing 9 replies - 1 through 9 (of 9 total)

The topic ‘jQuery DataTables’ is closed to new replies.