I'm creating a kindergarten website. I have created a children database in WP-Tables SQL tables, which is also a user database. It it, the admin can add or delete new users. But I have also created another query of the same table for parents, in their own entry page, which uses the same table, but restricted by using the placeholder %CURRENT_USER_LOGIN%. So, parents can only see their own child. But I need to use one of the fields, "room", to open an iframe of thet room's page, for the parent to be able to consult their children's room, with current menus, activities, photos and videos. However, I was not able to use that value. I can't atribute am ID to the cell and all trying using Javascript failed. Do you see any way to solve this?
I can't see the table on the related URL since it's restricted per user so I don't know if I understood your inquiry correctly.
Please correct me if I'm wrong: You want to add a "room" ID which (on click) opens an iframe to that room's page? If that's true, you'll need to use a CONCAT function which will append the ID of the room to a URL.
You can take a look at this video about that:
Let me know if I misunderstood, or if I can offer additional assistance.
I'm creating a kindergarten website. I have created a children database in WP-Tables SQL tables, which is also a user database. It it, the admin can add or delete new users. But I have also created another query of the same table for parents, in their own entry page, which uses the same table, but restricted by using the placeholder %CURRENT_USER_LOGIN%. So, parents can only see their own child. But I need to use one of the fields, "room", to open an iframe of thet room's page, for the parent to be able to consult their children's room, with current menus, activities, photos and videos.
However, I was not able to use that value. I can't atribute am ID to the cell and all trying using Javascript failed. Do you see any way to solve this?
Hello Carlos
Thank you for your purchase.
I can't see the table on the related URL since it's restricted per user so I don't know if I understood your inquiry correctly.
Please correct me if I'm wrong: You want to add a "room" ID which (on click) opens an iframe to that room's page? If that's true, you'll need to use a CONCAT function which will append the ID of the room to a URL.
You can take a look at this video about that:
Kind Regards,
Aleksandar Vuković
aleksandar.vukovic@tmsproducts.io
Rate my support
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