Will changing text multiple choice options break formula's

Question

I currently have a "status" field in my tasks table with the options being Active, Future, Complete, Cancelled. My users requested I change Active to Assigned and add an in progress option.

I am using Active in several reports and elsewhere to filter tasks. If I rename Active to Assigned will that change cascade throughout or is it going to break everything? If it breaks everything, can I see where it is referenced so I know all the places it needs to change? I know it is in automations, filters, reports, buttons via formula url, etc.

------------------------------
Ivan Weiss
------------------------------

ivanweiss · Answer

Okay all done, thanks Mark!&nbsp; It wasnt too bad, good call on the automations as they didnt pull in the usage tab.&nbsp; Now hopefully everyone reports it is working as expected today :)------------------------------Ivan Weiss------------------------------

markshnier__you · Answer

It will break everything.&nbsp;You need to do this off hours. Then carefully walk down the Usage Tab on the field properties to fix every place it's used.&nbsp;I'm not actually sure if the usage tab can "see" the Usage on Automations.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commarkshnier2@gmail.com------------------------------

ivanweiss · Answer

Ugh that is what I was afraid of.&nbsp; I will take a look at it...&nbsp; What about converting the existing data?&nbsp; Is there an easy way to do that?------------------------------Ivan Weiss------------------------------

markshnier__you · Answer

Converting is easy.&nbsp;Run a report with records in Status Active. Then use use the "More" button to "search and replace" in this report&nbsp;also remember it's free to make a duplicate of your app with data. Do you can have a back up and / or practice a bit first.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commarkshnier2@gmail.com------------------------------

Forum Discussion

Will changing text multiple choice options break formula's

4 Replies

Related Content

Using Grid Edit to Edit Multiple Records at Once

Formula needed to pull out most recent status of a logged multiple choice field

Changing/setting record owner

Historical Date Change Tracking

Edit Multiple Records at Once with Grid Edit