Filter function

[pdayboll]

Hi

Could someone help me with the new "filter" and "filtervalue" functions. I am lost as to how to use these.

Thanks

Paul

[MoonShadow]

Hi Paul, Welcome to the Forum. FM Help explains it. You could also do a search here to find many posts on the subject. Here is one simple example for using Filter()

Users type a credit card number in a field. But they frequently also type dashes or spaces. You want the field to only contain numbers for uploading to credit card service. So, on your CreditCardNumber field, Options > Auto-Enter, select by Calculation and type:

Filter(CreditCardNumber ; "0123456789")

Anything you put in the Filter will be the only acceptable characters. Then, after exiting the calc box be SURE to unclick 'Do Not Replace Existing Value' and the field will self-correct itself (if someone goes back and adds a dash, it will simply remove it).

On text if you want all alpha acceptable, Filter() requires both upper and lower case be included as Filter(field; "ABCDEabcde"). I hope that helps you. If you have more specific needs, let us know.