Fred's Profile | Ninox community

Badges

Latest Posts

Re: copy table record with child records to another table record also with child records
@Mel Charles Look at the reference field name in JobLines to MultiJobs. You need to match the reference field name (line 9) not the table name. Unlike in create(),…
- Fred
- 3 mths ago
- Get help
- Reported - view
Re: copy table record with child records to another table record also with child records
what if you delete 9 - 12 and just see if the create line works. can you post a sample db?
- Fred
- 3 mths ago
- Get help
- Reported - view
Re: Release Notes gone
3.17.7 got rolled back.
- Fred
- 3 mths ago
- 1
- Get help
- Reported - view
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 mths 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
- 3 mths 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
- 3 mths 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
- 3 mths 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
- 3 mths 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
- 3 mths 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
- 3 mths 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
- 3 mths 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
- 3 mths 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
- 3 mths 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 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
- 3 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
- 3 mths ago
- 1
- Get help
- Reported - view
Re: Sorting for a View Element
@John Halls You are correct. Sorry for spreading misinformation. 😢
- Fred
- 3 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
- 3 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 mths ago
- Get help
- Reported - view

1 2 3 4 5 157

Welcome to the Ninox community

Fred

Re: copy table record with child records to another table record also with child records

Re: copy table record with child records to another table record also with child records

Re: Release Notes gone

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

Overview