Is there a way to remove choices from a multiple-choice text field? Is this still possible when you set the field to allow users to add choices?

Knowledge Base

Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.

1. In the table bar on any application page, click the table containing the field. Within the menu that appears, select Customize --tablename-- table > Fields.

2. Click the field's name that you want to modify.

3. In the "Choices" text box, select the choices that you no longer want included in the list, press the DELETE key, and then click "Apply Changes".

This works whether or not users can enter choices.

If the choice is not used by any records, it is permanently removed. However, if it is used by a record, it will not appear as a choice in most cases, but will appear as a choice when you select the record that still uses it. If you select a different choice the next time you go to that record, it will not be in the list. But, if you save that record with the deleted choice still selected, it will add the deleted choice back into the list.

Tip: You might also want to use "Find and Replace" to clean up your data.

Tags:

33943 reads

Comments

deleting a choice within a multiple choice dropdown box

Submitted by Sandy McCarthy (not verified) on Wed, 10/10/2012 - 16:51.

Hi-

I've been follwoing the directions in this article: http://quickbase.intuit.com/developer/knowledge-base/there-way-remove-ch...

Everything goes well until I hit step #3. There are no choices in which to delete and I know we are using this field and the choices provided.

What can I be doing wrong?

re: deleting a choice within a multiple choice dropdown box

Submitted by bcafferelli on Wed, 11/14/2012 - 15:17.

Hi Sandy,

My name is Brian from QuickBase Support. If you could visit support.quickabase.come to open a support case, I'll be happy to take a look at your multiple choice field. Creating a case for it will allow us to share information about the app privately.

If you could include in the case a request to forward the case to me, that would be great!

Thanks,

Brian

QuickBase Support

Converting from Text Field to Text - Multiple Choice

Submitted by Anonymous (not verified) on Fri, 07/31/2009 - 14:30.

If I change a field from a Text field to a Text - Multiple Choice field, will any of the existing data be lost? Does it matter whether a particular piece of data appears in the new list of choices for that Multiple Choice field?

Converting from Text Field to Text - Multiple Choice

Submitted by QB_Support_Karis (not verified) on Thu, 08/06/2009 - 16:21.

Hello, If you have a text field and convert it to a text multiple choice field, you will not lose the data already entered into that field. If the choices you set for the multiple choice field are not the same as the data already entered into the field, the data previously entered that doesn't match the new choices will show up as red. Thanks, Karis QuickBase Support

Change multiple choice text field list for Specific Role

Submitted by Anonymous (not verified) on Fri, 04/03/2009 - 14:29.

Is there a way to remove choices from a multiple-choice text field for specific roles? I only want a certain role to be able to change a status to "closed" and the status is currently a multiple choice text field.

Change multiple choice text field list for Specific Role

Submitted by QB_Support_Karis (not verified) on Fri, 04/03/2009 - 16:20.

Hi, While you can't limit a role to see only certain choices in a multiple choice field, if you create another table to hold a record for each status, you could limit a role's visibility to those status records. Does that information help? Thanks, Karis QuickBase Support

Post new comment

Your name: *

E-mail: *

The content of this field is kept private and will not be shown publicly.

Homepage:

Subject:

Comment: *

Input format

Filtered HTML

Web page addresses and e-mail addresses turn into links automatically.
Allowed HTML tags: <a> <p> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <embed> <object> <param> <strike> <caption> <img> <h1> <h2> <h3> <h4>
You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <c>, <cpp>, <drupal5>, <drupal6>, <java>, <javascript>, <php>, <python>, <ruby>, <xml>. The supported tag styles are: <foo>, [foo].
Images can be added to this post.

Plain Text

Web page addresses and e-mail addresses turn into links automatically.
Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>

More information about formatting options

Word verification: * Type the characters you see in this picture.

(verify using audio)

Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

Knowledge Base