Dynamic link and table view creation

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!

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

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!

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

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

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

Hi

Brilliant. That works very well

Many thanks