Stuck on simple multiple if/else

Hello, I am trying to update a formula field 'Score' with values 1, 2, or 3 based on corresponding ratings from choice field 'Rating': if Rating = "Not much" then = "1"else if Rating = "Good" then =…

I’m not able to login to ninox

Is the only page I'm not able to access.

Problems with appointment fields

Does anyone have a solution to this problem: The time in the Appointment fields cant be changed (across all IOS devices - latest versions - reorganized - deleted/reinstalled) What happens is this:…

Dimensione maschera a scelta

Buongiorno, avrei bisogno di dimensionare a mia scelta una maschera, qualcuno potrebbe aituarmi? grazie

use a field from a related table in a pivot view

Ich have 3 Tables with a M:N relationship built as usual. In the "Joint-Table" I can create a pivot view with data from the other two tables. However, when I would like incoporate this pivot view in…

Function for attachment count

Is there a way to retrieve the number of attachments associated with a given record? Ultimately, I would like to display this information in a view and, possibly,…

Help needed with invoicing

Hi, it's been a while since l have posted but have come across a problem l don't know how to rectify. l have an Invoice table linked to a Customer table,…

To select acolum in the table view ?

Hi Does someone know the way to select a colum in the table view in the Ipad version ? Thanks.

How can I filter a column in a table by "empty" OR Criteria A OR Criteria B, but not Criteria C?

Looks like I can only have empty or a selection of categories, but no combination of it, as in e.g. Excel?

"Set-Date-script" - something goes wrong

Guys, I have i button to set a task to "Done" Deadline := null;Today := null;DoneDate := Today;Status := 3 The "DoneDate" field does not set the value to "Today" but returns null.…

Call a button from a trigger

Is it possible to call a button from a table or field trigger. I have 2 applications for this. 1) I have a very long 'Trigger after update' on a table that was easer to work out as a series of…

Where to write a global function

I have to make a calculation: Total = Qty * price -/- discount.I know i can make the Total a calculated field but you don't need to fill the price or discount.…

PDF image color different in browser export

Hi. I have notice that the pdf exports the image with a color significantly different when generated from the browser than when generated from the macOS app. See the images.…

Query multiple columns from API

Hi I want to query several columns from my API, this example only shows how to query one. How do I query more columns? https://api.ninox.com/v1/teams/mnPLY6DMsvq9wz4id/databases/pt53j1tburs8/query?…

urlOf

how do i get the url of a specific record in a specifi view urlOf(this,"all")

Disable create in link from field however allow select record

Disable create record in link from field however allow select record?

dimensione dialog

è possibile dimensione una maschera di dialogo?

cloud imprimir código de barras

Hola alguien sabe si se puede imprimir un campo de codigo de barras en el informe. Creo que en la version de escritorio mac con una tipografia de codigo de barras se puede pero en la version cloud no…

How to sum only some records from a subTable based on another field in the records

In the Main-record I have a SubTable and each SubTableRecord has got a number field each SubTableRecord also have a choice-field that can be set to "Yes" or "No" In my Main-record I would like to Sum…

Tenacious

date format

Pasar lineas de albarán a factura

Hola a todos, aunque soy nuevo por aqui ya me ha ayudado mucho esta comunidad. A ver os comentro. Ya tengo una tabla de clientes, otra de albaranes(cabecera de datos), otra facturas ,…

Rechnungsdatum in Leistungsdatum eintragen

Hallo, ich möchte beim erzeugen eines neuen Datensatzes einer Rechnung in das Feld LZ (Lieferzeitraum) das Datum der Rechnung "DATUM" eintragen lassen. Später kann man nach Bedarf das Datum ändern.…

Print document

Hi, Is it possible to print a document with the push of a button and this with a self-chosen name to a self-chosen folder. Tx Regards Michel

Random number formula

Hello, I would like to create a formula for a random invoice number upon invoice creation. I would like the formula to be 9 numbers long, starting with "R285" How do I do this?