Skip to main content
Forum
Privacy
Contact
How to enable Javascript
Sign Up
Log in
Welcome to the Ninox community
Search all topics or
ask a question
Learn and share
Get help
Updates & status
Plugins
Documentation
Setup
Databases
Automation
My account
Administration
Solutions
Ninox 4
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
Follow
Joined
Thu Feb 06 18:42:57 UTC 2020
3939
posts
639
likes received
5
followers
Badges
Latest Posts
Re: Ninext: bugs & fixes
@Jacques , you mention that the plugin does not update itself. So what does it mean when I see 3.0.5 in the plugin but I did NOT update the plugin manually?
Fred
Fred
7 mths ago
Plugins
Reported - view
Re: Look up query
@horst. droege said: Lets say if I have a main record which may has 8 payments, how could I display the payments? In a subtable, may showing 3 payments with an option to scroll between the 8…
Fred
Fred
7 mths ago
1
Get help
Reported - view
Re: Look up query
Ok, it seems that the Payment table is a child of the Main table (or whatever the actual name is). Go to Payments then Edit Fields. Now on the right side,…
Fred
Fred
7 mths ago
Get help
Reported - view
Re: Look up query
Short answer, Yes. Ninox, like any relational databases, can do anything a spreadsheet can do, but faster. How familiar are you with relational databases? What is your workflow for this database?…
Fred
Fred
7 mths ago
Get help
Reported - view
Re: Ninext Plugin (v3.x) - Best Practices & Recommendations
I don't know what to say, but when I checked the version of Ninext that I'm running and it says it is 3.0.4. I did not update the plugin manually as I didn't know I had to before your post.
Fred
Fred
7 mths ago
Plugins
Reported - view
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
Fred
7 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
Fred
7 mths ago
Get help
Reported - view
Re: Release Notes gone
3.17.7 got rolled back.
Fred
Fred
7 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
Fred
7 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
Fred
8 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
Fred
8 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
Fred
8 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
Fred
8 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
Fred
8 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
Fred
8 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
Fred
8 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
Fred
8 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
Fred
8 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
Fred
8 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
Fred
8 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
Fred
8 mths ago
1
Get help
Reported - view
Re: Sorting for a View Element
@John Halls You are correct. Sorry for spreading misinformation. 😢
Fred
Fred
8 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
Fred
8 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
Fred
8 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
Fred
8 mths ago
Get help
Reported - view
1
2
3
4
5
158
Ninox-Website
Overview
Learn and share
Get help
Updates & status
Plugins
Documentation
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Plugins
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
History
Templates
Use cases
Automation
Performance
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Backups and storage
Process monitor
Solutions
Ninox E-Invoice
Ninox 4
View all topics