You would be able to link a Forminator Form to output a table, it would be synchronized with the changes on the source Form, but it can't be editable on the WP side.
-
2.
Generally speaking, we have two ways to use Excel in our plugin:
1. Create a table linked to an existing Excel file, in which case you get to select the file (upload it) that'll be used to pull the data. This file will be stored in ../wp-content/uploads/YEAR/MONTH/ folder. The file on that location can be changed, but the structure can't. So, if you have the file with the same title, the same number of columns, same headers, and the same order of columns - you'd be able to replace the original file with the new file, and wpDataTables would pick that up.
-
When working with Excel linked tables, please note:
Formulas and merged cells are not supported,
They generally work slower than CSV-files, or even Google Spreadsheets; so if your table is large, it is much better to port it to a different format, or – even better – to MySQL table (you can use “Create a table by importing data from data source” to import your Excel file to MySQL).
Formatting applied in the original file (font families, color, size, fill color, etc.) will not be copied over to the wpDataTable, but you can make whatever adjustment you may need in WpDataTables.
Tables linked to an existing Excel file are not editable, nor are they saved in the database.
Generated tables cannot be replaced with another Excel file. Each new file has to be a new wpDataTable.
-
2. Create a table by importing the Excel file. In this case, the source file is read, and a manual table is created. So, the generated table reads the source only once, and after that, there are no relations between it and the wpDataTable. You would be able to edit the table, but the changes wouldn't be seen in the source file. In this case, you'd be able to save new rows in a separate Excel file (without column headers) and export it as CSV. Then, access the table and in the Editing tab above the table see what the "MySQL table name for editing" is. Access your database and access that table. In the "Import" tab select the new CSV file and import it. That will update the table. Another option would be to switch to Excel-like view, select a range of new cells from your Excel file and paste them below the last row in wpDataTables.
-
Let me know how that seems,
but regarding VBA Excel, i feel that i am not fully understanding everything you need,if you can please elaborate a bit more on that, and i will advise?
-
And, just wanted to point out that we have a Demo Sandbox site, where you can try out the plugin functionalities, on this link
and there is a 15-day money-back guarantee period, So if you purchase the plugin, you can safely fully test it out, and if it doesn't fit your needs you can request and receive a refund in that period. ( same goes for all plugins and add-ons)
Hi,
I use WPMUDEV Forminator
I wish to access the data in forms
Using VBA Excel, etc.
Do you provide a solution for that?
Hi, Bela
Sorry for the delayed response.
I am sorry, but it seems i did not understand exactly what is your goal. But i will do my best to give you some information for a start.
1.
We have integration with Forminator Forms. You can check this out here.
-
You would be able to link a Forminator Form to output a table, it would be synchronized with the changes on the source Form, but it can't be editable on the WP side.
-
2.
Generally speaking, we have two ways to use Excel in our plugin:
1. Create a table linked to an existing Excel file, in which case you get to select the file (upload it) that'll be used to pull the data. This file will be stored in ../wp-content/uploads/YEAR/MONTH/ folder. The file on that location can be changed, but the structure can't. So, if you have the file with the same title, the same number of columns, same headers, and the same order of columns - you'd be able to replace the original file with the new file, and wpDataTables would pick that up.
-
When working with Excel linked tables, please note:
-
2. Create a table by importing the Excel file. In this case, the source file is read, and a manual table is created. So, the generated table reads the source only once, and after that, there are no relations between it and the wpDataTable. You would be able to edit the table, but the changes wouldn't be seen in the source file. In this case, you'd be able to save new rows in a separate Excel file (without column headers) and export it as CSV. Then, access the table and in the Editing tab above the table see what the "MySQL table name for editing" is. Access your database and access that table. In the "Import" tab select the new CSV file and import it. That will update the table. Another option would be to switch to Excel-like view, select a range of new cells from your Excel file and paste them below the last row in wpDataTables.
-
Let me know how that seems,
but regarding VBA Excel, i feel that i am not fully understanding everything you need,if you can please elaborate a bit more on that, and i will advise?
-
And, just wanted to point out that we have a Demo Sandbox site, where you can try out the plugin functionalities, on this link
and there is a 15-day money-back guarantee period, So if you purchase the plugin, you can safely fully test it out, and if it doesn't fit your needs you can request and receive a refund in that period. ( same goes for all plugins and add-ons)
Kind Regards,
Miloš Jovanović
[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