FILTER on data variable


I can bring back all records filtered on a text field. But what if i want to have the filter say bring back all records where the first 5 characters of the field are "xxxxx. When using a formula on the filter field, I do not see how to do this, or if it is possible.



If I understand correctly what you want to do, yes it is possible! You can see an example of matching filter results in my tag input tutorial. If you want to get letters from the beginning of a text specifically, use a REGEX formula instead of CONTAINS!