How to enable Javascript

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
- 5replies
- 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
- 3replies
- 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
- 1reply
- 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
- 2replies
- 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
- 1reply
- 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
- 2replies
- 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
- 6replies
- 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
- 1reply
- 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
- 4replies
- 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
- 2replies
- 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
- 2replies
- 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