Home / QIN / Knowledge Base / 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.

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?

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:

Comments

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

The content of this field is kept private and will not be shown publicly.
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.

Rate This

0
No votes yet
Your rating: None

© 1997-2012 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit