I have an Enumlist of zip codes that when trying to use the UI based filter, it’s not displaying the whole number for those that start with 0’s. Any idea how to fix this?
First, make sure that your Zip Code is defined as Text and not Number. This should fix any new entries but you may need to update existing entries.
I presume you are using a sheet. To fix previous entries there, select the column and change the format so that it shows 5 digits with leading zeros using the proper format string. Once you have the column in the sheet showing the correct values, copy the entire column. Change the format of the column to Text (not general) and then paste in the copied column - values only.
I hope this helps!
My zips are defined as an enumlist in appsheet and are a data validation in the sheet from a range. In the sheet the columns are formatted as plain values.
I’ve continued to look for answers and noticed that the issue is only within the desktop view, and not present when loading from appsheet on iOS. Thinking this may be a bug? Or maybe it’s in part due to the volume causing a processing error? I have 41,702 choices in the list.
As a work around I have created two separate columns. The enumlist which they pick from, which copies to another column that is just longtext. That allows the search/filter feature to work without truncating the zeros.