I have a question about Custom Fields that would be great to get help with please.
I have a custom field Radio button that offers 1 choice of a number of different values.
I set the values up a few years ago and I now need to change/rename one of them
I have one called 'Intern' that I now need to call 'Associate'.
My question is. If I simply change the value in the Radio button option through custom fields, will that make everyone that has Intern assigned to them from before, get changed to Associate or is it just for those people from after I make the change?
I am trying to work out if I will get a mix of people, some who are Intern and others who are Associate. I'm not sure if the radio button stores as a number per value or the actual text.
It's not a problem if I have to go and update all Intern's to Associate but just wanted to check my logic please
I have added a screenshot to show the value I want to change to Associate
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
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