create options in choice field from variable/loop

It's easy to fill a dynamic Choice field with options from a table/query but how to dynamically create options through something like var options:=[] for i from 1 to 3 do options:=options + i end;…

• Answered

conditional unique() in column

my view should select all records in elements where the column "text" is unique for one label (being a linked record). So text "a" might appear both for label1 and label2,…

• Answered

Scripting a button to print text from a choice field?

I'm making a print template for an envelope, with a button to print. In the table, there is a choice field for "Active Location" - example, choices are Site A, Site B & Site C.…

Button for create a new record which has a connection to a record

I have a table, where in every record, i have a connection of records from a different table showing up. (1:N) when want to get a new record, normally click "+ Neuer Datensatz" at the 1:N,…

• Answered

Send emails with attachments with Gmail via Make

Hello, I send emails from Ninox with my Gmail mailbox using Make.com (Integromat) but it is impossible for me to send attachments. This is what my code looks like:…

get span of selected text

Is there a "dirty" way to use javascript to get the position of a selected text? I have a textbox (or a formula generated text, if that helps) and a user needs to select a text where I would need to…

index with regex

I'm trying to find a way to get the index (i.e. start position in a string) for a regex pattern. I can use text, replacex, extractx for various operations but not for getting the index,…

• Answered

Error message before sending an email with attachments

Hello, I created a button allowing me to add documents downloaded from a client, directly into the image fields of a recording that I want to send by email, I got the error message:…

Parse Dynamic Multiple Choice into JSON object

I have a DMC field that takes these values (dynamic value): let all_entities := (select elements); let my_event := this; let my_elements := ((select elements where 'parent entry'.…

• Answered

Need Assistance with Creating a Search Button and Displaying Results in a Table

Hello Ninox community, I am an IT professional assisting my wife, who is a real estate agent, in utilizing the Ninox platform. We have just discovered this tools few days ago.…

Questions about code merging.

In the following database, "1" is based on "Data1" to calculate the current state; "2" is based on "Data2" to calculate the current state. I want them to merge and be displayed in "3",…

• Answered

Questions about printing invoices

In the database table "Orders", there is a "New document" button. I created a new "test" table and set a "pdf" button. I have an idea that clicking the "pdf" button will generate a "pdf" of the…

• Answered

Search and select the most similar text

Hi, I need help to search and select a supplier in a table when I select a reference in another tab. I have 3 tables: one for suppliers one that acts as a register one for imports from another…

Regarding the batch write issue.

I created a button to change existing data, but when I click the button, the returned data is always the same. I have tried this many times, but I can't find a solution. I am asking for your help.…

• Answered

Help with a search

I'm trying to find records where a group of numbers match another set of numbers. Here is a demo of what I'm trying to do. let x := array(["545,577,831"], ["121,545,577"]); let y := [{ Loc: 115, RR:…

• Answered

button for Duplicate a record and its links to a sub table

Hello Community! I needs some help to create a button in my table Navire. Each record of Navire has multiple links to another table Options (1:N) This allow to create a navire with its own options.…

• Answered

Coding a popup dialog in a for loop if error

I've been reading that loops cannot be coded to exit. But I'm trying to figure out if there could be a way by adding an if statement somewhere in the code.…

• Answered

openTable() with sort order.

Hi, using openTable() is it possible to open a table specifying sort order? In other words: openTable() - in descending order on the record ID field -. Idea being to open a form view starting with…

• Answered