Skip to main content

Ninox-Documentation

arisziniatis

arisziniatis

8
0
0

Joined: 26 Mar 2023

My Posts

Latest Posts

Re: Get count of chosen values from different table
@Fred @Jacques TUR Hello, do you know if somebody would be interested in helping me improve my database (as previously discussed in this topic) for a fee? Thank you.
- arisziniatis
- 2 mths ago
- Get help
- Reported - view
Re: Get count of chosen values from different table
@Fred One last thing, If I was to go on and change my database like you and @Jacques TUR recommend, do you have in mind a specific guide or tutorial I could study that matches my database senario?…
- arisziniatis
- 8 mths ago
- Get help
- Reported - view
Re: Get count of chosen values from different table
@Jacques TUR Yes!!! It works, thank you so much. I placed it like this: let a := Name; count((select Timetable)[eval("text(" + a + ")", this) = "norm" and month(Date) = 1]) So,…
- arisziniatis
- 8 mths ago
- Get help
- Reported - view
Re: Get count of chosen values from different table
@Fred Thanks, I will probably have to do that if there is no other way. However, It would be nice too if I could make that little formula work. It seems to require an advanced expression to work,…
- arisziniatis
- 8 mths ago
- Get help
- Reported - view
Re: Get count of chosen values from different table
Thank you for taking the time and all the answers. The last functions works (but not the way I want to use it) This is what I am trying to do: My database has 2 tables - First table "Timetable" .…
- arisziniatis
- 8 mths ago
- Get help
- Reported - view
Re: Get count of chosen values from different table
Sorry, it does not work for me that way
- arisziniatis
- 8 mths ago
- Get help
- Reported - view
Re: Get count of chosen values from different table
Thank you for your answer Steven, Mind the first line works count(select Timetable where text(Jim) = "norm") I have other reasons why I want to express the formula like this: let a := "Jim";…
- arisziniatis
- 8 mths ago
- Get help
- Reported - view
Get count of chosen values from different table

Hello, The formula below counts the number of records in the table Timetable where the choice field Jim has been chosen the value "norm" (it works). count(select Timetable where text(Jim) = "norm")…
- arisziniatis
- 8 mths ago
- 18replies
- 308
- Get help
- Answered
- Answered

Back to top

Ninox-Documentation

Overview

View all topics