Question about Custom Fields Radio Button

Hi Chris

Unfortunately, if you change the value, the data for existing registrants won't be changed, so if you edit the registration record again, the option they selected before won't be selected and you will loose the data if you save it

So better, please don't change the value

Regards,

Tuan

Thanks for the better understanding Tuan and it is no problem

My boss has instructed me that I need to change this value though very soon.

I've identified the people who are currently Intern through PHP MyAdmin with the following sql

SELECT * FROM `????_osmembership_field_value` WHERE `field_id` = 14 and `field_value` = 'intern'

Am I right in thinking I can update those values to 'Associate' with an update query and then if I change the value in the radio button options list by over typing Intern with Associate, new people or renewals and updates will then select 'Associate' and either overwrite their old value or get the new one added?

Will those updated to Associate show in the Radio button if the spelling matches the Custom Fields config?

I realise I will need to do both the update query and then the text change at the same time or else people could still get added at Intern if I don't change it.

Do you think this will work? I can try it on a backup restore though first so I am really happy you have explained how it works Tuan thanks

Chris

Yes. It should work. But you should make a backup of your site (or at least the database table first) so that in case something does not work as expected, you can rollback

Tuan

Thanks Tuan

You're a legend! I'll give it a go!

Chris