Contact Sales to request a demo
Request demo
Product
Platforms
Templates
Security
Customer Reviews
Product Updates
Solutions
Success Stories
Partners
Partners
Become Our Partner
Pricing
Support
Help Center
Webinars
Hero Webinar
Manual
Forum
Tutorial Videos
Blog
Contact us
Search
How to enable Javascript
Sign Up
Log in
Support
Forum
Home
Search the community
Home
Learn & Share
Get help
Knowledge Base
Latest Activity
Contact Us
Privacy
Home
Latest Posts
Re: syntax problems
Thank you Fred; that works perfectly for me! Problem solved
Jarno Vande Walle
Jarno_Vande_Walle
4 wk ago
Get help
Reported - view
Re: syntax problems
Yes, that would make more sense. Indeed; this works! However, is there a way in which the dynamic field is automatically populated by the "date" field in prestaties?…
Jarno Vande Walle
Jarno_Vande_Walle
1 mth ago
Get help
Reported - view
Re: syntax problems
Hi Fred Thank you for the help - I've tried what you said but something is not working. In the table Loonhistoriek I created the dynamic choice field and I get the same result as in your…
Jarno Vande Walle
Jarno_Vande_Walle
1 mth ago
Get help
Reported - view
Re: syntax problems
Hi Fred wow, that does do the trick indeed! I tried the button, which worked - I now pasted the the formula into the Trigger after update and it also works its wonder.…
Jarno Vande Walle
Jarno_Vande_Walle
1 mth ago
1
Get help
Reported - view
syntax problems
Hi everybody, I'm hoping that the power of the community could help me out, I've found myself stuck and cannot find the solution to a problem. First some background information:…
Jarno Vande Walle
Jarno_Vande_Walle
1 mth ago
12
replies
79
Get help
Re: sum results of this year
Wonderful! That does the trick indeed - I tried something similar before but now I see where I got it wrong. Thank you for the prompt reply and solution to the problem, Fred!
Jarno Vande Walle
Jarno_Vande_Walle
1 mth ago
Get help
Reported - view
sum results of this year
Hi guys I seem to be stuck and cannot find the solution to my problem on the Ninox YouTube channel. Here is what I would like to achieve: sum up the results of a formula field in another table where…
Jarno Vande Walle
Jarno_Vande_Walle
1 mth ago
2
replies
28
Get help
Answered
Answered
two-way communication with external app?
I was wondering if it were possible to fill out a form (e.g. in Google Forms) that talks with Ninox in a two-way-communication. In Ninox a have different projects with a yes/ no field indicating…
Jarno Vande Walle
Jarno_Vande_Walle
2 mths ago
1
reply
31
Get help
Re: Formula field not displayed in table view
@John Halls That does the trick! Perfect, thank you very much indeed
.
Jarno Vande Walle
Jarno_Vande_Walle
2 mths ago
Get help
Reported - view
Formula field not displayed in table view
Hi guys, I've entered a valid Formula in Ninox that displays the result in the Form view. However, this result (only one) is not displayed in the Table view.…
Jarno Vande Walle
Jarno_Vande_Walle
2 mths ago
2
replies
22
Get help
Re: Display quarterly results
Update - thanks to your input, the puzzle was solved: sum((select Kosten where year(Factuurdatum) = year(today()) and quarter(Factuurdatum) = q).Bedrag) ==> instead of "q" I put "1" for the first…
Jarno Vande Walle
Jarno_Vande_Walle
8 mths ago
Get help
Reported - view
Re: Display quarterly results
Thx guys, but it still does not work I'm afraid. Could ik be because my summary table is a different table than the expenses table? The hierarchy is as follows: 1. Werven (=Construction sites) 1.…
Jarno Vande Walle
Jarno_Vande_Walle
8 mths ago
Get help
Reported - view
Re: Display quarterly results
Thx Fred but unfortunately the result is still 0,00 € (whereas there should be a number). Could it be because the value in yearquarter is displayed as "2021 Q1" instead of "1"?
Jarno Vande Walle
Jarno_Vande_Walle
8 mths ago
Get help
Reported - view
Re: Display quarterly results
Thanks for the feedback, guys - both work but when I use the following formula, I get the results of Q4 2021: let q := yearquarter(Today()); sum((select Kosten where yearquarter(Factuurdatum) = q).…
Jarno Vande Walle
Jarno_Vande_Walle
8 mths ago
Get help
Reported - view
Display quarterly results
I want to display the quarterly results from my invoices. I allready have the formula "quarter(Factuurdatum)" but I don't see how I can get the results.…
Jarno Vande Walle
Jarno_Vande_Walle
8 mths ago
10
replies
303
Get help
Jarno Vande Walle
Jarno_Vande_Walle
15
1
0
Joined: 04 Dec 2021
Follow
Home
Learn & Share
Get help
View all topics
Tags