PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.

Change field type?

  1. kevinmcgillivray

    Hi, there. My client set up a form and used a single line text field for what should have been an email field. He's gathered a few days worth of data and now wants to set up notification. He can't though, since the field isn't actually an email field. I also don't want to delete the field and set up a new one because we'll lose the data already gathered.

    Is there a way to switch the field type to make it into an email field? I'm comfortable going to the database if that's the only way to solve the issue.


    Posted 10 years ago on Friday November 12, 2010 | Permalink
  2. I would backup your database before trying this just in case.
    Then, you will need to do the following:
    1- Export your existing form
    2- Open the XML and change the field type to "email"
    3- Import the form (it will create a new form)
    4- Go into the database and update the ID of the new form to match the ID of the old form. (tables wp_rg_form and wp_rg_form_meta)
    Before you can do that, you will need to update the ID of the existing form to some other value or delete the existing form.

    Posted 10 years ago on Saturday November 13, 2010 | Permalink