As I see you want to click on the some client name or whole row and then to open a new table based on the clicked row? Can you explain me your request in more details or to provide me some example? Thanks.
This is for a not-for-profit (St. Vincent DePaul). We visit clients and record events. There are 365 Clients and 1,502 Events recorded. The wpDataTable for Clients works great ( see attachment to my first post). When someone selects a Client, he can easily find a Client and edit the information, or add a new one. I want the option to jump to a wpDataTable for the events (see attached example).
I am a newbie to web development. I do not know how to store the Client.ID, call the Events table, and pass the Client.ID to the Events table in order to select events only for that client.
I you look at the Event sample attached, I would also like to have the note field in a second line.
If you can point me in the right direction, I would really appreciate it.
Unfortunately something like that is not possible out of the box but it can be achieved by custom coding.
You have to grab Client ID when you click on his row. To achieve something like that you'll have to have Client ID column in Client table. You can easily hide that column after if you don't want to users see Client ID values. With some jQuery snippet you'll have to get the ID and pass it with $_POST or $_GET to redirected page.
Redirected page should have Custom Page Template where you will add wpDataTable shortcode with do_shortcode() WordPress function. When you get the value that you passed from the front-end then you can use Placeholders. That events table should be MySQL based table where you'll use value that you passed as variable.
I have a client form - see attachment.
When one selects a Client, I would like to capture the ID of the table, open another form which selects detail records for that ID.
Hi Jim Wyrsch,
Thank you for the purchase.
As I see you want to click on the some client name or whole row and then to open a new table based on the clicked row? Can you explain me your request in more details or to provide me some example? Thanks.
This is for a not-for-profit (St. Vincent DePaul). We visit clients and record events. There are 365 Clients and 1,502 Events recorded. The wpDataTable for Clients works great ( see attachment to my first post). When someone selects a Client, he can easily find a Client and edit the information, or add a new one. I want the option to jump to a wpDataTable for the events (see attached example).
I am a newbie to web development. I do not know how to store the Client.ID, call the Events table, and pass the Client.ID to the Events table in order to select events only for that client.
I you look at the Event sample attached, I would also like to have the note field in a second line.
If you can point me in the right direction, I would really appreciate it.
Hi Jim Wyrsch,
Unfortunately something like that is not possible out of the box but it can be achieved by custom coding.
You have to grab Client ID when you click on his row. To achieve something like that you'll have to have Client ID column in Client table. You can easily hide that column after if you don't want to users see Client ID values. With some jQuery snippet you'll have to get the ID and pass it with $_POST or $_GET to redirected page.
Redirected page should have Custom Page Template where you will add wpDataTable shortcode with do_shortcode() WordPress function. When you get the value that you passed from the front-end then you can use Placeholders. That events table should be MySQL based table where you'll use value that you passed as variable.
I was curious about this functionality too. With the ability to use Variables for filtering tables. Is there a way to pass url variables from a link.
To expand.
Continuing Jim's example.
I have a Client Record.
recordwid Name address city zip url to events table
recordid Pete 111 mockingbird lane 95382 http://mywebsite.com?tableid=123&recordid=3
When the url to events is clicked it would load the events just for that recordid.
It would be great if as the table is rendering if there was a way to load the recordid into the created url for this purpose.
Has anyone else accomplished a similair solution?
Pete
HI Pete,
Can you please open a new ticket and we can continue on that one.
Thank you.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables