-
"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…
-
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?
-
Query - Vieuw
Hi, When I run the code below, which I received from you, this program runs in a loop. It doesn't stop. delete (select qry_Contractor); for a in select Contractor do for b in select Gebruiker do for…
-
Auto increment in subtable
Hi guys, once again I'm stuck :) I know how to auto increment values in a fild - but this is different. How can I auto increment a value in a "Child table" - ONLY regarding the actual records in the…
-
Dates before Christ - how to type
Are there practical ways to insert dates before Christ?If you enter negative numbers in dates, they will always be considered positive.For example, if you type 17 JAN -0012 in a date field,…
-
Is there a way to create a button so that when you click it, it deletes the information in a particular field?
I need a button so that after the information in a field has been viewed, the user clicks a button and the information in those fields are cleared, thus enabling them to enter new information.
-
Showing next months data
I have a view showing me last months invoices month('Date & Time') = month(today()) - 1 and year('Date & Time') = year(today()) and another for next month's month('Date & Time') = month(today()) + 1…
-
Query (View)
Hi, I have 3 tables and I want to make a view with several fields of the 3 tables. In Microsoft Access I make a query with this 3 tables and I select the fields that I need and there’s my new table…
-
Change Date/Time field to Date or Appointment
Importing data from another app. I have some dates which have imported as date & time but there is no time. Rather than have a field show 12 Dec 2021 00:…
-
Merry Christmas to all my Fellow Ninox Forum Users
Probably the first time I have posted something that isn’t a question.... However, I just want take the opportunity to thank all my fellow but very talented Ninox users/contributers out there that…
