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

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

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

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

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

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

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

question regarding the script we worked on yesterday

Hi, @Sotirios Zormpas One more question re yesterday's thread https://forum.ninox.com/t/p8ykzc2#p8ykl39 if you don't mind. Is your script expecting the Attended field in the RSVP table to be a text…

• 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

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

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

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

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

• 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

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

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

format numbers

let api := "a7e22d237021e918cbaa602fe168f52b"; let artist := replace(Name, " ", " "); let album := replace(Title, " ", " "); let url := "https://ws.audioscrobbler.com/2.0/?method=album.…

• Answered

I can't format number in formula field

Good afternoon everyone I have a table called "Tasación" that is related to a call "Inmuebles" that in turn is related to a so -called "Contratos de arrendamiento" in which there is a field called…

• Answered

Retrieving values in Dynamic Choice field

New user here - exploring the potential for Ninox to help me with a fairly simple database task. But I’m now getting into it! In Table-A, I have successfully populated a DynamicChoice field called…

• Answered

Array switches from rid to nid

I have the following piece of code: let allRGRecs := record(Leagues,leagueRecID).RiderGroups; let finalRGsbyTeam := allRGRecs[false]; let getRidersByTeam := RidersAnnounced[TeamID = 119].…

• Answered

use of for fonction

Hello ninox! I struggle with the for function (I think this is the one I need but maybe it could be where...) Here is my script: (sum('PV coque PRO à date') + sum(Options.…

• Answered

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

Formula values not appearing correctly in table view

I have a few formulas in a "People" table that sum up various amounts from another table. These amounts appear correct on each record in Form view. When I look at the data in Table view,…

• Answered

urlDecode("%E2%80%87");

let xlf := urlDecode("%0A"); let fsp := urlDecode("%E2%80%87"); let focus := this; "InvoiceNo: " + InvoiceNo + xlf + "TOTAL NET PRICE: " + 'Total net price' + xlf + "DISCOUNTS:…

• Answered