Log in to AnswerLog in to Follow
2020-11-13 06-20-56
Kane Loony
11Views
3Comments
Solved
Best case nested if condition in a widget
Question
Logic
Traditional Web
Application Type
Traditional Web

Hi All,


I have a table records which is inside record have name and status column.

I want add checkbox in every record with 2 condition.

If role is Staff and status is 1, the Widget will show, else False.

If role is Manager and status not 1, The widget will show, else False


I write query like this

If(CheckStaffRole(UserId:), NameTable.List.Current.NAME.Status = 1, 
If(CheckManagerRole(UserId:), NameTable.List.Current.NAME.Status <> 1, False))

But this query show not expected what i want


Thanks,

0
0
29 Dec 2021

Hello Kane,
may be your if condition is wrong,
Can you please try this (two scenario)and check once
let me know its work for you or not

First way :- If(((CheckStaffRole(UserId:) and NameTable.List.Current.NAME.Status = 1) or (CheckManagerRole(UserId:) and NameTable.List.Current.NAME.Status <> 1)),true,false)

Second way :- If((CheckStaffRole(UserId:) and NameTable.List.Current.NAME.Status = 1),true,if(CheckManagerRole(UserId:) and NameTable.List.Current.NAME.Status <> 1,true,false))



Thanks and regards,

Akshay Deshpande

0
0
29 Dec 2021

Hi,


First condition expected but second condition not expected (widget not show even status not 1)


Thanks

0
0
29 Dec 2021

Replying to Kane Loony's comment on 29 Dec 2021 06:00:41

Please check could you logged in with manager role or not. it will be working fine if you looking through manager roles (check that have your correctly checking manager role or not)

0
0
29 Dec 2021
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.