Sum the checked items in Dynamic Multiple Choice

Need to sum the checked items in Dynamic Multiple Choice is these example 1400 € There are any way to sum this ? I try it but no way sum(chosen('Sub Components'))sum(chosen('Sub Components').'Budget')

• Answered

"Native" maps Ninox

I have a database with the latitude and longitude of an adress. When I click on the marker a kind of "native" window of Apple Maps opens showing the location.…

Problem attaching pdf to thunderbird

Hi there i have this code to in a URL to add details in to Thunderbird email that works on all the fields exept the attachment field will not attach my Pdf-Image,…

New bug in Date field?

Hi Just had update 3.16.4 IOS on my phone (iPhone 15) On opening my databases I've found that the Date field is now a day earlier than it should be BUT the date /time field shows the correct date.…

do as database error

let nID := number('Select the related parent WWP'); <= nID = ID # of the selected record in a dynamic dd for db 'DAD-WWPData' let z := "100"; do as database 'DAD-WWPData' <= simple database…

• Answered

How can I use global values that only an admin can set but all users must read?

(I posted this same topic in the Learn and share forum, but it's a question, so I copy it here —don't know how to move to the correct forum!) I'm developing a solution that has a configuration Page…

Date alert

Hi all, a few years ago, Fred kindly supplied me with an answer to a date alert question but now I need to adapt the solution. I have tried searching the forum and support files for an answer so…

• Answered

finding contacts with different email addresses

I have a membership database where we import information that includes updates on our contacts, via .csv from another system. If a contact already exists in our contacts table (ie email address…

• Answered

Restoring an automatic backup online

I messed up this morning and deleted the wrong field (lesson learned - clearer field names) and need roll back to the last backup, but when I go to MyTeams and go to manage backups or import archives,…

Rich text field + carbone print results in failed text wrapping

There seems to be an issue with the text wrapping in a carbone print that has appeared since the latest update. In Ninox I have a Richt Text field set to Field Type "Rich Text" In the Carbone…

• Answered

Record Date & Time Timezone Problem

Hi, our business is running in Europe and records are created locally with correct timestamps. Problem is that when I open the Ninox db from Asia it shows me the records with all dates and time…

One table with two relacion N:1 is possible generate a query view ?

@Fred I send the Demo, I thought I could solve it

Average Function not working in table view

Average "summary function" not working in table views?? Gives incorrect results

Can I script clicking a button?

My screen has a search field (just a text input) and I have created a button next to it with the search routines that I am happy with. However as a user presses "Enter" on the search text entered in…

openTable issue

Hello - openTable script stopped functioning. Starting with 3.15 I have button scripts that direct the user to a table and view openTable("Supplier", "Inventory") .... has been working for months.…

• Answered

can I launch import wizard (for .csv) via script?

I can't find any reference to this anywhere including Ninox docs. I want to create a button on my dashboard ("home" page) that takes me to a specific table (StagingImport) and launches the import…

Simple http GET fails

I'm using the free standalone version 3.15.6 on MacOS Sequoia. I put the following code snippet into a button: let response := http("GET", "http://localhost:8000"); if response.…

need help on importing a .csv into two related tables (scripting help?)

I have a ninox.com database with two working tables: Contacts (to track association members) and Events (to track events to which those members are invited).…

• Answered

database level trigger in ninox.com?

Hi - I want to create a trigger that executes when I open my online database to go to a specific table ("Dashboard"). I see plenty of info online about doing that in the Mac app,…

• Answered

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…

• Answered

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…

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