Filtering Formula's

(2) Share

Report

Posted on by DerrickH

194

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

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Michael E. Gernaey 52,051 Super User 2025 Season 2 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

Was this reply helpful? Yes No
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.

Was this reply helpful? Yes No
CA1105 515 Super User 2025 Season 2 on at

Like (0)

Report

Filtering Formula's

Is it resolved? Do you need any further help?

Was this reply helpful? Yes No