Select Options from Database — how?

  • Resolved pwforaker

    (@pwforaker)


    7 years, 8 months ago

    In WordPress with Form Maker, I want to populate a Select Box (Custom Select) with 69 options from a table in a database. This did not work:
    0. Create a new MySQL database with a ‘sponsor’ table with columns Name and Value
    1. Create new field of type Select Box with the default Custom Select.
    2. Click Select options from database.
    3. Click Remote and enter the database credentials.
    4. Click Connect
    5. Select a table > sponsor
    6. Select a name > Name
    7. Click the + and select Name = *
    8. In Select an option, select Name and accept the default asc.
    9. Click Save
    Expected result: The options list would be populated with all 69 names and values.
    Actual result: Dialog closes and the first blank option is populated with [sponsor:Name] in both the Name and Value fields. The 69 sponsor names are not listed. No error message.

    Suggestions welcome!

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Contributor Form Maker Support

    (@formmakersupport)

    Hello, @pwforaker!

    Thank you for precisely describing the problem!

    Did you rename the database after configuring the options with Form Maker? Also, it might have become inaccessible for some reason.

    If that’s not the case, please contact our team through the following form:

    https://web-dorado.com/support/contact-us.html
    (Select “I have a pre-sales question” and the form will appear)

    Also please indicate the link to this forum thread in your message. We will share the solution here as well.

    Cheers!

    Thread Starter pwforaker

    (@pwforaker)

    The database was not renamed; and it was apparently a valid connection, because the editor retrieved the table name and columns. So, I have submitted a support request form.

    Plugin Contributor Form Maker Support

    (@formmakersupport)

    Hi, @pwforaker!

    Thank you, we received your support ticket and responded to it. We’ll share the solution here as soon as we figure it out.

    Cheers!

    Plugin Contributor Form Maker Support

    (@formmakersupport)

    Hi, @pwforaker!

    Our development team has successfully connected to your database, and added the options. If you check your published form, you will see the options appearing properly.

    Did you expect to see them on the form editor? Note, that they only appear on front-end.

    Also, we noticed that the entries were duplicated, but they were duplicated on the database itself also.

    Please have a look at the select field on your form, and let us know if you notice anything odd.

    Thanks! Have a great day!

    Thread Starter pwforaker

    (@pwforaker)

    Wow, never occurred to me that the data wouldn’t appear in the back end. Thank you for persevering on this.

    The duplication of data was apparently my mistake. All better now.

    Thanks!

    Plugin Contributor Form Maker Support

    (@formmakersupport)

    That’s wonderful, @pwforaker! We’re pleased to know, that all issues are sorted out on your website.

    We hope you can spread the word and tell your friends about Form Maker. If you have time, please share your thoughts about the plugin here.

    Thank you so much! Have a great day!

    Thread Starter pwforaker

    (@pwforaker)

    In the documentation for this option, the last sentence on the page is “On the back end, the option will display the table field name, whereas for the front end it will display the values which have fulfilled the provided conditions.” Perhaps that could be rendered in BOLD for emphasis. I totally missed it.

    Plugin Contributor Form Maker Support

    (@formmakersupport)

    Hello, @pwforaker!

    Thank you for your notes. The documentation for Form Maker will be improved soon, and we will take your comments into consideration.

    Thanks again for the suggestion!

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Select Options from Database — how?’ is closed to new replies.