Filtering Formula's

(2) Share

Report

Posted on by DerrickH

192

Hey all,

Need a bit of help here. I have this formula below:

- Search(Filter(MSDriverList,DriverType.Value="CDL Driver" || DriverType.Value="Non CDL CMV Driver"),SearchInput1.Text,EmployeeName,EmployeeName)
 
I need to add a initial filter before the 'DriverType' which includes the column 'EmployeeStatus'="Active".......is the filter below the best way to approach this?
 
- Search(Filter(MSDriverList,EmployeeStatus.Value="Active",And(DriverType.Value="CDL Driver" || DriverType.Value="Non CDL CMV Driver")),SearchInput1.Text,EmployeeName,EmployeeName)

Categories:

Using Apps Using Formulas

All responses (3)

Answers (0)

CA1105 182 on at

Like (0)

Report

Filtering Formula's

Is it resolved? Do you need any further help?
Suggested answer

HaythemELAZHAR 16 on at

Like (0)

Report

Filtering Formula's

You can change the data limit to 4 for example to see if your formula has a delegation problem or not. That way you can be sure if your formula it is okay or not.
Suggested answer

FLMike 26,162 on at

Like (0)

Report

Filtering Formula's

HI

So there is no Problem with what you have at all, looks good

If you have any delegation issues, (which I cannot see unless its in the dev ui) then I can help you resolve them but what you have is good