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
Solutions
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
3603
566
5
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
Re: How to auto-fill the relationship field choice?
@Rafael Can you post what you have so far?
Fred
Fred
1 yr 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
1 yr 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
1 yr 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
1 yr 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
1 yr ago
Get help
Reported - view
Re: Export file excel in a subtable.
Here is what the docs say.
Fred
Fred
1 yr 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
1 yr 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
1 yr ago
Get help
Reported - view
Re: Error: Type not found: I when printing
Are you doing regular printing or dynamic?
Fred
Fred
1 yr 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
1 yr 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
1 yr 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
1 yr 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
1 yr 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
1 yr 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
1 yr 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
1 yr 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
1 yr 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
1 yr 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
1 yr 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
1 yr 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
1 yr 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
1 yr ago
Get help
Reported - view
Re: How to auto-fill the relationship field choice?
In the Shipping table, you can add a button with the following code: let selectNGAY := first(select 'THU/CHI' where NGAY = today()) 'NGAY THU/CHI' := selectNGAY This is link the first record in…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: How to auto create new record every day?
Try creating a button on the Home table with: create 'THU/CHI' Now if we add this to the Trigger on open for the DB then it will create a record everytime you open DB and that is not good.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: How to auto-fill the relationship field choice?
@Nguyen Nhat Dong How are you using Ninox? In a browser or in the app? if the app which version (MacOS, iOS, Android)? if in the browser, what level did you purchase?
Fred
Fred
1 yr ago
Get help
Reported - view
1
40
41
42
43
44
145
Ninox-Website
Overview
Learn and share
Get help
Service status
Documentation
Solutions
Ninox E-Invoice
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.…