How to hide a lookup field based on the calculated field value.

  • 28 September 2018
  • 1 reply
  • 42 views
C
Badge +2

Hi,

 

I got a requirement to create a Sign Up form for the Visa Corporate cards, we have total 3 corporate cards. 

once the card is booked no other user can book the same card.

For this requirement I have created 2 SharePoint list.

1st list called cards.  I have created the below mentioned fields,  cardsavailable and available are calculated fields.

219324_pastedImage_2.png

2nd list is a actual sign up sheet called visa corporate. here I have added a lookup field that comes from the 1st list(cards)

219326_pastedImage_4.png

Then I built a nintex form on the sign up sheet and added a lookup field with the below mentioned filter condition, when the card is available on the 1st list then only it will appear on the sign up sheet, otherwise not shown up in the dropdown field of the lookup field.

219328_pastedImage_6.png

 

What I want, if the all cards are booked on the 1st list, then what formula can I use to hide the lookup field in the sign up sheet? Note: when all cards are booked on the 1st list then drop down field shows no values (cards). #

219329_pastedImage_1.png

Thanks.

1 reply

allan
Userlevel 4
Badge +9

If you only have 3 cards, what you can do is have a rule with 3 lookup functions (one for each card) and if each card is reserved, hide the control
Something like this :


lookup("Cards","ID", 1,"available") == "no" && lookup("Cards","ID", 2,"available") == "no" && lookup("Cards","ID", 3,"available") == "no"

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings