Select records through Dynamic Multiple Choice Field

Hello, I've been looking for a solution for a couple of days but I can't find it even if it's a simple thing. I have a TabCategories table. I have another table, TabCustomers, where there are,…

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:…

• 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.…

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…

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 €.…

• 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…

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?…

• Answered

Join Files functions

Hi! Why is this function incorrect? join([files(this)]," - ") Thank you!

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 :…

• Answered

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…

• 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?…

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,…

• Answered

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:…

• Answered

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!

• Answered