I took a closer look and found the data is NOT json. So looks like I have to use mySQL string functions. Appreciate it if you have written query for that. If you use Forminator API, then I guess then i cannot use from my SQL query.
I'm afraid we don't provide support for writing custom queries but please provide us some more information what you are struggling with in particular and we will be happy to assist if we can.
Thanks Blazenka. I don't believe you currently have a solution to join two Forminator forms. It will be great if you can raise a request to your DEV team. In the meantime, please close this ticket.
I'm afraid that is true, I will forward your request do our dev team but I'll kindly ask you to add it as a feature suggestion on this page as well.
Features are pushed up on our "to-do" list when there are a lot of customers requesting those features, so having your vote as a customer can be beneficial to this feature being developed sooner.
Do let us know if there is anything else we can assist you with.
I don't see the "CONFIGURE RELATION..." button that iss shown at https://wpdatatables.com/documentation/front-end-editing/configuring-table-relations-foreign-key/.
Again, my wpDataTables are based on Forminator forms, not direct MySql database tables.
Hi Eric
Thank you for reaching out to us.
Can you please confirm you have the plugin updated to its latest version?
What column type would you like to use to foreign key with? Can you share a screenshot of what you see?
I took a closer look and found the data is NOT json. So looks like I have to use mySQL string functions. Appreciate it if you have written query for that. If you use Forminator API, then I guess then i cannot use from my SQL query.
Hi Eric
To configure a foreign key the column type should be changed to string, as mentioned in our documentation
https://wpdatatables.com/documentation/front-end-editing/configuring-table-relations-foreign-key/
I'm afraid we don't provide support for writing custom queries but please provide us some more information what you are struggling with in particular and we will be happy to assist if we can.
Thanks Blazenka. I don't believe you currently have a solution to join two Forminator forms. It will be great if you can raise a request to your DEV team. In the meantime, please close this ticket.
Hi Eric
I'm afraid that is true, I will forward your request do our dev team but I'll kindly ask you to add it as a feature suggestion on this page as well.
Features are pushed up on our "to-do" list when there are a lot of customers requesting those features, so having your vote as a customer can be beneficial to this feature being developed sooner.
Do let us know if there is anything else we can assist you with.
Done. Feature request submitted.
Thank you
If there is anything else we can assist you with please don't hesitate to open a new ticket.
Have a wonderful day!