Giovanni Zagarella
-
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.…
-
Hiding a multiple choice field
Hello, I'd like to hide a Date field if a specific option "A" is selected in a multiple choice field. So if "A" is selected, or "A" and "B" are selected together (every scenario in which A is one of…
-
Help in setting up an accountability system
Hi all, We are trying tset up an internal "accountability system" for our Ninox, and I might use some technical help to figure out what's the best way to implement it.…
-
Logical syntax for multiple "if" choice
Hello everyone, I'm trying to set up a logical formula that checks for two conditions instead of one, but I'm not sure how to do it. Let me explain: Instead of writing "if X then Y else Z" I would…
-
Formula randomly displays date+hour instead of only date
Hello, I use a very simple formula that is meant to calculate the difference of days between two date fields. It works, however sometimes the value is stored as "xx days" and sometimes as xx days 1:…
-
Automatic currency conversion
Hello, I have a master table that includes financial information for each of my records. Every time I create a new record or update an existing one in my master table,…