Plugin Contributor
Kim L
(@kimmyx)
Hi @plj63,
Thanks for the post. Could you tell us where this “link” would be located?
Based on your description, using URL parameters might be better for you.
Please check it out here: URL parameters | WP Data Access
Example of using it in a search form: Search form demo | WP Data Access
Let us know if that helps!
Thread Starter
plj63
(@plj63)
Hi Kim
Thanks for your reply.
I would have a link on the page that lists the summary of people, for example using a more… link. So If I have a table of people details and a page showing a summary list as follows
| Date | First Name | Last Name | |
| 12-Jan-2024 | John | Doe | more… |
| 13-Jan-2024 | Mary | Smith | more… |
The more… link would show more details for a given person. This could open another page or a pop-up
Plugin Contributor
Kim L
(@kimmyx)
Hi @plj63,
Thanks for the response.
If it can be a popup, perhaps making your data table “responsive” would be more suitable. 😊
We have a guide here: Responsive data tables | WP Data Access
But if you wish to still use a dynamic link, it can be set up like below in the HTML field:
<a href="More">https://yourpage.com/?id=$$id$$</a>
See here: https://share.zight.com/8LulyRRo
https://yourpage.com/ would have a shortcode of a data table so that the URL parameters are read.
$$id$$ would be the variable for column id for example. You can add more parameters and variables for your columns.
Hope that helps!
Thread Starter
plj63
(@plj63)
Hi Kim
It appears that using httpGet[‘param_name’] is a premium feature only.
Is there another option available on the free version?
Thanks
Hi @plj63,
Please have a look at the master-detail solution as explained here:
https://wpdataaccess.com/docs/data-tables-advanced-features/master-detail-tables/
Is this is what you are looking for?
Thanks,
Peter
Thread Starter
plj63
(@plj63)
Hello Peter
Thats exactly what I need thanks. My master data tables is called results and the detailed data table is called match. So there would be a link in teh results table to show the details of a match. I set the match table as explained in the doc.
However when I give an argument to the URL I get the detailed table for the very first entry match regardless of the what I give in the URL. So Im missing something
Do I need to add anything in the WHERE Clause? Note that for the moment Im using the free version
Thanks for your reply
Hi @plj63,
Do you have a public URL where we can your table in action? That often helps…
Thanks,
Peter
Thread Starter
plj63
(@plj63)
Hi Peter
Thanks for the reply. Here is a URL.
the page ‘team’ has the shortcut [wpdataaccess pub_id=”2″] of the data table ‘Match’
https://testwp.nyonrugby.com/team/?scorevisitor=$$37$$
The master data table is ‘Results’ and the shortcut is in https://testwp.nyonrugby.com/results-summary/
The above test should show the match of 10-dec-1972 but it shows the first entry
Ideally I wold need a lookup URL that has the aruments for the date,host and visitor columns.
Hi @plj63,
You’re missing the URL parameter. Please replace this:
?scorevisitor=$$37$$
With this:
?wpda_search_column_scorevisitor=37
The plugin only uses parameters starting with: wpda_search_column_
This is documented here:
https://wpdataaccess.com/docs/data-tables-interactive-filters/url-parameters/
See: 2. Let the plugin add them automatically to a query
Also make sure to remove the $$. This link works:
https://testwp.nyonrugby.com/team/?wpda_search_column_scorevisitor=37
Does this solve the issue?
Thanks,
Peter
Thread Starter
plj63
(@plj63)
Hi
Brilliant. That works very well
Many thanks
