Find Highest Number

This must be simple, but I need some help. How can you display the highest number in field? Example: I have 1000 Records with 1000 different numbers. I'd like to show the highest number and then add…

Trigger After Open

I use this trigger: if ninoxApp() = "iphone"then openTable("TableName", "PhoneView") else if ninoxaApp() = "mac" then openTable("TableName, "MacView") I want when the Table opens to go to last record…

Default value for Location (lat / long)

The following steps are needed to record the current location when using Ninox on an iPad. I see now "default" value. Is there a function that can be called?…

sum and count function?

Is there sum and count function for column

Request to Remove Quotation Marks from Field Return Value

Hello everyone, I would like to know if it’s possible to modify the return value of a program field so that the word name is returned without quotation marks.…

• Answered

Ninox Changes Pointers to Records ON ITS OWN!!!!!

This is a huge huge PROBLEM and has to be a BUG -- and I have now confirmed that it was reported at lease 8 Months ago ... and is still not solved. I have a DB with thousands of records where the UI…

Addition der Zahlenfelder in einer Spalte

Hallo, liebe Community einmal für einen wirklichen Anfänger mit Ninox, ich habe eine Tabelle und ein Zahlenfeld und ich möchte gerne das am Ende der Spalte alle Zahlen zusammen addiert werden und…

Mehrfachauswahlfelder mergen

Ich habe eine Datenbank, die viele Datensätze hat, die eigentlich Duplikate sind, aber in einigen Bereichen unterschiedliche Werte haben. Ich habe nun ein Skript geschrieben,…

how to eMail with attachment on the Mac version

Good morning to everyone I'm driving myself crazy trying to send an email with a pdf invoice attached to It on my Mac version of Ninox. The invoice is generated on ninox and I'm able to save It into…

Extracting data from a view (new user help)

I’m learning Ninox, finding my way around and getting used to it. But I need a little help please… in Table A, I have various fields and have created views to interrogate accordingly.…

• Answered

How to write the latitude and longitude information from a map click into a text field in Ninox

Hi friends, I need to write the latitude and longitude information displayed when clicking on the map into a text field (in the sample database Test2.ninox).…

• Answered

email field

Does anyone know if I in the smart field "email" kan make and attachment, so that when clicking on this field it will bring the attachment with over to my mail system ?…

Update a field and jump in a record.

I have a JavaScript function used to do a update of a field and jump in a record. --- function myClickTitleIntervention(id, url, valeurClick) { "{" } console.log("Start"); var myElement = database.…

Filter

I need to filter the records in the Tracks table in a View based on the selection of the Multiple Choice Dynamic 'Select Album' field.

• Answered

Button script: add new record from table B to current record in table A

I have linked tables in a somewhat complex database. I have a button that is running a script to create a record and other tasks, but the part that I am stuck on is how to tell Ninox to add the…

Formula field size when displaying iframe

I’m trying to display an entire webpage using a formula field in a page. The formula utilizes the html() function and an <iframe> tag. However, I’m having trouble making the field large enough to…

Is It Possible to use Function "parseCSV" directly in Server Mode?

Hello Ninox Team and Community, I’ve successfully created a workflow that imports data from a CSV file into my PRODUCTOS table. However, this system requires using an intermediate text field…

E-Rechnung

Creating view using dynamic choice field

I have a database of equipment. The equipment is in various locations of the building. All the locations are stored in a separate table 'Locations' with two fields: 'Main location' and 'Sub location'.…

Yes No field , make the no choice 'empty'

I have a yes/No field where I only need the Yes to show up in a print of the table. All good if I select the yes option or if left untouched, as the default setting is 'empty'.…

Is there a way of setting ID counter back to 1

Is there a way of setting ID counter back to 1. The table itself is empty afater I deleted some incoreectly imported records but it would be great if when I re-import that records start from ID 1 etc…

file unzip Fail

Hi, When I am trying to import Ninox database from Dropbox into Android phone I get "file unzip Fail" message. Even though the database appeares in the app list. And even opens.…

Problems with browsers

I have the problem that when I update image file from the browsers they either get nulled or show wrong information. When doing the same by logging in via the app it works.…

incorrect thumbnail

incorrect thumbnail pictures when multiple records are shown in view but correct when the record is individually viewed on its own

Get the tracks by album

let apiKey := "8c6c8610-4f04-11ee-b74b-03c9318fae41"; let artist := substitute(text(Name), { " " : "%20" }); let album := substitute(text(Title), { " " : "%20" }); let url := "https://ws.…

• Answered