Issue with the 'select ... where...' function
Good morning !
I create a personalized address book in Ninox. For each company, there are several contacts and I need to display the names of the company's managers only. Here is my formula:
let directeurices := count(select 'Équipe impliquée' where 'Équipe impliquée'.'Type de fonction' = 1) if directeurices = 1 then 'Équipe impliquée'.'Contact lié'.'Nom affiché' else if directeurices > 1 then 'Équipe impliquée'.'Contact lié'.Nom end end
... and I get error messages all the time: unexpected kewyords, table wasn't found, expected symbol, and so on. What do I have to do? Here is a screenshot, too :
Thanks a lot for your support.
Have a nice day!
You don't need 'Equipe impliquee' twice. Just have
let directeurices := count(select 'Equipe impliquee' where 'Type de fonction' = 1)
From the looks of your table, you can also remove the select statement as well:
let directeurices := count('Equipe impliquee'['Type de fonction' = 1])
You use the relationship link in lines 3 and 5, so I am guessing that you only want search related records.
By using the select Ninox looks at the entire table of Equipe impliquee and finds any records with a Type de fonction = 1 not just the one related to the current record in Compagnies.
Thanks and !
I tried both of your solutions, but without success :( any other ideas?
And the other solution :
Thanks a lot for your answer!
In a separate formula field does the following work?
Can you post a sample copy of your DB?
Well I guess we should have been clear about asking what table are you starting in. According to your first post, it showed you were in the Compagnie table.
We did not know that you were trying to do this from the Spectacles table.
Glad things are working. If you feel like your question was solved please mark the post "answered".
AMAZING! Now it works, and now I understand what I was doing wrong.
Thanks a lot for the explanation, it's very clear.
Have a nice evening!
- Status Answered
- 4 days agoLast active
- 3 Following