Parent child with calculated column

  • Resolved measy

    (@measy)


    3 years, 3 months ago

    Hi there,

    I’m looking for suggestions about the argument in subject.

    Case example: “cash box” .

    How to design a “parent child” form (project page) where:

    • parent: cashBox name(s) and calculated SUM(withdrawals, say-), SUM(payments, say +) cumulated;
    • child: detailed list of linked operations (optionally filtered by a category (column).

    Starting from daily transactions recording table, I can create a view to SUMmerize * and -, BUT – to the best of my knowledge – I’m not allowed to use this view as the Parent for the details table .

    Any help more than appreciated.

    Thanks

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    3 years, 3 months ago

    Hi Marco,

    It’s not possible to create a parent-child form from a parent view. The plugin needs a primary or unique key and a view simply does not have those.

    But you can create your own parent-child implementation with dynamic hyperlinks. You can even add your own icons as shown on the page below and link your icon to specific pages and actions.

    https://wpdataaccess.com/docs/data-explorer-settings/dynamic-hyperlinks/

    Please be aware this does not work with Data Forms. This works on the back-end and on the front-end with shortcode wpdadiehard.

    Does this helps?
    Peter

    Thread Starter measy

    (@measy)

    3 years, 3 months ago

    Hi Peter,

    thanks a lot for your suggestion on hyperlink usage (great! ).

    I tried to replicate your idea to my “casBox” case:

    1. PARENT (VIEW): cashBox_id, balance(coins in the cashbox 🙂 ), In (-)  and Out (+) transactions balances:

    CashboxA, Balance=100, Ins=130, Outs=30

    CashBoxB, Balance=1000, Ins=3550, Outs=2550

    1. CHILD: (Table): list of transactions per CasBox_Id (A or B)

    making the Balance column an Hyperlink in Premium Data Explorer/Colums Settings

    I got a red message “…Error: contact the Pluging Development team”, or similar.

    I argue it’s connected to the VIEWs approach, meaning you cannot Design a View in WPDA, but writing an SQL CREATE OR REPLACE VIEW code in WPDA SQL Queries (views are not listed  in WPDA Designer list), while I was able to try and set the Hyperlink type in the view column Balance, via WPDA Explorer.

    Any help more than appreciated.

    Plugin Contributor Kim L

    (@kimmyx)

    3 years, 3 months ago

    Hi @measy,

    Apologies for the late update on this post. 🙏

    You’re correct, VIEWS cannot be loaded to the Data Designer.

    May we know when (in your test, while adding rows, or while managing column settings) you saw the error message and could you post the full message as well?

    We’ll wait for your response!

    Thread Starter measy

    (@measy)

    3 years, 3 months ago

    Hi Kim,

    thanks for your reply (yeah, a bit late 😉 ):

    the issue is no more opened, views being not usefull for parent/child forms.

    This topic canbe closed, but linked to the other one: Parent-Child (view mode)

    Best regards,

    M.

    .

    Plugin Contributor Kim L

    (@kimmyx)

    3 years, 3 months ago

    Thanks for the response, @measy.

    I’ll be closing this thread now and will check your newer topic. 🙏

    Cheers!

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

The topic ‘Parent child with calculated column’ is closed to new replies.