Type in your suggestion - new feature or improvement idea

Change Field Type For Existing Database Fields

I should like some flexibility to be able to change field types for existing database fields.

For example I have fields which are current defined as text. However members give different responses to the question in terms of capitalisation, abbreviations etc which make the behaviour of the search on data in that field erractic.

I'd like to be able to change such a text field to a picklist.

The database would still store a text value but the choice available to new members would be restricted by the list. Existing membership records would continue to hold the existing data until the member chose to edit their record or renew their membership (if not previously edited) at which point the user would be required to replace the old non-compliant data value with a new one from the pick list.

8 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)

    We’ll send you updates on this idea

    TimTim shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    6 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • carol@oesmanagement.comcarol@oesmanagement.com commented  ·   ·  Flag as inappropriate

        We would like to suggest the following be added:

        - Ability to change a field type (currently you have to delete and re-create, loosing all data) and member access level

        - Allow for variable date format choices (currently only allows for one format)

        - Add money option format, that shows dollar signs

        Thanks,

        Carol Lathrop

        OES Management

      • anonymous_99.232.247.246anonymous_99.232.247.246 commented  ·   ·  Flag as inappropriate

        As you can see, there have been a lot of threads over time about this issue.

        I've merged these into this one thread, and updated our internal tracking and analysis on this to reflect the demand for this feature.

      • Kyle MitchellKyle Mitchell commented  ·   ·  Flag as inappropriate

        Another related feature that I'd like to see is the ability to dynamically switch a currently created field's type.

        Current Behaviour: I have an existing membership field textbox created called Province with specific Access and Use In options set for what membership form its included on, etc. I decide I want to change its type to a drop-down-list. To do this, I have to delete it and then add a new field called Province as drop-down-list and reset all the initial options again.

        Future Behaviour: I can simply change the fields type after it is created to whatever type I want preserving the Access and Use-In options.

      • Dmitry ButerinDmitry Buterin commented  ·   ·  Flag as inappropriate

        You are right, at the moment field type can not be changed. I will make a note for our list of enhancements.

        What you can do is create a new field, enter the values manually (which is a pain...), export the list, copy the whole column from old field to new and import back.

      • eslesl commented  ·   ·  Flag as inappropriate

        Currently when we customize member database field, let's say I add "Country" as one field, and I define the type as "text", which means that subcribers can enter their country name as a text, but if I want to change the type setting to other options, such as "multiple choice" or "dropdown" or "radio button", I can't change it. I can only delete the "country" and add a new field with a new type.

        Can we change the database field type without deleting it, since we will lose the old members' info on that field.

      Feedback and Knowledge Base

      Wild Apricot Inc. 144 Front Street West Suite 725, Toronto, Ontario, Canada M5J 2L7