-
Mutually exclusive choices
Hello forum, I have an extremely basic question. Imagine a list where each item should be assigned one and only one value. In my experience this ought to be the use case for a "radio button",…
- Answered
-
Formula don't work but no errors
I have this Formula but don't work, the HITOS is a Multiple choice Dynamics with 5 Options. I Try with HITOS = number(5) but not work if FechaF5 <= DataDate and FechaF4 !…
- Answered
-
ID of a newly (Create 'table name')
How can I extract the ID of the new record created by: let i := (create 'table name');
- Answered
-
How to modify multiple if statements (I'm not sure if that's the right way to express it).
In the database below I have two key buttons, I will temporarily call the code in "Key1" "if1". Now I need to run the "if2" code after meeting the "if1" condition "avg(test) = 1",…
- Answered
-
No databases visible after updating to Ninox 3.11.3 on macOS
I recently updated Ninox through the App Store, and now my Database overview is empty. Even newly created Databases are missing. Is there anything I can do, or do I have to wait for a fix?…
- Answered
-
Indirectly link N:1 records
Hello ! I have a table named "Comptes", a table named "Activitiés" and a last one named "Bilans de vitalité". When I create a new record in the "Activités" table,…
- Answered
-
Formula colour
Hey everyone, here's a question: I have a choice field where I have set different colours for every value. I also have a formula field which is linked to another table.…
- Answered
-
Button that fills a table
Hi! I have a blank T table with the following fields: First. Text field Second. Numeric field I want to create a button (within the same table) that will create 10 records in table T by filling them…
- Answered
-
Current Storage Capacity
Hello and congratulations on this FANTASTIC, USER FRIENDLY database. I checked one of my records this morning and realise that it was missing its attachments.…
- Answered
-
Locale backup has no data
Hello, when I download a backup and click on import archive locally on my Mac Ninox Database App, the locale backup has no data. Everything else seems to work, but the tables are all empty.
- Answered
-
HTML View
I am trying to send out a view in an email. However when I try to use html the headers print on all of the records. Any help would be wonderful. thanks
- Answered
-
Multiply for formula fields
Hi The table has formula fields "Formula 1" and "Formula 2", which, for their part, take information from other tables. I need to multiply "Formula 1" by "Formula 2".…
- Answered
-
Show value of line items depending on the choice field selection
Hello everyone. I have created a formula field to show the current total of our Petty Cash which is in a subtable. This needs to exclude amounts which were transferred to/from a bank.…
- Answered
-
Weird issue with DB
Hi all - I'm still on v3.5.14 of the MacOS app. I'm waiting awhile before updating to 3.6. Can you duplicate the following issue? After opening the attached table, click on Invoices.…
- Answered
-
Ninox for Mac vs Ninox Cloud
Hi, Do I need to subscribe if I only want to use Ninox on my mac?
- Answered
-
Automatically link record from one table to open record in another table using a button
In Audits Plan I have the field 'Audit Code' and need to open on 'Non Conformity' field the same 'Audit Code' on the 'Non Conformity' table the 'Audio Code' is a N1.
- Answered
-
Is it possible to create a button that opens the corresponding table by inputting the table name?
Thank you everyone for your suggestions.
- Answered
-
hide rows
Hello everyone. I created a new tab and I would like to display only part of the information. So I applied a "formula", but unfortunately the lines corresponding to my filter are not erased.…
- Answered
-
How do I filter data in charts?
How can I set the chart view in the "inventory" table to only show "meat" and "bread"? I tried Filter but it only works when I enter one "food name", is there another way? Thank you for your reply.
- Answered
-
time(time field) problem
I'm in NY, EST. I have a time field "TF" that says: 2:30 PM so time field TF contains 2:30 PM if x := TF then I get x= 9:30 am if x := time(TF) then alert(x) from a button shows 4:30 AM ultimately,…
- Answered
-
Export .csv to excel not work
https://youtu.be/Eo6WUmG86fE The Scrip on formula is: let me := this; --- GENERAR COMBINACION FILTRO ---; let myCon := ""; myCon := myCon + if Alpha then "X" else "_" end; myCon :…
- Answered
-
the issue of extracting data from parent and child tables.
I have included my question in the ninox file. Thank you!
- Answered
-
NINEXT Error flags - false positive??
I have 7 like this which do not make any sense to me at all. If I follow the wrench I cannot find any issues which reflect this and to be honest the bread crumb does not make sense either.…
- Answered
-
Loop Syntax Correction
Hello. I am having a bit of trouble with this for-loop, a syntax error and would love an extra pair of eyes on this, I basically have a 'Hire Date' field,…
- Answered
-
Relationship between "Chice" and "Formula" fields
The table has two fields, a choice "Category" and a formula field "Discount" . Depending on the client category, a discount is assigned. Can someone, please, tell me the formula, for example,…
- Answered
Answer questions and share your knowledge