2

does this post in the old forum from Lobo still hold true?

  1. change the value in civicrm_custom_field
  2. change the column type in the value table
  3. truncate civicrm_cache

1 Answer 1

4

Sometimes its possible to change the field type from UI, but it totally depends upon from what field type you want to convert to.

An easy win would

  1. Single select to radio or vice versa(change the value in civicrm_custom_field)
  2. Multi select to checkbox or vice versa(change the value in civicrm_custom_field)

If the change would involve data type like text to int or float etc it would involve

  1. Change the value in civicrm_custom_field
  2. Convert the data for the the field from old data type to new data type
  3. change the column type in the value table
1
  • That's brilliant - thanks @pradeep.
    – Marsh
    Jan 25 at 16:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.