0

How to set a value of a field if a subtable contains rows

Hi, 

I got a form which contains a subtable which links to another table. If I have a row in that subtable on this record, then I want a field to show a certain value (I want to indicate that there is data present). How I can I do this?

2 replies

null
    • Stijn_Klaassen
    • 4 yrs ago
    • Reported - view

    Due to sensitive data I can unfortunatly not easily make screenshots

    • Choices_Software_Dean
    • 4 yrs ago
    • Reported - view

    Depending on your situation, you may be able to use a select statment, for example:

     

    first(select Person where 'First Name' like "Hans")

     

    More examples can be found at (scroll down 1/3 page):

    https://ninox.com/en/manual/calculations/reference-of-functions-and-language

Login to reply

Content aside

  • 4 yrs agoLast active
  • 2Replies
  • 750Views