Hi - I have an app that is now getting a lot of data in the main screen, and I want to add a combo box so the user can filter by a certain customer. On a different screen in the app I have this same setup, except is also includes a textbox where the user can also filter on a name. We also have different levels of security based on whether the user is an approver or not. This is controlled by a global variable like so:
or for a customer:
I'm getting lost in the syntax for what I think is an easy change...
For the gallery that works, I have this:
//If current user is approver show all, else filter the data based on the customer logged in
SortByColumns(
Search(
Filter(
'Master Ingredients List',
If(
gvCurrentUser = "FIW Approver",
If(IsBlank(cbCustFilter_Ing.Selected.Value),
true,
Customer.Value = cbCustFilter_Ing.Selected.Value
),
Customer.Value = gvCustomer
)
),
TxtIngFilter.Text,
"Title"
),
"Title",
Ascending
)
I have created a new combo box named cbCustFilter_IngEntry, and I want to remove the TxtIngFilter.Text bit, so I tried this but the syntax is wrong and I can't see how...
//If current user is approver show all, else filter the data based on the customer logged in
SortByColumns(
Search(
Filter(
'Master Ingredients List',
If(
gvCurrentUser = "FIW Approver",
If(IsBlank(cbCustFilter_Ing.Selected.Value),
true,
Customer.Value = cbCustFilter_IngEntry.Selected.Value
),
Customer.Value = gvCustomer
)
),
"Title",
Ascending
)
Cheers, GraemeNZ
