-
Why using a choice field's text does not work in an "if" statement?
Hi all. Using the number next to the choice's text in an "if" statement works. Using the text part does not. Why? Looked in the documentation, the only example I could find does use the number,…
-
Display and already uploaded attachment in an 'image field'
As a rule I try to avoid paperclip attachments or displaying large images in fields however on the odd occasion I would like to. Is there a way to display an attachment that has been uploaded in a…
-
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,…
-
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.…
-
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
-
transaction or deferred
the query below currently takes almost five minutes (browser) with just 30% of the final data expected. It's okay to wait this long , but I was wondering if anyone has an idea how to tweak its…
-
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…
-
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:…
-
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:…
-
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…
-
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
-
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
-
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
-
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
-
Interesting HTML formatting
Hi all - I've been adding HTML tables to my dashboards as they make things prettier and compact. So I found when you have multiple HTML formula fields, you can't change the color of only 1 of them.…
-
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
-
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
-
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
-
Custom Buttons
My contribution for the holidays is this template that allows you to create personalized buttons. Happy Holidays! Download and leave a review here...
-
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
-
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…