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?
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
9 mths 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
9 mths 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
9 mths 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
9 mths 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
9 mths 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
9 mths 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
9 mths 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
9 mths 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
9 mths 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
9 mths ago
Get help
Reported - view
Re: Mac app upgrade to 3.11.8 failure !!
that would be great.
Fred
Fred
9 mths 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
9 mths 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 multiple…
Attachment
Fred
Fred
9 mths 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
9 mths ago
Get help
Reported - view
Re: Mac app upgrade to 3.11.8 failure !!
Looks like an email to support is necessary.
Fred
Fred
9 mths 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
9 mths 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
9 mths ago
Get help
Reported - view
Re: Update Multiple Records... of a Multiple Choice Field
I didn't know you wanted a Bulk Edit code. It would look very similar to the button code I posted. You can choose Assign calculated value and put this for the code: let selectedArray :…
Fred
Fred
9 mths ago
Get help
Reported - view
Re: How to select different options in bulk?
If you only need to do this once then you can use the Bulk Edit and put this code in the Assigned calculated value part next to Star. if 'old code' < 100 then 1 else 2 end If you need it in a button…
Fred
Fred
10 mths ago
Get help
Reported - view
Re: Infinite loop
@SimonS I'm sure Support will know of a way to deal with this issue.
Fred
Fred
10 mths ago
Get help
Reported - view
Re: Infinite loop
I have the file location for the preference file on MacOS. You can email Ninox support and ask about how to delete the preference file on iOS. Maybe it is just deleting the app and reinstalling,…
Fred
Fred
10 mths ago
1
Get help
Reported - view
Re: Charging for use of application.
What are the options? An annual/monthly site wide license? An annual/monthly per user license? What are you going to do with the data at the end of the project? You have to pay for:…
Fred
Fred
10 mths ago
Learn and share
Reported - view
Re: Minimum cost (coding help)
@James said: Can triggers change a field which already has a formula at work? @James said: Is it possible to incorporate a trigger when a product is selected to put a minimum value of 60 into…
Fred
Fred
10 mths ago
Get help
Reported - view
Re: Minimum cost (coding help)
Just to verify, are you saying if Product.Type = 1 then the else of: 'Sq.m' * 'Fitting Rate' * 1.2 doesn't run? or if Product.Type = 6 and Room = 1 then: ceil((('Sq.m' * 'Fitting Rate' + 40) * 1.…
Fred
Fred
10 mths ago
Get help
Reported - view
Re: Bulk edit yes/no
@Rafael are you asking a question?
Fred
Fred
10 mths ago
Get help
Reported - view
1
32
33
34
35
36
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
