-
Feature request: scripting Record comments
Can we get access to record comments from script? Let comments = comments(this); And may even create comments
-
The formula field always displays the first field format of the "if statement" even though it was not true. is there a way to solve this. thanks.
if 'Sale Orders'.Client.Country = "Local" then 'Sale Item'.'S Price' else 'Sale Item'.'S Price$' end
-
"If Anweisung" aus mehreren Feldern möglich?
Liebes Forum, Ist es möglich If Anweisungen aus mehrern Feldern zu tätigen? Habe eine Tabelle "anderetabelle" und eine dazugehörige Untertabelle. In der Untertabelle habe ich ein Funktionsfeld mit…
-
Calendar iCloud sync problem
I have a problem with the calendar sync between iCloud and the Ninox calendar. In the Ninox app everything looks fine but in iCal all the items are double or quadruple… I did a test with a new…
-
Table only showing 6 rows
In my sales table I have a sub-table showing all the items and prices. I have created a print layout (invoice) which includes this sub-table, but for some reason it won't display more than 6 rows 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…
-
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.…
-
Photo field alignment
Hello, a photo field is always aligned on the left when laying out a view. I need to have more fields on its left or even a space to center it on the page. Is there a way to do it? Thank oyu very much
-
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…