Hi, My request is the ability to use a comma separated or delimited list of exact values when the property used for filtering is number based. If I create a filter for a list with a text property, in the options menu I get "contains any of", which from there, gives me the below screenshot option of copying and pasting a delimited list of values to pull with. However, if the property is a number property, there is no "contains any of" option. I submitted a support ticket and the answer I got was: Jumping right in, this is expected as it is only specific to Text properties as outlined here. This is likely due to the backend logic of how the filter works, and generally only works on text-based values and not number values (also because the issue of overlapping numbers is significantly more prevalent due to the small number of possible permutations). For example, if we search for " contains any of 38", all of the following would technically be pulled in which would open up a much larger margin of error: 38 138 4343894 383838 038471 It would be significantly harder to filter accurately, which is likely why the team did not include this as a filter. Seems like, to me at least, you could have an option of "Exactly Contains Any Of" which would tell the filtering to only look for exact values, like a VLookup, and solve this. Now I am going to be forced to convert a number property to a text property so that if I need an exact list of customers I can use that delimited function.
... Mehr anzeigen