Skip to main content

Forum

Welcome to the Ninox community

Search all topics or ask a question

Badges

Latest Posts

Re: Help with a Formula in a list view
@Agassi Oops, you said multiple treatments. Try: if contains(Treatment.Product.number(Type),5) then Paid * 0.25 else Paid * 0.15 end
- Fred
- 2 mths ago
- Get help
- Reported - view
Re: Sorting for a View Element
@RoSoft_Steven This worked for me: let list := switch n do case 1: (me order by firstname) case 2: (me order by lastname) case 3: (me order by company) case 4: (me order by website) case 5:…
Attachment
- Fred
- 2 mths ago
- 2
- Get help
- Reported - view
Re: Sorting for a View Element
@Michael Blechinger check out @Sotirios Zormpas great Dashboard Template for what you can do with HTML and Ninox.
- Fred
- 2 mths ago
- 1
- Get help
- Reported - view
Re: Sorting for a View Element
@John Halls You are correct. Sorry for spreading misinformation. 😢
- Fred
- 2 mths ago
- 2
- Get help
- Reported - view
Re: Sorting for a View Element
Jacques has some good tips on ordering. So you could do something like: let ActiveRecords := (select 'Line-up' where Zeitaufzeichnung.'Aufzeichnungen Meldung' like "recordings");…
- Fred
- 2 mths ago
- Get help
- Reported - view
Re: Negative Round number make the APP CRASH!!!
@MZ That sounds like an important part that didn’t get translated.
- Fred
- 2 mths ago
- 1
- Get help
- Reported - view
Re: Date formula
@wright. 74472 Well, it is and it isn't. First let me know what is your background with databases or coding? Now tell me what you want these month to month formulas?…
- Fred
- 2 mths ago
- Get help
- Reported - view
Re: Date formula
@wright. 74472 said: also i tried downloading the time tracking template. It just goes to my ninox page and does nothing It sounds like you have the cloud version of Ninox.…
- Fred
- 2 mths ago
- Get help
- Reported - view
Re: Date formula
@wright. 74472 Forgot to mention that if you are accessing data in a child table then you don't need a select statement. You can just reference the child table in code:…
- Fred
- 2 mths ago
- Get help
- Reported - view
Re: Date formula
@wright. 74472 if there is a field called Date then something like: select Timesheets where Date = date(2026,02,27) Where Timesheets is the name of the table that stores individual days.…
- Fred
- 2 mths ago
- Get help
- Reported - view
Re: Date formula
@wright. 74472 There are many date functions you can use. One is day(). There are many others. Things will look different and you may want to use pages/dashboards to display information.…
- Fred
- 2 mths ago
- Get help
- Reported - view
Re: Date formula
@wright. 74472 Can you explain how you use start date to limit the Display field only if?
- Fred
- 2 mths ago
- Get help
- Reported - view
Re: Date formula
@wright. 74472 I see the code, but which specific field do you use to mark days that are not part of the month?
- Fred
- 2 mths ago
- Get help
- Reported - view
Re: Date formula
So what field do you use to hide Day 29 and 30? Maybe lead with that field, then filter on days of the week. Also, as an FYI, when you find your self creating fields that have a number at the end…
- Fred
- 2 mths ago
- Get help
- Reported - view
Re: Select a Record from a subtable to reference in main Table
I'm guessing that Articlelist is a dynamic field. Whenever you do a select, Ninox always returns an array, even if only 1 record is found. So you need to wrap your select with a first() or last().…
- Fred
- 2 mths ago
- Learn and share
- Reported - view
Re: Development Versions DB
@Rafael What was the solution?
- Fred
- 3 mths ago
- Get help
- Reported - view
Re: Development Versions DB
It seems to work for me. What is the problem with the button?
- Fred
- 3 mths ago
- Get help
- Reported - view
Re: Ninext project
As I'm trying out the new modularity, of course I'm using Ninext and I came across this issue (floating window): As you can see I can't see the bottom of the list.…
- Fred
- 3 mths ago
- Learn and share
- Reported - view
Re: Help with a Formula in a list view
Try: if contains(numbers(Treatment.Product.Type),5) then Paid * 0.25 else Paid * 0.15 end You are correct, the moment you have 2 or more treatments then Ninox will return an array.…
- Fred
- 3 mths ago
- Get help
- Reported - view
Re: Account Email
You should email support directly.
- Fred
- 3 mths ago
- Get help
- Reported - view
Re: Ninext project
@Jacques TUR Do we need to reset the DB out of compatibility mode?
- Fred
- 3 mths ago
- Learn and share
- Reported - view
Re: Ninext project
Congrats to @Jacques TUR! Ninext is now an official plugin. Yippeee! So what is the best process to switch over from the old way to the new plugin?
- Fred
- 3 mths ago
- 4
- Learn and share
- Reported - view
Re: Ninext project
@Jacques TUR Sorry to say I'm getting a major error. When I open my DB, it tries to load Ninext and get stuck there. This is using public cloud.
Attachment
- Fred
- 3 mths ago
- Learn and share
- Reported - view
Re: Some Help
@Rafael sorry, forgot numbers(). if (opt = "Major Project" and contains(numbers(a.Type_Project), 1)) or (opt = "Small Project" and contains(numbers(a.Type_Project), 2)) then
- Fred
- 3 mths ago
- Get help
- Reported - view
Re: Some Help
Multi- choice (simple or dynamic) can return an array of selections. The best way to deal with it is to use the contains() command. if (opt = "Major Project" and contains(a.…
- Fred
- 3 mths ago
- Get help
- Reported - view

1 2 3 4 5 156

Back to top

Overview

View all topics