-
Impossible to put some pictures in Ninox !
Hi Sometimes I drop a picture from the web on the picture aera od the forms view and Ninox refuse it. What is the issue ? How can I manage it ? Thank you
-
Link record n:1
I use this code to automatically link records 1:n let myID := ID;let nMP := (create 'SecondTable');nMP.('FirstTable' := myID); What code can I use for the reverse, n:1? THX
-
Issue to drag and drop columns of a 2 relational tables
Hi Having created a relation between 2 tables in a base I go to "modify" (gear tool) and I try to drag a column from the right window (available columns) to the left window (visible columns) but it…
-
Formula to combine two multiple choice fields?
What would the formula look like that could do this?
-
You are not authorized.
Hello Ninox! I am having difficulty opening some of my databases. When I try to open it, nothing happens. If I try to create a backup of those DBs then I get an error "You are not authorized".…
-
Inserting a hyperlink to a printed PDF
I can currently print a series of instructions for a colleague using the following as a formula in a table: if 'Bus Stops'.Operator != "WALK" then"catch the route " + 'Diagram Strata Information'.…
-
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.…
Answer questions and share your knowledge