0

Filter records help please

I have a table 'ASSIGNMENTS' with a field (Y/N) 'EMAIL TASK'.

 

In my 'TASKS' table I have a formula field "ASSIGNED EMAILS" with 'ASSIGNED ENGINEERS'.EMAIL which displays the email addresses of the engineers.

How do I filter the formula to only display the emails of engineers where 'EMAIL TASK is true?

'ASSIGNED ENGINEERS'.EMAIL where 'ASSIGNED ENGINEERS'.'EMAIL TASK' = true

Above errors out on me with end expected at 'where'.

What is the correct syntax for this please.

5 replies

null
    • Ninox partner
    • RoSoft_Steven.1
    • 3 mths ago
    • Reported - view

    ('ASSIGNED ENGINEERS' where 'EMAIL TASK' = true).EMAIL

    I think....

      • Alan_Cooke
      • 3 mths ago
      • Reported - view

       

    • Fred
    • 3 mths ago
    • Reported - view

    hmm, i thought where is only used in select statements. I couldn't get a where to work in with a reference field.

    If you are using links then you just use the square brackets.

    'ASSIGNED ENGINEERS'['EMAIL TASK' = true].EMAIL

    That is if 'ASSIGNED ENGINEERS' is also the one side of the relationship.

      • Alan_Cooke
      • 3 mths ago
      • Reported - view

      Boom!  Nailed it - many thanks!!

      • John_Halls
      • 3 mths ago
      • Reported - view

       You are right. where only works with select statements. Square brackets work with both but can be slower with a select statement.

Login to reply

Content aside

  • Status Answered
  • 3 mths agoLast active
  • 5Replies
  • 25Views
  • 4 Following