Hello,
Its urgent please if possible.
I was using this app normally, then it gave me an error. When I run the app it shows results then everything goes and give me this error [Issue 1.PNG] attached.
When I run the editor I get another error as in [Issue 2.PNG].
My formula is showing results when the department name is in either the first or second or third... eight stage.
SortByColumns(
Filter(
OnlineTickets,
VarUserRole.Text="Super" Or
((OnlineStageOneDepartmentName=VarUserDepartmentName.Text) Or
(OnlineStageTwoDepartmentName=VarUserDepartmentName.Text) Or
(OnlineStageThreeDepartmentName=VarUserDepartmentName.Text) Or
(OnlineStageFourDepartmentName=VarUserDepartmentName.Text) Or
(OnlineStageFiveDepartmentName=VarUserDepartmentName.Text) Or
(OnlineStageSixDepartmentName=VarUserDepartmentName.Text) Or
(OnlineStageSevenDepartmentName=VarUserDepartmentName.Text) Or
(OnlineStageEightDepartmentName=VarUserDepartmentName.Text)),
MyTickets=false Or OnlineCurrentDepartmentName=VarUserDepartmentName.Text,
IsBlank(TextInput2) Or (OnlineCustomerID=TextInput2.Text Or ID=Value(TextInput2.Text)))
,"ID",
Descending)
Please I need a fix for this.
Thanks
