-
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…
-
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…
-
Help with sorting on 4 columns
Using the method suggested elsewhere in the forum I created a sorting number/code to sort 4 columns. Its of the form Value1"."Value2"."Value3"."Value4. This results in a field that gives me a result…
-
If a text field has > 30 '#' then show alert
Wondering if there's a formula that will check a text field for the number of hashtags (#) and if there's more than 30, allow to pop up an alert or have field become visible alerting to the fact?
-
API not returning all fields
Using REST API I see below. Given this: {'id': 'G', 'name': 'Inventory_avail', 'fields': [{'id': 'A', 'name': 'Adj_code', 'type': 'number'}, {'id': 'B', 'name': 'Location', 'type': 'number'}, {'id':…
-
Bugs waring current version 3.2.6 or 3.2.7 MacOS application
Anyone using the new current version 3.2.6 or 3.2.7 MacOS application ?I would highly recommend to use instead the current Browser Cloud version as several bugs are actually leading to hazardous…
-
Autonumber a filtered list
Hello!I got an table named Citas. I need to select a date range from it, sort the resulting list by date, and then number it starting from some number. I used to use the solution provided here on the…