Contact Sales to request a demo
Request demo
Product
Platforms
Templates
Security
Customer Reviews
Product Updates
Solutions
Success Stories
Partners
Partners
Become Our Partner
Pricing
Support
Help Center
Webinars
Hero Webinar
Manual
Forum
Tutorial Videos
Blog
Contact us
Search
How to enable Javascript
Sign Up
Log in
Support
Forum
Home
Search the community
Home
Learn & Share
Get help
Webinars
Knowledge Base
Latest Activity
Contact Us
Privacy
Home
Latest Posts
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
13 hrs ago
Get help
Reported - view
Re: Change the Choice Value or reorder again
I've never been able to figure it out.
Fred
Fred
16 hrs 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
yesterday
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
yesterday
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
yesterday
Get help
Reported - view
Re: Sort a dMC field dynamic values
It is possible. Please share your code so we can troubleshoot.
Fred
Fred
yesterday
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
yesterday
Get help
Reported - view
Re: How to specify a default date?
At the table level, there is a Trigger on new record. You can add the code: 'date last frost' := date(2023,05,01) Now every time you click on the new record button, Ninox will fill in the date.…
Fred
Fred
yesterday
Get help
Reported - view
Re: I'm doing something wrong with this formula
@Rafael ARe they simple choice fields? If so then what are the actual choice numbers for each choice in Status and Hitos?
Fred
Fred
yesterday
Get help
Reported - view
Re: Script for Inventory
@Didier Schoonjans said: Now I guess it is enough to replace the message [ alert("Please select a family") ] by a loop that displays all the articles? You can do that.…
Fred
Fred
yesterday
Get help
Reported - view
Re: I'm doing something wrong with this formula
You can’t filter a number() command. So try: if Status = 2 then Hours * 0.10 else if Status = 3 then Hours * 0.55 else if Status = 4 then Hours end end end
Fred
Fred
yesterday
Get help
Reported - view
Re: Display multiple dynamic choice items separated by returns rather than commas in Print
Here is what I have: let x := for loop1 in numbers(dMC) do record(Cities,loop1).Name end; replace(concat(x), ", ", " ") Lines 1 - 3, uses the for loop command to go through each selection in the dMC…
Fred
Fred
2 days ago
Get help
Reported - view
Re: Creating a new record in a linked table using code
@spinner. 7580 said: Attaching sample DB I've taken a look. I've added a dashboard (Data Entry), since, for me, it makes the most sense to have a data entry form that is separate from Routes.…
Attachment
Fred
Fred
2 days ago
Get help
Reported - view
Re: MAJOR problem (v3.7.14 Mac)
Wow that is NOT good. I just switched to a cloud account, so I won't have this possible issue. Just the other issue of corrupt data when deleting records in the root table of a dynamic multi choice…
Fred
Fred
2 days ago
Get help
Reported - view
Re: Script for Inventory
Take a look at the changes I made in the DB. I made a new button and put this for the onClick: let t := this; let xSel := record(Familles_Produit,number('Familles Produit')); if 'Familles Produit' !…
Fred
Fred
2 days ago
Get help
Reported - view
Re: Styling a portion of a formula
@Alan Cooke
Ninox does not like if statements with two different type of responses. The “then” was a text response and the “else” was html. You fixed it by making both html.
Fred
Fred
2 days ago
1
Learn & Share
Reported - view
Re: Ninox Date and Time Issues (continued)
@Jacques TUR as always, thanks for the info about a Ninox function that is not documented, or easy to find.
Fred
Fred
2 days ago
Get help
Reported - view
Re: Ninox Date and Time Issues (continued)
Is Time a time field? or a number field?
Fred
Fred
3 days ago
Get help
Reported - view
Re: Ninox Date and Time Issues (continued)
So you are trying to filter records equal to Jan 17, 2023 but before 12:00pm? what is the code behind your extractDate() function? When I troubleshoot a select filter I use another formula field and…
Fred
Fred
3 days ago
Get help
Reported - view
Re: Enter the content of another field inside a rich text field
A third option is to use the trigger after update at the table level. A fourth option is to use a formula field and html() command to combine text fields and use html to format individual parts.
Fred
Fred
3 days ago
Get help
Reported - view
Re: Issue with creating related record from script
The issue is with the variable thisProject. You have it set to "this". So of course it works in the Clients table, but when copied over to the Trips table it fails.…
Fred
Fred
4 days ago
Get help
Reported - view
Re: Issue with creating related record from script
@Holly M said: but the error is now showing on the ) That is unusual. If possible can you post the full code? I'm wondering how thisProject is set.
Fred
Fred
4 days ago
Get help
Reported - view
Re: Issue with creating related record from script
@Holly M said: for clarity the fully qualified name would be Trips.Client and Trips.Clients It doesn't matter what table we start in since you are in the Tasks table when you create a new record…
Fred
Fred
4 days ago
Get help
Reported - view
Re: Script for Inventory
1) How do you want Families Produit to be filtered by Type de selection? Families Produit is a dynamic multi choice (dMC) field pointing to Families_Produit table.…
Fred
Fred
4 days ago
Get help
Reported - view
Re: Issue with creating related record from script
In the table Tasks, what is the name of the reference field to Clients?
Fred
Fred
4 days ago
Get help
Reported - view
1
2
3
4
5
60
Next
Fred
Fred
San Francisco, USA
1,489
202
2
Joined: 06 Feb 2020
Follow
Home
Learn & Share
Get help
Webinars
View all topics
Tags