-
getting relationships right
working on a crop planning database and want to set up right. trying to insert an image, but can't get it to work (tried .jpg, .png, .pdf!???) Anyhow, here are a few of my tables crop infoname of…
-
getting relationships right
working on a crop planning database and want to set up right. trying to insert an image, but can't get it to work (tried .jpg, .png, .pdf!???) Anyhow, here are a few of my tables crop infoname of…
-
Select from two tables
Hey there , I'm new to the Ninox and i'm having realy hard time doing one simple select. I have 2 tables Books and Legacy Books . I need to select field from Legacy Books named "Titre" where id is…
-
Ambiguous Field
I am trying to edit my fields but won't let me save anymore during 'Ambiguous Field Names'. I saw in this forum that fields can't have the same name but my databases have been identicial since I…
-
Data issue - loop failure
I have a table with 11000 + records and I am trying to identify patterns but the the loop doesnt work through the table. The body works fine and sets the choice etc.…
-
How to find your own posts ?
Hi Is there a way to find your own posts in the search field of the forum ? Thanks
-
Neuen Datensatz aus einer Untertabelle in einer anderen Untertabelle erstellen
Hallo, ich möchte aus einer Untertabelle in einer anderen Untertabelle der gleichen Haupttabelle einen neuen Datensatz erzeugen: let my := this;let myNew := (create Aktiendividenden);myNew.…
-
Fill time box automatically
Hi, I would like that a "time field" of my record is automatically filled with the time in which I put a a draw on the "signature filed" of my same record...How can I do it?
-
Alert Function
Hi, I was wondering if Ninox has a function where by a team member can alert another to let them know a new piece of information has been added. Would this have to be done through email ?
-
Issue with a formula…
Hi I found this formula in the forum to remove duplicates : for i in select Table_Name.Email_field do while cnt(select Table_Name where Email_field = text(i))!…
-
Is there a way to create a sub category
For example, I have a table with a category field. One of the categories is Sports and I would like to have a sub-category field with options like Basketball, Football, Baseball, etc, Is that doable?…
-
How to duplicate a column ?
Hi, I have to confront two columns that are far apart in a table. It would be easier to get them side by side. In Excel there is a handy way : one can block a column and drag all the other columns…
-
Images not displaying in html() function - Ninox ver 3.2.7
I didn't update to the latest version because of the complaints, but then I started seeing positive comments about the latest version. I downloaded version 3.2.…
-
Hiding choice fields
I need to hide some choice fields where salespeople have left. I obviously don't want to delete the information as it is still relevant and may be needed in the future,…
-
Help required with Display only function.
How do you get the "Dipslay Field only if " to do more than one function. I put into the field- 'Yes Normal Width';Rounded and it is only performing the first function. Any suggestions appreciated.…
-
Don’t display 0€ ?
hello, is there a solution to not display a field if it is equal to 0 €? thank you
-
Filtern bei Diagrammen
Hallo, ich habe folgenden Filter bei meinem Diagrammen, select 'Umsatz nach Ländern' where 'Umsatz 2020' >= (select 'Statistik - KPI').'Umsatz ab' jetzt möchte ich noch einschänken,…
-
Dates issue Ninox app vs browser
Hello, I don't understand why dates (birthdates) in a person file I have imported are displayed correctly in Ninox mac app and wrongly displayed (minus one day) in browser.…
-
loop failure
I have a data quality issue and built a simple block of code to set some choice and idx values. The code works fine on a current selected record. However enclose it in a for or while loop and it…
-
just updated my mac to catalina & can no longer use panorama. how do i import panorama files saved as text files & can i use ninox files while offline
just updated my mac to catalina & can no longer use panorama. how do i import panorama files saved as text files & can i use ninox files while offline
-
Duplicate a record don't increment a calculated file number
Hi, I've a "Trigger on Create" with a formula to increment a number in a numeric field (I want to avoid the use of table ID). The trigger works fine if i click in a new record button,…
-
Calculating a time duration over midnight
I am new to Ninox. Is there a simpler way to calculate a time duration over midnight? When the time interval does not cross midnight, I could simply use the formula Stop - Start So if Start = 7:…
-
Bulk Import of Images into Ninox
Hi, I am trying to get about 4000 jpegs into Ninox. They will be added in Image fields but as I understand it, the first step is to add them as attachments.…
-
Blank option issue
Hello, I hope someone can help me. I'm working on a database for a breeder. I'm new to Ninox. There's one thing I can't figure out how to fix. I was hoping to include a screenshot but the image…
-
Newbie question / Formula based on filtered records
Hello, I'm new to this and don't know code. I want to be able to query out a set of records based on date (eg. payments to a specific vendor within a particular year) and then calculate the total…
Answer questions and share your knowledge