Multiple choice field (dynamic)

Does anyone know if I can have such a field in more than one column ? The case is that I have a table called keywords, which occur in a MCF (dynamic) field, and it works perfectly.…

• Answered

Product from multiple records

I have several data records with a field “Year” and “TWR”. For each year, there are multiple records with different TWR values. Now, (in another table) I want to calculate the product of the TWR…

add Rich Text Fields

Hi there I have several rich text fields I want to combine with the format they have. To make it easy let's say that I have RT1, RT2 and Endresult. If I say Endresult :…

• Answered

Resetting a Page Field...

I have a page with a search field (Text) and a "clear search field" button next to it. Is there a way of pre-setting or clearing that field PRIOR to opening the page - effectively clearing previous…

• Answered

I can't edit fields?

I cannot edit fields in most of my DBs. Why might this be happening?

Formula error? What is wrong?

I have a number field "Buy In Cost", and a formula field "My Buy In Cost", which is = to the field "Buy In Cost". Here's my entry: Here's the formula results.…

Date insertion

Dall'ultimo aggiornamento quando vado ad inserire una data il programma inserisce automaticamente il giorno prima

What does Sync app do?

Look up/search a single record with GET returns array instead of an object

Hello is the documentation wrong or am I missing something? There is an endpoint Look up/search a single record with GET that is GET…

Are these all errors?

Is there documentation regarding what these badges mean? I think the red ones are errors. If so, how am I suppose to fix them? This screenshot shows only 1/3 of my fields.…

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.…

Control the focus of a field

I have a text field that takes data from a scanner and runs a script when modified. I would like the focus to go back to that field automatically, ready for another scan. Is it possible?

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…