Rico
-
Would someone please tell me what i“m doing wrong here?
I“m using this formula: let Open := select Tracker where this(Symbol) = Symbol and this(Expires) = Expires.Total; Total + Open First problem is that i get this message: ”End expected:…
-
Locking' fields
I'm aware you can prevent fields from being modified by putting [field] = null in the Writeable if area. But i don't know how to do this with a delay, so that you can modify the field for, say,…
-
Two questions: All View and Imports
I'm trying to import data into a new database from an old one. I first tried to Export data from the old database, but this only seems to export the view you're currently on.…
-
Results in form not showing in table
I have some results i can see in a certain field of my form. However when i look in the view of the table, no values appear. The results i can see in my form are from a formula field.…
-
Circular Reference
I had some formulas on a few fields that worked fine. When i tried to introduce some qualifying statement, they suddenly fell apart, giving me "Circular reference" errors.…
-
Copying tables
Ninox is great when you want to copy an entire database, but, as far as i know, not so great when you want to copy and individual table to another db. I have 3 different databases:…
-
Absolute
The Ninox manual says, "absolute( x ) calculates the absolute amount of x, that is, x without a sign. Example: absolute( -10 ) = absolute( 10 ) = 10." I'm trying to use "absolute" in a formula and…
-
Blank row prevention?
I've prevented write on some of my tables, as their content is unlikely to change in the near future, and if it does, i can disable write prevention and add the new records.…
-
Posible bug?
I'm new, so i may be missing something, but i was pulling my hair out today trying to figure out why formulas that used "false" didn't produce consistent results.…
-
Mixed number/date formula
I have a formula that doesn't work, i suspect because it refers to both number and date fields and isn't expressed the right way. It gives results in a time format, always 0:00.…