• Resolved gpanton

    (@gpanton)


    I have a set of tables in a 4 level hierarchy: Property is in Street is in Zone, and each property has two sets of attributes: Footnotes and Pictures. Opening Property as the master gives the view I want but if I open Street as the master I just get Properties as the child and cannot see its attributes. Likewise if I open Zone I can only see Street and not its Properties. Is there any way to get a smooth navigation through all the levels?

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

    (@peterschulznl)

    Hi @gpanton,

    The plugin supports only two levels. You can use dynamic hyperlinks to add additional levels, but that does not (yet) work with Data Forms. Dynamic hyperlinks are explained here:
    https://wpdataaccess.com/docs/documentation/data-explorer/dynamic-hyperlinks/

    Does this help?
    Peter

    Thread Starter gpanton

    (@gpanton)

    Hi Peter
    Thanks for clarifying. It may take me a while to work out if this helps.

    I think the main thing I would like to do is just 3 level:

    Make the main navigation to be Street/Property.
    Then from the property child form, to be able to see the footnotes and pictures.

    Regards
    Graham

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi Graham,

    Multiple level support is planned for the future but only with Data Forms (premium). On backend pages and shortcode wpdadiehard it would become a mess. But you can use dynamic hyperlinks.

    Good luck πŸ™‚
    Peter

    Thread Starter gpanton

    (@gpanton)

    We are already on Premium. Does that affect anything we can do now? What timescale for the update (months/years?)

    Thread Starter gpanton

    (@gpanton)

    Hi Peter

    One further feature has since emerged. The entries under Data Designer couldn’t be edited – wrong schema. I got into them via Data Explorer – Alter and just opening seemed to fix, no need to explicitly save. However, I still have the entries for the old database also listed. Can I safely delete these?

    Regards
    Graham

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi Graham,

    When you use the Data Designer to delete a table, you are just deleting a table design (the physical table is not deleted). When you use the Data Explorer to delete a table, the physical table is deleted from your database. If you are unsure, you can always export a table before deleting it.

    It’s hard to give a timescale for the update. There is a big premium update coming up which I want to finish first. Hope to give Data Forms a boost by the end of the year, but it’s not a promise… πŸ˜‰

    Hope this helps,
    Peter

    Thread Starter gpanton

    (@gpanton)

    Hi Peter

    Yes, understand that but Data Designer is showing me two rows for each table design, one for the old schema and one for the new. Are these really two rows or two views of one row? I don’t want to delete one and see the other also disappear. What’s better, delete or ignore? I’m particularly cautious because there seemed to be no explicit updates.

    Regards
    Graham

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi Graham,

    Can you send me a screenshot to clarify? You can use the contactform of the plugin website if you prefer to send it in private.

    Thanks,
    Peter

    Thread Starter gpanton

    (@gpanton)

    Hi Peter

    Perhaps you realised but the last few posts were against the wrong thread so might not have made as much sense as they should. The correct post was “ERROR: Wrong arguments [schema name not found]”. I’ll go back to that so the history is more complete.

    Regards
    Graham

    Thread Starter gpanton

    (@gpanton)

    On this topic, following your advice I’ve used dynamic hyperlinks which proves to be the best current solution, giving me a 3 level hierarchy and is generally working well. Is it possible to customise the appearance of the actual hyperlink?

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi Graham,

    >>> Is it possible to customise the appearance of the actual hyperlink?

    It is! Dynamic hyperlinks can be added in two ways:
    (1) let the plugin add the hyperlink
    (2) have full control over your custom hyperlink

    If you enter a URL in the HTML field, the plugin will construct a hyperlink. To create custom hyperlink, enter your own HTML code in the HTML field. If the plugin finds a HTML tag at the first position of the HTML field, it will use your custom HTML. This allows you to add buttons, images or other visuals to your dynamic hyperlink.

    This feature is demonstrated here:
    https://wpdataaccess.com/docs/documentation/data-explorer/dynamic-hyperlinks/#examples-of-dynamic-hyperlinks
    See second example

    Hope this helps,
    Peter

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

The topic ‘Multi level hierarchy’ is closed to new replies.