ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Update entries when changing custom field

October 13, 2014 4:59pm

Subscribe [2]
  • #1 / Oct 13, 2014 4:59pm

    mchr

    1 posts

    I have a custom field, type Checkbox, with three values. Eg. “Red”, “Green”, “Blue”.

    I’d like to completely remove the third value, “Blue”, but when doing so in the custom field setup, my entries are not automatically updated. So “Blue” will still render on the site.

    Is there a simple way to fix this without having to go through every single entry?

    Thanks!

  • #2 / Oct 16, 2014 1:56pm

    GDmac - expocom

    350 posts

    Not easily via the control panel, if you’re comfortable with mysql,
    (first make a backup of the database)
    Then you can lookup the field_id and issue an
    UPDATE exp_channel_data SET field_id_xx = ‘’ WHERE field_id_xx =‘blue’

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases