The Community forums are being phased out in favor of a new Slack group.
Add your email address below to get an invitation to join the community slack group

Slack Signup
Newsletter Optin
Help Desk

Entries from an external database/file

Labels

This Discussion is public

Notifications

Hello everyone,
I need help about the creation of a form page which i need to show data in a dropdown menu, for example, but i want that this menu entries come from an external database such an xml or cvs file with their images.The cvs file contains a image url.
Thanks in advice, greetings.

You can do this by writing your own function and hooking it to the frm_setup_new_fields_vars hook. You can connect to an external database in several different ways depending on the server that houses the database. If you use XML or CVS files (not a direct database connection), you would use PHP's file handlers. All of this requires advanced programming skills, but can be accomplished in a few hours.

If you are not a developer, it would be easier to create a lookup table and import the content using Formidable's built-in tools. Is there any reason why you want to use files to store the content?

Hi Victor

I want to build an application with formidable forms and mysql.
At this moment the entries are also being stored in second database mysql.

With in formidable it is not possible to create a primairy key, so I was told by the helpdesk of formidable forms. Within mysql is it possible to create a primary key and foreign keys.

I want to use the following steps:

Use a formidable form (adding an entry) for data input. The data is stored in wordpress and also in mysql.
I use wpdatatables to show the data from the mysql datatable. I also have de wpdata-formidable add on, but I want to work with primaiy and foreign Keys. Of course I can make a custom table showing the data, but wpDataTables saves time for progtamming.
When I select the url link in the row in wpdatatables I want to show a view. This is possible. I made this work (witk a little workarond), only the link I have to update the id manualy. After updating the link I links to the specifiek enry in a view. I need to look in to that.
If I want to update the data I want to use a copy of the form in step 1. In this copy the data is show from the mysql database.

The formidable form in step 1 stores data in wordpress and in the mysql database is only used for ading an entry. The mysql data is used for read, update or delete. I do not want to create the form in a custum way with html and php, but within formidable forms.

The question is: is this possible?

I do have the same problem I did everything u did and am still trying to update from wpdatatables .

Please let me know if you have a any ideas

take a look at

https://blog.jamesbayley.com/2017/04/01/understanding-formidable-forms-and-wordpress/

 

http://community.formidableforms.com/help-desk/wpdatatables-integration-with-formidablepro/

 

 

Discussion closed.