-
Unable to Format a Formula number & Display the formula as a column
Hi, I'm having a weird problem (from my perspective) in using a Formula in Ninox, calculating the final average Grade for one Student, in one Class : - I'm unable to force a format on the formula :…
-
Complex query and where statement
I am building a KPI table and want to populate it with data from a lead manager I have created so I know what the sales funnel KPI's are for each month.…
-
Maintain a default ascending order?
How do I get my ninox table to maintain an ascending column order? It defaults to a different order whenever I leave the table and come back to it. Thanks
-
Query to update a specific value in a record on click/on trigger
How to I update a specific value of a field in a table. I have a table named 'OpenRequirements' which has a field named 'status' which is set by selecting a value from table 'Status',…
-
To mask a field in the form ?
Hi Can someone tell me if it is possible to mask a field in the form ? If it is, thanks to tell me how.
-
To change the style of the row ?
Hi Is it possible to change the style of some rows in the table (not in the form) ? Thanks
-
Calculate appointment -1 day
I am trying to do the following thing. If the first "PRENOTAZIONI HOTEL" date is before the "Inizio montaggio ufficiale" field, then in "ALLESTIMENTO UFFICIALE" (appointment field) it should enter…
-
Ignorare un campo vuoto o con valore 0 - Ignore an empty field or 0-value
Problema di oggi ;) Durante l'inserimento dei dati ho una formula che controlla se il valore è già presente nel DB, il problema è che ho più campi controllati e non tutti hanno un valore inserito,…
-
Two trigger from same field
I'm trying to make both triggers work but only the second one works. At the beginning I had this formula and it worked fine: Periodo := appointment('Check-In', 'Check-out') After I added this formula:…
-
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