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
Service status
Documentation
Solutions
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
3632
576
5
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
Re: 3.8
v3.8.3 is now up. I hope it is more stable for everyone. Wish they could give cloud users a way to wait until x.x.5 till they iron out all the bugs.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: 3.8
another day, another version, v3.8.2, is up. In case anyone is interested here is the release notes, for what they are worth. I'm sadden to see this: We fixed a bunch of bugs for this release—but we…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Script for Inventory
@Didier Schoonjans said: So the theory would simply => Stock = Stock + Différence Ninox is correct that you can't use a circular reference. Stock is a formula.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Dynamic choice from Multiple choice field
@Marisol Echaide said: Say Customer A has registered two VAT regimes: Margin Scheme and Local VAT in a multiple choice field within the Customer table. Your multiple choice field is a regular…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Locking Records in multiple tables from one
This would be an easier way, if you wanted the child records to always be in sync with the parent. But if need the ability to micro manage the lock state of each child record then your current method…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Locking Records in multiple tables from one
It looks like the script UNLOCKS, but maybe you have it the other way around. Using your provided code, you can try something like: for i in (select PROJECTS)[LOCKED = true] do i.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Programming language for Ninox
here are some free videos.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Programming language for Ninox
check out this post.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Enter the content of another field inside a rich text field
@RoSoft_Steven Thanks for the tip of the raw() command to transfer Rich Text formatted text into html().
Fred
Fred
2 yrs ago
1
Get help
Reported - view
Re: Creating a new record in a linked table using code
@spinner. 7580 said: I wanted to pull out Route_ID to display the full route description in a formula field based on the choice in Route_X, that way I can confirm that I picked the correct route…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Cannot create more Forms!! - Cloud version
A Ninox hiccup? I was able to create a new view on the Cloud version.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Enter the content of another field inside a rich text field
There are smarter people who can answer this better, but there is an example of what you can do: let xFName := Volunteer.FName; let xLName := Volunteer.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Display multiple dynamic choice items separated by returns rather than commas in Print
Here is a quick and dirty method of taking into account "," in names: let CRTN := " "; let x := for loop1 in numbers(dMC) do let y := record(Cities,loop1).…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Display multiple dynamic choice items separated by returns rather than commas in Print
@tjdegrood Yes, I did not take that into account. If I come up with a programmatic way I'll let you know.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Display multiple dynamic choice items separated by returns rather than commas in Print
@tjdegrood When you get a chance, if you feel like you got what you needed please help others by marking the post "answered".
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Change lookup field based on the year
Sadly, I don’t think you can build a field name in a formula. This is because Ninox does not really track field names by the human readable names we give it.…
Fred
Fred
2 yrs ago
1
Get help
Reported - view
Re: Creating a new record in a linked table using code
@spinner. 7580 said: I can't find the 'this' function documented in the manual, what exactly does it do? Weird. 'this' tells Ninox to take the current record you are on and put it in a variable.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Sort a dMC field dynamic values
@Holly M When you get a chance please mark this post "answered".
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Elimination of decimal numbers
You can use the round() function inside of your formulas. So if need to use C in another formula you can do: round(C,2) * somethingElse
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Change the Choice Value or reorder again
I've never been able to figure it out.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: How to specify a default date?
@zenmom said: Then I selected 'date last frost' Try putting the code in the Trigger after update of another field or at the table level.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: How to specify a default date?
@zenmom said: I put your example in the "trigger after update" box in the screen where you define your field Which field's Trigger after update did put it in?
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Sort a dMC field dynamic values
What you are asking it to do is to sort by record Id, which is the default sort so you wouldn’t see any changes. What you can try is the order by command:…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Sort a dMC field dynamic values
It is possible. Please share your code so we can troubleshoot.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: I'm doing something wrong with this formula
@Rafael said: On Status there are 1,2,3,4,5 items and on Hitos only 1,2,3 items Then you can try something like this in the Trigger after update of Status: switch Status do case 2: Hitos := 1 case 3:…
Fred
Fred
2 yrs ago
Get help
Reported - view
1
84
85
86
87
88
146
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
Performance
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Usage overview
Process monitor
View all topics
