-
Need to Match show rows from a table if email field matches
Hello and good day! I have a table called "Events" where I record emails from or to different Contacts. I have a table called "Contacts" and I'm adding a view to this table where I want to show…
-
No duplicate absent…
Hi, I created a formula to display duplicates and original in the family field of a database: let myV := Famille; if cnt(select 'Oiseaux famille genres espéces' where Famille = myV) > 1 then…
-
How can I add a linefeed to a text field?
I have been attempting to combine several notes fields when importing data and I am unable to find a way to insert them into the text field as multiple lines.…
-
What happens in "Crash"
I am running a script from a button. After a minute screen goes white; then a rotating circle appears briefly and then Ninox is back at the "My Databases" screen.…
-
Struggling to get Display Field Only If to work with null values
I have a gross margin calculation comparing my business' price to a competitors. When a competitor doesn't offer a product, the result for the calculation is -Infinity.…
-
How to import local database from external HDD?
My Mac failed, but the hard drive is OK, so I've got it in a USB HDD dock. How can I best import my local databases from that drive into my new Mac? I am using Mac Desktop Ninox, not Ninox Cloud.…
-
Commenting icon
In the browser based app, next to the attachment icon, there are 2 other icons - commenting and changes log. Were these left out of the iOS app? The commenting one is especially important to my use…
-
How can I duplicate a table?
I Would like to duplicate a table. Is there any easier way to do this without having to export and import? Also, if that is the only way it can be done...…
-
Button to openTable but choose just some records?
Is there a way of usuing the openTable command but specifyijg just some records? so openTable("table","view"...select reocrds that...)
-
Showing dialog in trigger after update-event
I would like to show a dialog after updating a field. So I have put this code as 'Trigger after update' of a choice field. The dialog doesn't show. When I add the code to a button, it works perfectly.…
-
data export to excel 05-01 needs to stay 05-01 but ecel shows it as 5th Jan!
Hi All If you could help that would be great I have a load of spec numbers for assets I look after. they are always 2 number with a - then another 2 number.…
-
When I send an invite for someone to view a database outside my organization it is asking them for a 14-day trial, why?
I still have multiple users available on my account and am just trying to provide a contract a view only access. The free trail is causing him concern. How can I share an invite with someone and them…
-
Selecting n records from a table into another table
Hi. I have a table D with a number of assessment criteria, each with an associated level; and I have a table S with names of students and their levels. I'd like to have a subtable in S that…
-
Ninox database not showing on iMac following reinstall of OS
I have Ninox on my MacBook and my iMac. I have just reinstalled the Mac OS due too have issues and then downloaded and reinstalled Ninox via the App Store,…
-
Two search in a base
Hi Among others I have 2 fields in a base. -One with a cross inside sometimes (x) -Another one also with a cross inside sometimes (x) What should I do to find the both with their crosses displayed ?…
-
Is it possible to have red colour for number fields?
Is it possible to have red colour for number fields? Requested for overdrawn or over committed inventory. I cannot see anyway of doing this. The number fields are used in many calculations and there…
-
Location -> GPS coordinates
Hi, We are using Ninox to register our clients, BUT here in The Gambia there are barerly any street names and addresses. And we work in remote areas to.…
-
ninoxApp() values and popupRecord() in ninox web app..
So, evidently, the function ninoxApp() also returns the value of "server".. Who would of thunk it. And.. does anyone see strange behavior such that an after update trigger of a relationship value ..…
-
pulling through colours from a drop down to PFD & Excel
Hi All I can colour code a multiple choice box 1=green 2=Amber & 3=red with the txt and the colour. But when I export it to excel and print to PDF the colours don't pull through only the txt.…
-
Filter a view and hide the column
I would like to filter a view using YES/NO column. When Yes the record is visible. In the view the YES/NO column is visible showing for each record only Yes. This is not functional.…
-
Mehrseitiges Dokument genereiren
Besteht die Möglichkeit auch ein mehrseitiges Dokument beim "Durckvorgang" aus den Daten zu genereiren?
-
Logical expression not working
I have a field "Groundschool Kit" that is either empty, 'Yes', 'No', or 'Already bought'. I have a 2nd field (text) that I want to show if "Groundschool Kit" = "Already bought".…
-
Printing Images
Each record in my table includes a text and an image field, would it be possible to design a print out that prints the image of every record on one page? Thank you!
-
How do I get dynamic Choice field towork?
I’m trying to create a database that mimics one originally created in Access and subsequently migrated to FileMaker. I’m getting a bit desperate, as I’m now in the last five days of my trial.…
-
REST API
In the documentation for REST API it is mentioned not to put the client-side API code. Then it is mentioned that you have to use the API code to get data from a ninox database.…