I'm not sure I understand your question, though. Can you explain in a bit more detail?
You're mentioning forms - the only two forms plugins we have integration with are Gravity Forms integration and Formidable Forms integration, and you can choose what you wish to display in the table from an existing form.
If you want to display only a single record using SQL queries that is also possible.
Please tell me in more detail what your idea is, and I'll provide a better answer then.
What I am trying to accomplish is to set up a membership directory. The table display is great for the query. What I'd like to do is to be able to click on a single record and have it display in a nice format for that one record. But instead of a table format, I'd like to show a nicely formatted form with placeholders for the individual fields, images etc. coming from the database. A similar form perhaps could be used for users to submit a new record? And ideally, users could scroll through their query, one record at a time, but displayed in this form.
What I'd like to do is to be able to click on a single record and have it display in a nice format for that one record. But instead of a table format, I'd like to show a nicely formatted form with placeholders for the individual fields, images etc. coming from the database.
You wouldn't be able to display this using the plugin's built-in features, but I guess you can create a new page or post for each record, and configure it any way you like; then in the table, just create a link to that new page or post. To be able to click on a record, though, I don't believe using Gravity forms would be feasible. While the values can be changed, there's no way to create a link to that new page without it affecting the original data. The only way to do this is to create a CONCAT function with SQL that'd add an url to the record id. Something like this:
CONCAT('https://url_to_the_record_id=',`database_table`.`record_id_column`,'||',`database_table`.`record_id_column`) AS `RecordID`,
Again - doing this with forms would be rather cumbersome, if not impossible, since forms store data in same tables, and pulling info from them is very difficult.
Basically, most of your ideas should have to be implemented by customizing the plugin, and unfortunately that doesn't fall under included support of the plugin.
Certainly agree. Even the most primitive databases (like MS Access) has the ability to display a single record on a form. With HTML, CSS, Wordpress and this plugin... one would think this would be a relatively easy add on. Thanks for the replies.
Thank you both for the suggestion. It has already been added to our "TO-DO" list, so our developers have it in mind. I cannot say when or if it will be implemented, since they are very busy with some priority tasks and work on our plugins.
We carefully follow customers requirements and try to implement most of them if they appear in requests from time to time.
Good day,
Wondering if the plugin can handle calls to display a single record in a form?
Does it handle this nativly? or can you recommend a compatible plugin.
Hello Matt.
Thank you for your interest in our plugin.
I'm not sure I understand your question, though. Can you explain in a bit more detail?
You're mentioning forms - the only two forms plugins we have integration with are Gravity Forms integration and Formidable Forms integration, and you can choose what you wish to display in the table from an existing form.
If you want to display only a single record using SQL queries that is also possible.
Please tell me in more detail what your idea is, and I'll provide a better answer then.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
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
Thanks Aleksandar,
What I am trying to accomplish is to set up a membership directory. The table display is great for the query. What I'd like to do is to be able to click on a single record and have it display in a nice format for that one record. But instead of a table format, I'd like to show a nicely formatted form with placeholders for the individual fields, images etc. coming from the database. A similar form perhaps could be used for users to submit a new record? And ideally, users could scroll through their query, one record at a time, but displayed in this form.
Hey Matt.
What I'd like to do is to be able to click on a single record and have it display in a nice format for that one record. But instead of a table format, I'd like to show a nicely formatted form with placeholders for the individual fields, images etc. coming from the database.
You wouldn't be able to display this using the plugin's built-in features, but I guess you can create a new page or post for each record, and configure it any way you like; then in the table, just create a link to that new page or post. To be able to click on a record, though, I don't believe using Gravity forms would be feasible. While the values can be changed, there's no way to create a link to that new page without it affecting the original data. The only way to do this is to create a CONCAT function with SQL that'd add an url to the record id. Something like this:
Again - doing this with forms would be rather cumbersome, if not impossible, since forms store data in same tables, and pulling info from them is very difficult.
Basically, most of your ideas should have to be implemented by customizing the plugin, and unfortunately that doesn't fall under included support of the plugin.
Best re
Kind Regards,
Aleksandar Vuković
[email protected]
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
This feature is much needed.
Certainly agree. Even the most primitive databases (like MS Access) has the ability to display a single record on a form. With HTML, CSS, Wordpress and this plugin... one would think this would be a relatively easy add on. Thanks for the replies.
Hello Furqan and Matt.
Thank you both for the suggestion. It has already been added to our "TO-DO" list, so our developers have it in mind. I cannot say when or if it will be implemented, since they are very busy with some priority tasks and work on our plugins.
We carefully follow customers requirements and try to implement most of them if they appear in requests from time to time.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
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