-
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…
-
Formula based on date
I am trying to RTFM... I want to calculate a value based on a date. If the date is before 2017 subtract 20 from Field, or if the date is between 01-07-2018 and 31-12-2019 subtract 10 from Field,…
-
How to jump to a specific tab in a tables record
Is there a way to jump to a tab? openRecord(recordId, tab) or just tab(name) Here is my application I would like to use a Button I'll call "Details" to update values for a filter and then jump to a…
-
Fill down data in table view
I have done this but now I can't! I have a column of empty data. I was able to entre a value (text in a text field) directly into the table view. Then I could select the field and drag down to fill…
-
How to see all items over certain value when another field is a 'yes'
How would you do this?! I have a list of items some of which I want to insure. I have a 'yes/no' field where 'yes' means add to the insurance. But I only want items valued more that € 500 to be on…
-
How to style the dialog “onclick” button?
I have created a button with a “onClick” dialog, waiting for the user's response: let check := dialog("Atención", "¿Confirma la eliminación de la transacción?", ["Si", "No"]);…
-
Prevent Duplicate record import
Is there a way to prevent a duplicate record from being imported via CSV file. There is one field that should always be unique so if this field matches an existing record I do not want to import that…
-
Ninox account - needed for individual user Mac version?
I've bought the Mac version of Ninox and it will be just me using it. I'm using iCloud sync and see that working with my iPad. All Good! But I see the Ninox app want s me to "login and create a team"…
-
Mac users! What does the macOS version of Ninox look and feel like?
I can pnly see full screen screenshots. Does the macOS version have menus or is it an Electron / web interface pseudo app?
-
How do I increase the depth of a row in subtable that is showing on a form?
I have a form called Vehicles with two subforms attached to it. One is called Inspections and the other is called Reinspections. The users of the database are using it on an android tablet and find…
-
How do I transfer my Ninox databases to another computer?
I've looked through the forums, but didn't see anything that exactly matched my situation. I'm using Ninox as a local application. That's been working fine for me.…
-
how to cancel
how do you cancel
