-
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:…
-
Ninox script to work with csv files
Ninox has a convenient wizard for importing (.csv) data which is well featured and easy to use. If you regularly work with data contained in csv files, you may be keen to to avoid retracing your…
-
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
-
Transform Table <-> Page
Leonid Semik has once again delivered a little script masterpiece that can convert a page into a table or a table into a page. Simply create a button in the corresponding table and copy the following…
-
Duration in days, months and years
I'm fairly new at Ninox. I'm building a research database for history data in which we use a lot of dates, for ages, duration of events, etc. An easy readable display of duration would be great for…
-
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
-
How to Iteratively Add Items to a New Array
I'm new to Ninox (less than a month of use), so if this is common knowledge I apologize. However, I feel compelled to post this because of the incredibly steep learning curve of Ninox.…
-
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
-
Beginner: Database for research project - Transition from Excel
Hi, I'd like to use Ninox for my research project to store some information regarding fieldwork (date on which a specific sample was sampled, comments, photos, etc.…
-
Photo preview but no import
Hi, I'd like to use Ninox for a project that involves many photos. Would it be possible to just refer to an image, and let Ninox generate a preview image but not import the image to reduce the size…
-
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
-
New functions
Hello everyone, I put up this post to list all the new undocumented features of Ninox. I started a post here (https://forum.ninox.com/t/g9hs0n7/v3-7-11-new-functions) but its title limits it to…