Skip to main content
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
Service status
Documentation
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
3381
533
4
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
Re: How to auto-fill the relationship field choice?
@Rafael Just to clarify. You want to take a record in Documents and you want to create a new record in the Control table that links to the Documents record?…
Fred
Fred
9 mths ago
Get help
Reported - view
Re: Button script to select all items in defined Dynamic Multiple Choice field
@bflack said: Creating the dMC's with criteria is a great feature, but it turns out that the vendor changes the criteria for market reasons periodically, So group1 which use to consist of 3,18,…
Fred
Fred
9 mths ago
Get help
Reported - view
Re: Button script to select all items in defined Dynamic Multiple Choice field
Is Article.Collection a dynamic field as well? Or You said there are 6 - 8 dynamic choice fields. Are you always looking for the same grouping of Collections? Is one group (3,18,…
Fred
Fred
9 mths ago
Get help
Reported - view
Re: How to auto-fill the relationship field choice?
@Rafael Can you post what you have so far?
Fred
Fred
9 mths ago
Get help
Reported - view
Re: Error: Type not found: I when printing
@john cesta Sounds like you will have to email Ninox support. Good luck and let us know how it goes.
Fred
Fred
9 mths ago
Get help
Reported - view
Re: Mac App 3.11.8 - refresh/reload record list > only manual
yeah, i've noticed weird refresh issues with the MacOS app as well. You should submit a ticket so they know, but I wouldn't hold my breath about it getting fixed, or just knowing it is fixed.
Fred
Fred
9 mths ago
1
Get help
Reported - view
Re: Export file excel in a subtable.
@Nguyen Nhat Dong That view element is your Shipping table. So you can go to your shipping table and do a filter to recreate the records then create a view that has the appropriate fields then export…
Fred
Fred
9 mths ago
Get help
Reported - view
Re: Export file excel in a subtable.
@Nguyen Nhat Dong The subtable is just a table. If you are in admin mode you can see all of your tables. The subtable will be under the main table.
Fred
Fred
9 mths ago
Get help
Reported - view
Re: Export file excel in a subtable.
Here is what the docs say.
Fred
Fred
9 mths ago
Get help
Reported - view
Re: Error: Type not found: I when printing
Can you be a bit more descriptive of the steps you took? Are you printing using the default print layout? or did you create your own? Can you upload a sample DB, with no personal information?
Fred
Fred
9 mths ago
Get help
Reported - view
Re: Using a table selection in script
@Chris Mullett said: I am struggling to see the difference between your two scenarios, but I think the later is a clearer description Put another way, the first scenario asks if you want to include…
Fred
Fred
9 mths ago
Get help
Reported - view
Re: Error: Type not found: I when printing
Are you doing regular printing or dynamic?
Fred
Fred
9 mths ago
Get help
Reported - view
Re: Using a table selection in script
You wrote in the DB: I would like them to include records where Film.Chemistry id empty when ‘Select Chemistry’ is empty. Just to verify, you want to show records in Film where Film.…
Fred
Fred
9 mths ago
Get help
Reported - view
Re: Using a table selection in script
@Chris Mullett With relationship fields you need to know if it is a 1:N or N:1 (one to many or many to one). If you only see a popup field then you are on the many side of the relationship.…
Fred
Fred
9 mths ago
Get help
Reported - view
Re: Scripting and Functions
@Touch Tile I wouldn't recommend learning Swift to learn Ninox.
Ninox is a "low code" environment so it is easier to learn. All of the videos on YouTube are free so you can watch at your own pace.…
Fred
Fred
9 mths ago
Get help
Reported - view
Re: Using a table selection in script
@Chris Mullett A bit of background. Dynamic fields are built on records of a table. Each record is a choice. So with that in mind, I see that you want to use a reference field 'Select Chemistry' to…
Fred
Fred
9 mths ago
Get help
Reported - view
Re: Scripting and Functions
@Touch Tile Welcome to Ninox. I too had no previous coding experience (well a bit of Excel :) ). So if I can do it, you can too. I didn't quite understand the "low code" environment, but now I do.…
Fred
Fred
9 mths ago
1
Get help
Reported - view
Re: Scripting and Functions
No book that I am aware of. Here is the official Ninox docs and their YouTube. Nioxus, a Ninox partner, has a youtube page with some helpful videos. They have a subscription support service.…
Fred
Fred
9 mths ago
Get help
Reported - view
Re: How to auto-fill the relationship field choice?
@Nguyen Nhat Dong If you are satisfied with the answer please mark the post answered.
Fred
Fred
9 mths ago
Get help
Reported - view
Re: How to auto-fill the relationship field choice?
@Nguyen Nhat Dong In Ninox, you end commands with a “;”. So lines 2 & 4 need what?
Fred
Fred
9 mths ago
Get help
Reported - view
Re: How to auto-fill the relationship field choice?
@Nguyen Nhat Dong Now comes the fun part. Take the bit you have learned and try to do different things. You wrote: select 'CHUYEN HANG' where NGAY DI HANG > today() Will you have records where the…
Fred
Fred
9 mths ago
Get help
Reported - view
Re: How to auto-fill the relationship field choice?
@Nguyen Nhat Dong I didn’t do anything. I asked you a question. The code looks to the THU/CHI table and tries to find records where the NGAY field equals today.…
Fred
Fred
9 mths ago
Get help
Reported - view
Re: Need Validation Dates in a range
@Rafael i should find any records the startdate of the current record is between the any other startdate or enddate.
Fred
Fred
9 mths ago
Get help
Reported - view
Re: How to auto-fill the relationship field choice?
@Nguyen Nhat Dong take a look in the THU/CHI table. what is missing?
Fred
Fred
9 mths ago
Get help
Reported - view
Re: Need Validation Dates in a range
you mean something like: let t := this; let x : = select table1 where (t.startdate >= startdate and t.startdate <= enddate) or (t.enddate >= startdate and t.…
Fred
Fred
9 mths ago
Get help
Reported - view
1
31
32
33
34
35
136
Ninox-Website
Overview
Learn and share
Get help
Service status
Documentation
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
Templates
Use cases
Automation
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Usage overview
Process monitor
View all topics
Ninox is a "low code" environment so it is easier to learn. All of the videos on YouTube are free so you can watch at your own pace.…