Hey there, Awesome Customers!

Just a heads up: We'll be taking a breather to celebrate International Workers' Day (May 1st and 2nd - Wednesday and Thursday) and Orthodox Easter from Good Friday (May 3rd) through Easter Monday (May 6th). So, from May 1st to May 6th, our team will be off enjoying some well-deserved downtime.

During this time, our customer support will be running on a smaller crew, but don't worry! We'll still be around to help with any urgent matters, though it might take us a bit longer than usual to get back to you.

We'll be back in action at full throttle on May 7th (Tuesday), ready to tackle your questions and requests with gusto!

In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find loads of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel). These gems might just have the answers you're looking for while we're kicking back.

Thanks a bunch for your understanding and support!

Catch you on the flip side!

Warm regards,

TMS

Okay
  Public Ticket #2885702
Populating Form Fields from DB
Closed

Comments

  • Anthony Silver started the conversation
    October 2, 2021 at 12:26pm

    We are currently using WordPress + Elementor Pro

     

    We need to build some pages which include forms

     

    Some of these forms will be ‘update’ forms, which connect to a mysql database and populate form fields with data from a table (using a querystring to identify the record to be updated.

     

    Some of these forms will be ‘insert’ forms which inserts the data from a form into a new table.

     

    Form field types will include text and drop down (where the drop down contents is defined by a separate query).

     

    I am used to VBScript using Dreamweaver (CD4).  However the site is WordPress which means that I have a steep learning curve.

     

    Can WPDataTables do all of the above.

     

    Anthony  

  • [deleted] replied
    October 5, 2021 at 11:25am

    Hi Anthony

    Thank you for your interest in our plugin.

    Forms Integrations for wpDataTables can display entries of a form in a wpDataTable, and if you make that table editable, you'd be able to modify and delete existing entries, or to add new ones. Data from the linked tables resides on the linked source (Google Spreadsheet, Forms' database tables, Excel file, CSV file, etc), so the plugin doesn't store any data in the database. There is no was for wpDataTables to populate a form.