Giovanni Zagarella

Formula returning specific values depending on multiple choice selection

Hi all, I have a multiple choice field with around 40 options and I would like to set up a formula that returns a certain text depending on the options selected.…

• Answered

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…