Skip to main content
Question

Report Listing Records With Invalid Field Selections

  • September 2, 2021
  • 0 replies
  • 45 views
I am looking for a way to identify records that have an invalid entry for my multiple choice and multi-select fields.  We are going to be uploading several different sets of data want to be able to catch/correct records that were loaded with an invalid selection.  I thought Quickbase used to show these in red font but am not sure that is still true and am looking for an easier way to find these.  Any suggestions?

Thanks!
Rachel

------------------------------
Rachel Miller
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+17
  • EvanMartinez
  • Community Moderator
  • September 3, 2021
Hi Rachel,

For the multi select or multiple choice fields that you want to check for invalid entries do they have the option Allow users to create new choices  checked by chance in the field settings? If they do then new options added in by accident wouldn't show up red, they would just be counted as valid options and added to the list of possible choices. That might be part of the issue if you are seeing strange values appearing in the fields. 


------------------------------
Evan Martinez
------------------------------
Terms & ConditionsAccessibility statement