-
Sort dates chronologically
I have a date field in to which i am entering customer birth dates (day,month,year) I want to be able to sort these dates to show their birth day and month.…
-
Choosing between different Print layouts
How can I choose between different Print layouts? I know how to create them, but with my function (below) I can only choose the pre-chosen layout. let myFileName := Typ + "_" + 'Nr.' + ".…
-
Meaning of an error ?
Hi, Can someone explain me what does mean "Expected end : Select the line 2, column 6" Thanks
-
Linking a Table by a Field
Hi, I have two tables, one is Products and the other is attributes. There is a 1:N Product to many attributes relationship. I have created a table refence on the Product table to the attributes table.…
-
How can you import csv file into a sub-table?
My goal is to import an google sheet with different columns into a sub-table that I created on a boards in Ninox. How can I do it? I understand how to import in text field but not on sub-table that I…
-
Basic workings
I understand programming and have programmed in Visual Basic and Filemaker. If given an example or two I can usually figure things out. If I create a button that runs a script or a function like…
-
deleting
How do I delete multiple rows at one time?
-
Can you use Zapier to update a field in Nixox from a csv in dropbox?
Hi, I can export a csv to dropbox every hour. The file will contain the SKU (or Ninox ID if I need it) and a number. I want to pull this number into a Ninox field (overriting the existing value).…
-
Avg and sum in the same table
Hi I have a DB of my students. It has different items (with different weighs in the final mark) for the marks. I have a table with marks for each student but I can`t calculate the avg and then the…
-
Nominare automaticamente i Kanban Automatically appoint the Kanban
Good morning, I'd like the Kanbans to automatically take a name, I created a small formula if code = 1 then " 1 Thermooppie" and it works, but if I try to add and so forth I'm attached screen shots…
-
question on n:m relationships - using events template
Dear all, I am starting with ninox for mac and I am trying to figure out n:m relationships using the default template Events. I thought this template worked like this:…
-
Print button
I've created a print button but I would like it to print datas only from a certain period of time, which formula should I use ?
-
Error in formula
Hi I have an issue with a formula.When I write a query I have an alarm which says "Expectedend = select to the lire 2, column 6"Can someone help me ?Thanks
-
Dynamic color in calendar
I'm trying to set a formula that changes the color of an appointment on calendar. I have the field FASE DI with this formula: if 'Check-In' > Evento.Inizio thenstyled("SMONTAGGIO", "orange", "",…
-
Map integration in field
it is possible to set a trigger that inserts the same map that opens in full screen by pressing the icon, in the window at the top right??
-
To create a scrolling menu in the form ?
Hi Is there a way in create a scrollingmenu in the form ? Thanks
-
Calendar settings
I'm trying to apply some display settings to the calendar. I don't know why but for some reason the "options" button at the top does not open any screen.…
-
Calculating an age at a certain time
I am trying to calculate the ages of students when they start a programme. I had this in a ms sql database as (floor(datediff(day,[DATEOFBIRTH],[LEARNSTARTDATE])/(365.…
-
Hide ONLY IF A FIELD IS CHECKED from calendar
Is there a way to hide something from the calendar only if the field "Canceled"is checked? if 'Check-In' > Evento.Inizio thenstyled(Evento.Evento + "-" + 'Nr.…
-
To copy a record from a tab to another tab ?
Hi. Can someone tell me the way to copy a recordto another one from a tab to another tab ?(I mean the tabs that are in the sametable : ex record of tab 1 to put in tab 2) Thank you
-
Duplicate and open
Morning, everyone, I'm looking for the function to duplicate a record and open the newly created record Thank you for your help
-
Increase groups ?
Hi Is there a way to sort the ID ?I have displayed some rows in groups and I should like to sort this groups.I tried "increase" but that does not work.Thank you. Steve
-
Do functions support the use of comments?
Do functions support the use of commetns within the code? Something like /* or -- .. or anything ... ?? Might be helpful.
-
A field in the table wich is not in the form…
Hi I created a new field with "modify the fields " It appears in the table but not in the form… Could anyone give me an explanation to this ? Thank you.
-
Cannot undo an accidentally deleted print layout.
There's a bug in the Mac version where newly created table and print layout tabs jump around a bit. You know what I mean if you have seen this. OK, so I created a new print layout and then I decided…