Giovanni Zagarella
-
Formula to display an array of choices from subtable
Hi all, I have two tables (A and B) connected to each other through a one-to-many relationship. In table B, I have a single choice field (B) called Country.…
-
Problem with unique() function
Hi all, I'm having trouble making the unique() function work. I'm simply writing unique('Project Codes'.Currency) in my formula field. If the values selected are all the same (e.g.…
-
Avoiding duplication in a field
Dear all, I hope you're well. I have a field to which I assign a unique value for each record. If this field has XYZ as value, no other field in the database should also have XYZ.…
-
Print formular questions
Hello, I have two quick questions regarding the print function: - Is it possible to save different print layouts and access them somewhere on Ninox? - Is there a way to roll back to the "default"…
-
Date suddenly wrong
Dear all, One of our users is suddenly seeing all the dates logged in the database backdated of one day. For example we have a date of 31/12/2021, he sees 30/12/2021.…
-
Replicating a value in a different field via a button
Hi all, I have a master table and a subtable related to each other. Each record on the master record is connected to multiple records in the subtable. For example I have:…
-
Charts personalization
Good afternoon, I had two quick questions regarding charts: - Is it possible to order the bars in a bar chart from smallest to biggest amount/bar, or vice-versa?…
-
Automatic record creation
Good morning, I have two tables - Table1 and Table2. Table2 is a subtable of Table1. Every time Field1 (a formula field that shows a number from Table3) in Table1 is higher than 0,…
-
Formula not stored as number
Hi all, For some reason Ninox doesn't store the value of one of my formulas as a number, creating all sorts of issues when trying to display the values in a table view.…
-
Automated creation of a record in subtable
Hi all, I hope you're doing well. I have a master table and a subtable - each time I create a record in the master table, I want a record to be created in the subtable and connected to the main table…
-
Formula to select an exchange rate based on currency and date of payment
Hi everyone, New day, new Ninox puzzle :) I have a series of fields in a subtable recording past exchange rates for a series of currencies (we use InforEuro, so these are monthly exchange rates).…
-
Consistency check formula
Morning all, I'd like to ask once again for your help. I would like to have a field that checks if field A is equal to the sum of fields B+C, keeping a tolerance of one cent of difference.…