Hi Jon,
It depends on what you want to achieve. Is this Data Projects related? Or Data Publisher? Do you want all your links to use the same URL? Or should every row have its own unique URL?
The plugin supports hyperlink columns. These columns types are described here:
https://wpdataaccess.com/docs/documentation/data-explorer/add-hyperlink-to-table-column/
The advantage of this hyperlink column is that it allows you to add a unique URL to every row. The disadvantage is that you need to set every column individually. Unless you perform an update over all rows at once!
At this time you cannot add a hyperlink column that uses the same URL for all rows. This question however has been asked several times lately, and I’m thinking about an elegant way to add such a column… 😉
However, you can add such a column to a view. The following topic described a discussion with another plugin use who was able to add a hyperlink to a view and use it in the Data Publisher:
https://wordpress.org/support/topic/calculated-field-column-in-db-list/
Be aware: This works in the Data Publisher! The Data Project will not (yet) perform actions on view data.
Does this help?
Best regards,
Peter
Hi Peter,
So every row is a unique URL. But that URL would have to be automatic (I think) so when you click it, it can take you to a page with more detailed information based on the particular row that was clicked. Does that make any sense?
Thanks 🙂
Jon
Hi Jon,
That is the functionality the other plugin user I mentioned has implemented with a view. This will only work in the Data Publisher!
I’ll try to add this feature to the next release. It will then be much easier to use. I’ll let you know when it is available…
Best regards,
Peter
That would be great. Thanks for your support again Peter
Best
Jon
Hi Jon,
Just wanted to let you know that version 3.0.3 supports dynamic hyperlinks. I think this is what you are looking for. You’ll just need to update the plugin to make it available.
You can find more info about the new feature here:
https://wpdataaccess.com/2020/03/22/dynamic-hyperlinks/
Best regards,
Peter
