Scripting and Functions

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

Create a zip file of all invoices generated with printRecord()

Hello, I would like to create a zip file that includes all invoices from all records in the "Transactions" table. Invoices are usually obtained individually by clicking on a button containing the…

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

Constraints issue

In Proj-Buildings I select the BUILDING NAME taken from BUILDINGS. The constraint here: a.PROJECTS.CLIENT.NAME = b.ORGANISATION.NAME Limits the Buildings list to those for the client/organisation.…

• Answered

Build a Report Advice

Ok, I want to create a Form within my Ninox CRM that will allow a user to select pre-defined reports, click a button, and then than upon click it will create a new record for that corresponding…

Code about random numbers

I want to write a code for generating a random number that consists of six digits. The number should change every month, reflecting the progression of time.…

Help with multiline text field inside an html() function

Hi, is there a way to display a multiline text field inside an html() function without losing the multiline feature? I mean, when a use html(" + 'multiline text field' + ") the text is displayed as…

• Answered

There must be a better way...

I have the following code: let curRider := 'Team Membership'.RiderID; let rndJmp := RiderResults.'Round Type'; let x := for loop1 in rndJmp do AllResultRecIDs[RiderID !…

• Answered

Button script to select/link record on child table

Using the Invoice Template, I have a the 'Invoice' Table with an embeded 'Invoice Items' table. I add items to 'Invoice Items' by selecting existing records previously input in the 'Article' table.…

• Answered