-
Trying to "hide" records in main table
I am trying to "hide" records in my main table (Orders) by having them move to sub table (Received) when the field (Received by)= 1, 2, or 3. I am not sure how to write the code correctly to get it…
-
Merge 2 similar DB
Hi , From the beginning, I've had one DB on a private server and a similarly links structure and fields other DB on Ninox server. I've upgraded them simultaneously, but I may have forgot some,…
-
How I can prevent duplicate records being added?
Hi. I'm a new user on my first project and have set up a simple database. I need to find out how I can prevent duplicate records from being entered in a table.…
-
Mit JOIN eine Leerzeile in eine Listenspalte einfügen, falls kein Datensatz vorhanden ist?
Hallo zusammen, ich habe eine - hoffentlich - einfache Frage. Ich erstelle eine Print-Darstellung, die den Status der erteilen Aufträge und dazu erhaltenen Lieferungen zu einem Projekt auflistet.…
-
Query
Hi, I have 2 tables. Table 1 : Contractor : Nr Firm 001 IBM 002 Ninox ......... Table 2 : User : Id Nr Name 01 001 Glenn 02 001 Bruce 03 002 Tom ……… What I would like to obtain is a table…
-
How to count days
Hi guys, I'm struggeling a bit, trying to figure out how I can count the days in a contact history table (to be used in sales effort stats) I have a "contact-History" table in which there is a "date"…
-
Problem with printing in Windows and Android.
Hello everyone! There is a problem with printing in Windows and Android. Preview displays correctly, and when printed in pdf, everything breaks and the encoding is different.…
-
App login (no login with Google AC)
So I can login on the web(Ninox) with Google however, I cant see it on the App and I cannt login. Am I missing something? or does the App not support Google login?
-
Formula to search records with dates
Hi I'm looking for a formula to obtain as a result the records that have a date between a date that I can insert through a date field and another that I can insert into another date field.…
-
How to set a value for a switch elements
Hi, how can I set a switch value when I press a button?
-
how can i let someone else view my data table
how can i let someone else view my data table
-
Script: test for null or empty'
I want to say: if This Field is empty then do this else do that end How do I test for 'empty' I thought I'd seen reference to 'null' in the manual but I'm learning about the manual....
-
Nesting 'if'
Maybe if I knew which script launguage ninox uses I'd have better luck with Google. I think I want to nest an if Following on from my previous if 'Year Code'.…
-
Script: Test for 'if this is true and that is true, then..."
I have a working script which does what I wanted, some reference numbers need to be in the format AB-C-D and others ABCD. With and without hyphens depending on two tests. if 'Year Code'.…
-
Retrieving a deleted record made by mistake
Hi, Is it possible to retrieve a deleted record made by mistake? Thank you Andreas
-
http() function isn't working
Or it isn't working the way it used to. Can anyone confirm this?
-
Selected table reference makes changes in other fields. How to do this?
The following script works well where the 'II. Kedvezmény' is a Dynamic Choice Field that brings values from Kedvezmények Table, and selecting a value affect other fields.…
-
Spam spam spam span spam egg and chips
I have looked into the stars and forsee a Big Fuss if Someone doesn't do something about stopping all the spam here. Its too valuable a resourse to allow this polution and it makes Ninox look bad.
-
Simple Forumla Calc Issue
Hello, I've got a table that shows a list of times spent on a project. Inside each row, I have a time, rate and total field, where a calculations multiplies the rate and time to give a Labour Cost,…
-
Right-click menu
Is there any way to add custom "right click" menu on a single row of tables/views ?
-
Squinting is not enough for this list.
This is one of the most annying lists in Ninox. I needs to be larger, and it needs a filter search field.
-
Format date and time field
Dear Ninox users, I have a question for you: I need a data field that include the seconds for example 15/01/2022 18:00:34. Please help me!. Many thanks Massimiliano
-
Trouble with two table references - same settings, different results.
I have a a Table called 'Pages' and I want to use a code for the year and month on entries to that Table. I have created two further Tables, 'Years' and 'Months'.…
-
Button um vorhandenen Datensatz auszuwählen
Hallo liebes Forum, wenn ich über einen Button einen Vorhandenen Datensatz aus einer Verknüpfung auswählen möchte was müsste ich bei beim Anklicken reinschreiben ? Danke für eure Hilfe
-
Advice wanted for database design (modelling?)
I'm used to flat databases like Bento so I'm watching the 'Ninox and Nioxus Product Training Channel' on YouTube and seem to be learning that I could use a relational database.…