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: 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs ago
Get help
Reported - view
Re: How to auto-fill the relationship field choice?
@Nguyen Nhat Dong Which version of Ninox are you using? Cloud or app? If cloud which level? If you DB doesn't have any personal identifiable data then you can skip this step,…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: How to auto-fill the relationship field choice?
@Nguyen Nhat Dong Can you upload a copy of your DB with test data?
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: How to auto-fill the relationship field choice?
@Nguyen Nhat Dong Remember, I do not know anything about your DB, so I'm just guessing. 1) what is the table name that the Reference filed 'NGAY THU/CHI' points to? Put that table name after select.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Duplicate several records with changing one of the fild values
You could try something like this in a button: let findRecs := select tablename where fieldname = something; for loop1 in findRecs do let newRec := duplicate(loop1); newRec.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Delete all attachment from a subset of record
Take a look at this post about the code to delete paperclip attachments. I don't know if you can change things around and use a subtable to store attachments as it would be much easier to delete…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: How to auto-fill the relationship field choice?
If the table NGAY THU/CHI has a date field called Date then you can test it out in a button with: let selectNGAY := first(select 'NGAY THU/CHI' where Date = today()) 'NGAY THU/CHI' :…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: How to auto create new record every day?
@Nguyen Nhat Dong what is the name of the table and the name of the fields that you want set when a new record is created?
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Mac app upgrade to 3.11.8 failure !!
that would be great.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: How to auto create new record every day?
There isn't a way to run a script based on time. You can do the create() command when you open the DB, Trigger on open. You can add code that will check if a record for the day already exist and only…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Using a table selection in script
@Chris Mullett said: Basically I'm trying to bulk update records which I manually select and which are not necessarily selectable by query. May I recommend that you look into using a dynamic…
Attachment
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Using a table selection in script
Hi Chris - Most things are possible in Ninox. @Chris Mullett said: I'd like to be able to scroll through a set of records in a table and update values on each record.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Mac app upgrade to 3.11.8 failure !!
Looks like an email to support is necessary.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Update Multiple Records... of a Multiple Choice Field
@Mr. K. I was guessing Lettering was the multichoice field. Is it?
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Update Multiple Records... of a Multiple Choice Field
Interestingly this doesn't work on dynamic multi choice fields through the Bulk Edit. Looks like dynamic multi choice fields need to be updated by a button.
Fred
Fred
2 yrs ago
Get help
Reported - view
1
54
55
56
57
58
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