Retrieve the data from a button variable

Hello! I have a database in which I have a table "Dashboard" which is the page that displays when I open Ninox and another table "Accounts" containing all the contact details of my customers.…

• Answered

Retrieving the past 14 working days dates

So, I am creating fluid charts on our dashboard. I am having difficulty creating hidden fields that will have the specific #'s to work with. I want these fields to be calculated based on working day…

about the chart display problem.

I want to make my chart (image) to be sorted by value in chart 1 and display name in chart 2. How can I set it up? Thank you for your reply!

Importing Data into a Dynamic Choice Field

I know this was addressed many years back and at the time it did not appear to be a solution. However, has anyone come up with a way to import data into a dynamic choice field when the text being…

Count of records/table per day

Is there a way to count how many entries have the same day in some date field? Eventually, I need to calculate the average of records over several months,…

About the copy problem

I tried to copy the content of "copy" to "copy here", but they are not complete copies. Where is the problem with my code? Thank you for your reply!

• Answered

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