Table Connection

  • jayab

    (@jayab)


    5 years, 9 months ago

    Hi Peter

    Thanks for your valuable time for attending questions and answers.
    Kindly see below requirement and advice me whether is workable or not within the plugin.

    as an example; I have a Three table

    1. Product Item – (with 4 column – Product Name/Photo /Purchase customer – Link to below table / Product Information -Link to below table )
    2. Purchase customer (with 4 column – Name/Date of buy / Address / Contact number)
    3. Product Information (with 3 column – Product Catalog/ Photos / word attachment)

    Product item table to be display on web page as a responsive/Modal type – This is no issue

    this is to be done

    1) if i click Purchase customer link on Product item table, relevant Purchase customer information from Purchase customer table (only respective raw details) to be display on additional web page (New Tab) or parent page.

    2) if i click Product Information -Link on Product item table relevant Product Information from Product Information table (only respective raw details) to be display on additional web page (New Tab) or parent page.

    Kindly check this and advice me whether can be done or not within the plugin.

    Thank for your cooperation.

    JayaB

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

    (@peterschulznl)

    5 years, 9 months ago

    Hi @jayab,

    Is all the data read-only? Or do you need to be able to update data?

    Thanks,
    Peter

    Thread Starter jayab

    (@jayab)

    5 years, 9 months ago

    Hi Peter

    Thanks for your response. Highly appreciated.

    Yes. all the data read only and no need to update data regularly.

    Thank You.

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    5 years, 9 months ago

    Hi @jayab,

    You can do this with Data Projects, but you cannot create a parent-child construction over three levels. The plugin support only two levels. To add a third level, you need to add hyperlinks for the navigation between pages on different levels. To make it read-only, you can disable insert, update and delete for your project.

    You might be able to do this with the Data Publisher as well. But you need to add the parent-child structure yourself. Here is some documentation on this topic:
    https://www.bonapp.menu/themes/admin/plugins/datatables/examples/api/row_details.html

    I haven’t tried this myself before. If you succeed in implementing this, I would be grateful if you could send me your code! 🙂

    Does this help?

    Best regards,
    Peter

    Thread Starter jayab

    (@jayab)

    5 years, 9 months ago

    Hi Peter

    Thanks for your response.

    if i use hyperlink to normal web page-New Tab mode (without child page) is there any possibility to do this easily?

    Click hyperlink of main table raw >> go to new web page (New Tab) >> display specific raw details of second table on that web page

    Best Regards
    Jayab

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    5 years, 9 months ago

    Hi Jayab,

    Not sure if I understand your question correctly, but you can add dynamic hyperlinks to your table rows. Dynamic hyperlinks allow you to add column values to your hyperlinks, which you need to add the row keys to your page requests.

    You can find the documentation for dynamic hyperlinks here:
    https://wpdataaccess.com/docs/documentation/data-explorer/table-settings/
    (see dynamic hyperlinks)

    Best regards,
    Peter

    Thread Starter jayab

    (@jayab)

    5 years, 9 months ago

    Hi Peter

    yes. its bit complicated to understand.

    Can i send email with screen shots and more details for your easy understanding?

    Thank you ones again your valuable time.

    Jayab

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    5 years, 9 months ago

    Yes you can Jayab! 🙂

    Please use the contactform on the plugin website to send me a mail. I’ll reply to your mail from my private email address. After that you can send me your screenshots.

    All the best,
    Peter

    Thread Starter jayab

    (@jayab)

    5 years, 9 months ago

    Hi Peter,

    I sent message through contact forum.

    Thanks for your support.

    Jayab

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

The topic ‘Table Connection’ is closed to new replies.