Create a view based on contains

Hi all, I have a table "Guidance" and in that table I have a multiple choice field named "keywords". Now I want in another table to create a view based on a textfield "keyword selection" - my idea…

• Answered

Passing a field name (string) as a function parameter

I'm searching the forum but I can't find an answer to this question. I've defined a function like this very simple example: function updateField(iField:text, iValue:text, iRedord:…

• Answered

Bug obtaining a value from a JSON object

I'm trying to use parseCSV to retrieve specific values from a CSV file. After using the parseCSV function with the firstLineIsHeader option set to TRUE, I can retrieve the content of the first item:…

• Answered

Switch

Can anybody tell me what is wrong here ? ninox gives an error at case 2 where it says that keyword 2 is not found. I have tried without ";" - same problem, and also tried to remove case 2,…

• Answered

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

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

Different numerical output...

As I new user, I thought I would share this, since I was pleased to have successfully written my first global function and moreover it did what I needed.…

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

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

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

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

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

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

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…

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…

All Scripts (Copy to Clipboard) no longer working (local DB)

Dear forum members. For years, I have been using Ninox as a library for my tracks, which I plan, perform, and archive for biking and hiking. There are also many scripts that I implemented to copy a…

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