0

Dynamic choice (programatically selected)

Hi All,

My doctor only wants to see the items that are relevant to an appointment. Items is a dynamic choice field.

I am able to find out the items that he can't charge for that appointment, but am unable to find something that can allow me to say, if charge items in this array, then don't show it. 

select Items where ItemCode not in myUsedItems;

Is there a replacement in Ninox for "in" function? Any help would be greatly appreciated. Thanks. 

1 reply

null
    • tejwant
    • 3 mths ago
    • Reported - view

    please ignore guys, I was able to use the forum help further and used the following: 

    (select Items)[not contains(myUsedItems,ItemCode)]

Login to reply

Content aside

  • 3 mths agoLast active
  • 1Replies
  • 45Views
  • 1 Following