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
@RoSoft_Steven Unfortunately the round function doesn't work. The number behind the field always contains all decimals. see attached screenshot.
Attachment
Web Name
Web_Namer
1 mth ago
Get help
Reported - view
Re: Insert multiple elements into case of switch
thanks @Fabio and @RoSoft_Steven it works with round brackets ()
Web Name
Web_Namer
1 mth ago
Get help
Reported - view
Insert multiple elements into case of switch
Hi! I would like to fit more items into a switch case but I can't. This works: switch 'Progress Bill' do case 1: 'End data' := null case 2: 'Total Price' := 0 case 3: 'End data' := null default:…
Web Name
Web_Namer
1 mth ago
5
replies
56
Get help
Answered
Answered
Elimination of decimal numbers
Hi! How can I remove decimal numbers from a number? I have a Number field which is set to Euro currency with two decimals. But during the calculations what is behind it is considered, i.e.…
Web Name
Web_Namer
1 mth ago
3
replies
45
Get help
Re: Zero negative result in Formula
I see what’s going on. In practice, the Total Invoice is a number calculated and rounded only to display. So Total Invoice appears 100.00 but actually it is 99.99685584.…
Web Name
Web_Namer
2 mths ago
1
Get help
Reported - view
Round function
Hi! In the Ninox Manual in the Round function section I read: The function only rounds visually for the display of the respective value. Internally, the number in question is retained with all…
Web Name
Web_Namer
updated
2 mths ago
25
Get help
Zero negative result in Formula
Hi! I have two fields: Total Invoice Amount Paid I have a function that calculates the difference Total Invoice - Amount Paid If the result is 0 the formula gives me a result -0.00 €.…
Web Name
Web_Namer
2 mths ago
1
reply
26
Get help
Answered
Answered
Alert on a deleted record
Hi! I have an alert placed via a trigger after a tab fades. This alert allows me to remind myself that an important field has not been filled in. But if I delete the record without the field being…
Web Name
Web_Namer
2 mths ago
28
Get help
Re: Returning files that have a certain name
@buy Perfect! Thanks a lot!!!
Web Name
Web_Namer
2 mths ago
Get help
Reported - view
Returning files that have a certain name
Hi! I have files attached to a record. concat(files(this)) returns all attached file names. I’m looking for a function that only returns files that start with the string "ABC" Can you help me, please?…
Web Name
Web_Namer
2 mths ago
2
replies
23
Get help
Answered
Answered
Join Files functions
Hi! Why is this function incorrect? join([files(this)]," - ") Thank you!
Web Name
Web_Namer
2 mths ago
1
reply
31
Get help
Re: Select a field in a record in a linked table on Trigger new data set
Thank you for the comprehensive answer @Fred
Web Name
Web_Namer
2 mths ago
Get help
Reported - view
Select a field in a record in a linked table on Trigger new data set
Hi! I have 2 linked tables: TAB-A and TAB-B In TAB-B I have a number field named "nr" In TAB-A I have a number field called "tax" In TAB-A I have this formula in Trigger in new data set: let dtsel :…
Web Name
Web_Namer
2 mths ago
2
replies
38
Get help
Answered
Answered
Re: Select an element of choice dynamic in formula
@Fred @RoSoft_Steven Thank you for your interest! I would like to take the data from the TabB. And the record 4 corresponds to 2025. But the thing that leaves me puzzled is that the codes that I…
Web Name
Web_Namer
3 mths ago
Get help
Reported - view
Re: After deleting a record the app hangs
I found the problem but I don’t know how to fix it. In practice I inserted a trigger after the fading of a Tab in a record that defines a field of the record itself.…
Web Name
Web_Namer
3 mths ago
Get help
Reported - view
Re: Go to a specific record
Thank you both for answering. @Rafael I used your code and it works by adding closeAllRecords();, before openRecord(i). let s := Week; let i := last(select Progress_Project where Week like s);…
Attachment
Web Name
Web_Namer
3 mths ago
Get help
Reported - view
Select an element of choice dynamic in formula
In table TabA I have field 'Year' (field choice dynamic) which takes from table TabB the following data (field number): 2022 2023 2024 2025 2026 2027 2028 2029 In the taba table I have a button that…
Web Name
Web_Namer
3 mths ago
6
replies
69
Get help
Answered
Answered
After deleting a record the app hangs
Hi! I can't provide much information this time. After deleting a record the app hangs I can't understand why this happens. Could there be a particular reason?…
Web Name
Web_Namer
3 mths ago
1
reply
34
Get help
Go to a specific record
Hi! I have 4 tables: TAB1 with the respective sub-table TAB4 TAB2 with the respective sub-table TAB3 Through the links I start from the N record in TAB1,…
Web Name
Web_Namer
3 mths ago
4
replies
88
Get help
Answered
Answered
Re: Create records after checks on three fields
@Fred You gave me a great help! Thank you very much! I studied it and now I’m apply it!
Web Name
Web_Namer
3 mths ago
Get help
Reported - view
Create records after checks on three fields
Hi! I have three tables Tab2 is a fixed table with the following fields: Text Tab2: text field Choice1 - 2: choice field between two options Colour: dynamic choice field Name:…
Web Name
Web_Namer
3 mths ago
2
replies
39
Get help
Answered
Answered
Re: field not found - Error
Thanks a lot @Fred
Web Name
Web_Namer
3 mths ago
Get help
Reported - view
field not found - Error
Hi! where is the error? let a := Testo if a = null then let b := "zero" else let b := "molti" end; alert(b) Field not found in line 7 Thanks!
Web Name
Web_Namer
3 mths ago
2
replies
22
Get help
Answered
Answered
Re: Select all choice in a multiple choice (dynamic)
@Web Name said: This is the code I entered: let allTable := (select 'Natura Giuridica'); if 'Seleziona la natura giuridica aziendale' then 'Natura Giuridica Aziende' :…
Web Name
Web_Namer
3 mths ago
Get help
Reported - view
Re: Select all choice in a multiple choice (dynamic)
@Fred said: Are you asking to make the trigger affect ALL records in the table? No. Thanks!
Web Name
Web_Namer
3 mths ago
Get help
Reported - view
1
2
Next
Web Name
Web_Namer
49
1
0
Joined: 11 Apr 2019
Follow
Home
Learn & Share
Get help
Webinars
View all topics
Tags