-
Applying filters on a lookup table by choosen field
Hi! I have a problem applying filters on a lookup table. I have a customer table with a multiple-select Services field that allows me to understand which services customers have subscribed to.…
-
Table - trigger after update being ignored
My table trigger after update is being ignored? Anyone elase having this issue (web version) . script is simple enough and no errors if FirstName = " " and LastName = " " and GDPR = 3 then GDPR :…
-
help !!!
help : na het inbrengen van één nieuw record is mijn hele database verdwenen, behalve dat nieuwe record. ik probeer via mijn Time Machine en/of iCloud de laatste versie terug te zetten,…
-
Show all records in another record that are related by an ID
I have a table of persons. Each person has a familyID. Persons in the same family get the same ID. When I open I record I'd like to see all members of their family listed.…
-
Filter based on multiple columns
Good day, Is it possible to filter a view based on different columns, e.g. we have columns 'Status', 'Country', 'Name', so I want to get the filtered table when (Status='Open' OR 'Closed' ) OR…
-
Formula somma ricambi di una installazione
I need to see the sum of the cost of the spare parts used for the new installation. I do not find the formula that relates the spare parts inserted for installation and therefore gives me the sum of…
-
How to hide a relational field in a view
I have a field that is a table reference to itself. This creates two fields. A 1:N and a N:1. I don't want the N:1 displaying on my form. How can I hide it?
-
Aligning Line Item descriptions
Hello everyone. I am creating a Print Form for our invoices. When adding line items, the description is always centered. How can I have the description left aligned> The way it is now it's not…
-
Bypass camera to upload images to Image field on iOS
When I try to upload an image file to an image field in an entry on Ninox on iOS, I access the camera. I can't find where to circumvent the camera and upload the file as I can on the Mac or web…
-
Export/import only records
Hi guys, is there a way to let users export and import only records from other Ninox files? Here's why: I've created a little tool with Ninox that I give users for free (it helps teachers giving exam…
-
Tab navigation by script ?
I would like to know if it is possible to open a for in a defined tab ? openTable("MyTable,"Myform").....go to "MyTab" ??? Thank you Marc
-
User activity report
Hi, I need to see what a particular user has been doing on the database and the times that she was logged on etc. Is there a way to generate a report on this? I'm not very technical. Thanks. Carole
-
How to turn 5x reference columns in a CSV into a single reference column containing all 5?
I'm trying to import from .CSVs where the fields I intend to link look like this, with added notes to show where I want the links to go. Genres GenreID (PK) GenreName Movies MovieID (PK) MovieName…
-
Conditional display in calendar
How can I do to view events in the calendar only with certain conditions? I have a table with records including a data filed and a status field (multiple choice).…
-
Please help with selecting last 6 records using internal id
It is not returning anything in the field
-
Filter columns
Hello; Is it possible to filter a columns and show only record beginning by "3". (I have a liste 3A1,3A2,....4A1, ...,5A3, ....). I just want to show 3A1, 3A2 ..... Thanks for your Help
-
Please help with selecting last 6 records using internal id
It is not returning anything in the field
-
Linking Tables
Hi, I am moving over to Ninox from Access so that I can hopefully ditch windows all together, but I am having trouble linking my table data. I have multiple tables (approx 5) that I have imported,…
-
rechnungsnummer
rechnungsnummer
-
Please help with very simple select statement
what is the formula looking for expected end
-
Problem Dynamic choice
I have some code for d in select Transport where Oprindelse = 1 and 'Mål' = 2 do e := e + 1; k := d.Km; tid := d.'Rejsetid i minutter'; void
-
Wie werde ich das Welcome Popup los?
Seltsam, ich hatte meine Anfrage schon gestern gepostet, jetzt schein sie gelöscht zu sein. Warum? Also nochmal. Bei jedem Aufruf der app.ninox.com erscheint das "Welcome" Popup,…
-
PDF naming using print button
Hi everyone. I have a print button for e.g. Purchase Orders. When I click, it downloads the current PO as a PDF. However, the name is "Purchase Orders1.pdf".…
-
Find duplicates
How could I find duplicates in a table, querying a certain field (such as customer's name)?
Answer questions and share your knowledge