Hi @sistemes,
Thanks for getting in touch!
The Data Publisher supports only one table per publication. Sorry! Relationships are only supported in Data Projects.
You have a number of options to solve this issue:
(1) Create two publication (master+detail) that work together like a relationship
(2) Make your Data Project read-only and use it as a pubication
(3) Since you have a premium license you can use Data Forms (!)
(1) Here is a demo including an explanation:
https://wpdataaccess.com/demos/demos-data-publisher/data-publisher-detail-page-demo/
(2) To make your project read-only, open your project, edit the project page which you want to make read-only and set mode to ‘View’. Add the project shortcode to your page to view your relationships on a public website.
(3) Data Forms is the premium way to use Data Projects. You first need to make the project page read-only as described in option (2). After that you can just use one of the Data Forms shortcodes: wpdadataproject and wpdadataforms. Here is demo of each shortcode:
https://wpdataaccess.com/docs/documentation/data-forms/project-demo/
https://wpdataaccess.com/docs/documentation/data-forms/page-demo/
The demos are read-only as well. You can select your own style:
https://wpdataaccess.com/docs/documentation/data-forms/overview/#styling
Does this helps?
Best regards,
Peter
Hi Peter, thank you for your time and for your quick response. Your options are great. I have duplicated the project only in read mode. But, I would like to be able to choose the columns that are shown in public and also customize the search box.
In “Data publishes” in “Column Names (* = all)”, you can select the columns and it also has “Advanced settings” where you can host custom code, for example
{
“wpda_searchbox”: “header”,
“wpda_search_placeholder_prefix”: “icon”
}
“Data Projects” does not have those options.
Is there a way to customize the view with some shortcode? Is there a way to select only the columns that I want?
Hi @sistemes,
Sorry for my late response! I was on holiday.
You can customize project as well but this works with templates. Here is a tutorial:
https://wpdataaccess.com/docs/documentation/data-projects/overview/
Please let me know if this helps,
Peter
