0

If x contains y then formula

I am trying to create a fiter for Kanban view. 

 

If Invoice contain specific text in a linked table named comments to sort it in a certain column.

 

I am trying: if last('Invoice Notes'.Comment) contains "RFP" then "RFP" else "Incomplete"

 

How do I write the contains in Ninox code? I couldnt find anything in the manual that explains the contains formula. 

 

Thanks

S Moore

4 replies

null
    • SMoore
    • 5 yrs ago
    • Reported - view

    Figured it out!

     

    if [contains(last('Invoice Notes'.Comment),"RFP")] then "RFP" else "Incomplete"

    • SMoore
    • 5 yrs ago
    • Reported - view

    Update: the formula worked, but did not actually sort the invoices.

    • SMoore
    • 5 yrs ago
    • Reported - view

    bump

    • SMoore
    • 5 yrs ago
    • Reported - view

    I still am unable to figure this out. 

Content aside

  • 5 yrs agoLast active
  • 4Replies
  • 2000Views