-
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…
-
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
-
How do I input a csv table list into a multiple choice values table? I have a 100 choices and I don't want to type them all out.
I have a 100 choices and I don't want to type them all out.
-
How to copy a row or just few collummns from one table to another using a button
Where I can find any more detailed information about Ninox commands and language, I am struggling to finish my data base because I can't find enough info about how to use visual and text commands.…
-
4 tables - procedure
IDs, Status, Period, Consumption tables Status table related to IDs. Status of each IDs for date (3 columns IDs, Status, Date) Example: A1, 145, 1.1.2021 A1 167, 1.2.…
-
Ninox history
When I look at the history it only shows entries from today. How do I view the history for previous days/weeks?
-
Formula to display an array of choices from subtable
Hi all, I have two tables (A and B) connected to each other through a one-to-many relationship. In table B, I have a single choice field (B) called Country.…
Answer questions and share your knowledge