-
issue trying to get a table view to work in a non related table
'Job Dockets and 'Quotes' the many side to 'Customers' (the 1 side) in related tables However 'Job Dockets' and 'Quotes' are not directly related to each other However- I want to open a table view of…
-
Changing Owner's e-mail address
Can I change my owner's e-mail? I started working with NINOX with a personal e-mail, but after upgrading I need this address to be the professional one. Any suggestion? Thanks
-
Information is not displayed windows computer
There is a problem with displaying information on the windows computer. The table is displayed, but there is no information in it. Did someone have such a problem?…
-
Help with SELECT query needed!
Hello, guys!this task is too much for me, and i ask your help please!! I got 3 tables that are joined as 1:N as shown. Patients Visits Treatments As you can see, every patient can have various visits,…
-
Image format
What image format(s) are compatible with Ninox? I'm sure I read somewhere that Ninox can only work with jpegs. While I think it's pretty deplorable that a modern database can only handle a single…
-
Which Table
Is there any way to detect which Table is selected in the left hand column? There is the 'table()' function, but that's not actually the same thing. If you are e.g.…
-
How do you extract data from a text field? Regular expressions appear to be a mess in Ninox...
How do you extract data from a text field? Regular expressions appear to be a mess in Ninox... Specifically, I need to extract the text contained in the red box in the image below: Thanks, Marvin
-
Duration( Appointment ) = End( Appointment ) – Start( Appointment ) result in hours only ( hh:mm ) not days (dd:hh)
Hi there, i am using " Duration( Appointment ) = End( Appointment ) – Start( Appointment )" formula, and the result is displayed in days and hours. Isn`t there an option so i can display the result…
-
How do you multiple or divide two formulas in a formula?
How do you multiple or divide two formulas field in a formula? I keep getting error saying Invalid operator: boolean / number. Thanks for the help.
-
Whi does while loop not work
Hi, I have a simple loop but get always an void and no result in x let vnaam := ["a", "B", "C"];let x := "";for lst in vnaam do let x := x + item(vnaam, lst)+ ", "; voidend;…
-
Datensatznummerierung ändern
Ich habe ein Tabelle bzw. Datenbank von 36 Einträgen. Diesen Einträgen wird automatisch eine Nummer zugewiesen. Wird ein Eintrag gelöscht fehlt die Nummer.…
-
How to trigger a change in date?
Hello I posted a similar a few days ago that was unanswered so i'm posting a simplified version of it. I am trying to figure out the code to trigger a change in date by one year.…
-
Date Field Issue - 1 Team member's changes all show up as minus 1 day to the rest of the team
My team has 1 team member who is in a different timezone. We are in PST she is in CST (2 hours difference). If she changes a date in a date field the rest of the team sees it as the day before.…
-
Why is the date wrong?
I have a customer form and whenever the contact opts in/out out or leaves the company - It writes an entry into an 'GDPR audit' table However I have an issue with the date- for example - Both my mac…
-
How do I find the storage address of an image / copy image outside of Ninox ?
I have a “Photo” image field and I would like to be able to share it outside Ninox, either by exporting it or via API REST. When I do that, I just have the name of the image: “G1812/Jacques 3.jpeg ”.…
-
Dynamic choice field - showing Id instead of description in print view
Can anyone help please, this is driving me mad. I have a table called 'Inspection Report', and within this is a dynamic single choice field pulling from another table called 'Mechanical Services'.…
-
Duplicate Layout Elements Needed
Wow, wouldn't the ability to copy/paste, or duplicate layout elements be nice.
-
Search for tables with part of their name or with certain conditions
I have a mac database and I will need to create from a button a separate table for each customer in my database (the list of customers is another table).…
-
Field after update triggers.
Is it possible, in a field after update trigger, to view the previous value and the updated value? If so, would it be possible to give me a bit of sample code.…
-
Trigger after update previous value.
I created my own audit trail, where when a field is modified, another record is created and linked to that table that records the modification. One example is: (and this action is recorded in a field,…
-
Why Im getting endless loop here?
let Srch := 'Search';let Find := false;let Counter := 1;while Find = false do let Slct := (select Company where Id = Counter).Employees; if Slct = Srch then'WD TXT' := "Found it";…
-
Combo box only showing first 100 fields from the source table
I am using the trial version and not sure whether that is the problem but the drop down combo box which has over 300 fields only shows the first 100.
-
How to limit user to fill the fields in the form, but not see the list of records in that table
Hello! I searched for the solution, but cant find it. I have a tablet that i give to a client so he can fill the form in the table Clients. But i dont want him to be able to see other records in that…
-
Print limit
I have a data base invoice set up, where there is a subtable of linked line items (products and prices) plus a totaliser function summing all lines to give a total price.…
-
Table function
By which I mean a function that can be called from any field/column in that Table. I have a function to update a couple of fields based on the values of 2 other fields and really need to call that…