Fred's Profile | Ninox community

Badges

Latest Posts

Re: simple dynamic field - small issue
Damn, @RoSoft_Steven beat me to it. Anyways. You are on the right path. A dynamic choice field is a soft link. It will show you the recID (with number()) or the text (with text()) that you set to…
- Fred
- 3 days ago
- Get help
- Reported - view
Re: Auto-fill field not triggering when record is created via popup — is this expected?
I can duplicate the issue when I use the public cloud. There is some limitation with triggers that are not specified and only discovered through trial and error.…
- Fred
- 4 days ago
- Get help
- Reported - view
Re: numeric order by child table field
It is confusing. Id would seem to be just a number but it actually contains the table code and the record number. If you do: debugValueInfo((select parent).children.…
- Fred
- 9 days ago
- Get help
- Reported - view
Re: Help with a Formula in a list view
If you are satisfied with the results, when you have moment please mark the post answered. :)
- Fred
- 2 wk ago
- 1
- Get help
- Reported - view
Re: textfield with text suggestions fetching data from same field which have the same link to a record.
@Michael Blechinger I haven't seen anyone do an auto populate field through Ninox coding. Maybe someone has an idea using javascript?
- Fred
- 2 wk ago
- Get help
- Reported - view
Re: Sorting for a View Element
@Michael Blechinger Sorry, mis read your post. @John Halls is correct that you can't pre-sort views. If you see that my "working code" was for @RoSoft_Steven 's HTML table.
- Fred
- 2 wk ago
- Get help
- Reported - view
Re: Sorting for a View Element
@Michael Blechinger Did you replace the View code with the one I posted?
- Fred
- 2 wk ago
- Get help
- Reported - view
Re: textfield with text suggestions fetching data from same field which have the same link to a record.
@Michael Blechinger said: So I would like to have the possibility to get a suggestion while starting to type. Typing, where? Can you be more specific? If Tags is a field,…
- Fred
- 2 wk ago
- Get help
- Reported - view
Re: Lost database
I'm sorry this happened to you. The only people who can help is Ninox Support. If you haven't already, please send them an email.
- Fred
- 2 wk ago
- Get help
- Reported - view
Re: Help with a Formula in a list view
@Agassi Just from experience. But using troubleshooting steps. When I did something similar in my test DB, it didn't work. So the first thing I did was create another formula field and put my version…
- Fred
- 2 wk ago
- 1
- Get help
- Reported - view
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
- 3 wk 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
- 3 wk 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
- 3 wk ago
- 1
- Get help
- Reported - view
Re: Sorting for a View Element
@John Halls You are correct. Sorry for spreading misinformation. 😢
- Fred
- 3 wk 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
- 3 wk 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
- 3 wk 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth ago
- Learn and share
- Reported - view

1 2 3 4 5 155

Welcome to the Ninox community

Fred

Re: simple dynamic field - small issue

Re: Auto-fill field not triggering when record is created via popup — is this expected?

Re: numeric order by child table field

Re: Help with a Formula in a list view

Re: textfield with text suggestions fetching data from same field which have the same link to a record.

Re: Sorting for a View Element

Re: Sorting for a View Element

Re: textfield with text suggestions fetching data from same field which have the same link to a record.

Re: Lost database

Re: Help with a Formula in a list view

Re: Help with a Formula in a list view

Re: Sorting for a View Element

Re: Sorting for a View Element

Re: Sorting for a View Element

Re: Sorting for a View Element

Re: Negative Round number make the APP CRASH!!!

Re: Date formula

Re: Date formula

Re: Date formula

Re: Date formula

Re: Date formula

Re: Date formula

Re: Date formula

Re: Date formula

Re: Select a Record from a subtable to reference in main Table

Overview