-
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
-
Put comments in the scripts
I discovered that it is possible to easily metre comments in scripts with a notation that was not documented: #{here I can put any text}#; var y := year('Start date'); var m := month('Start date');…
-
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
-
Accessing a single line item on an invoice
I'm trying to pull the TOTAL value of a single line item in an invoice that has 3 line items consisting of £195, £56, and £18. After trying everything I can think of,…
-
Hiding Icons HUD - choosing which to hide
I use this to hide ALL icons etc on forms. I have tried to show only the PRINT icon by removing 'none' in the relevant line but regardless of refreshing the page or toggling the HUD Y/N the print…
- Answered
-
chiose table from a variable
Good morning everyone! With this script assigned to a button, I would like that the name of the table on which to create a new record to be based on a field of another table where the script is…
-
A question about Choice and Multiple choice
How to select or unselect all options in a Multiple choice by code in bulk? How to select or deselect options in a Choice by code? I want to use it in "Trigger after update",…
- Answered
-
Need Script for calculating workdays between 1st record, 2nd record, so on.
Ok, Thanks to @Fred I am able to calculate the working days since a previous record for a client. with the following script let t := this; let xBase := ('Clark Leads'.…
-
Fonts, Colors and Borders
Hello, I uploaded an interactive CSS generator database titled "Theme Helper" in the Webinar EN 2021 team. It is very slow to respond online in the browser,…
-
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
-
Auto-populate pricing from another table?
Ok Ninox wizards, now I'm trying to auto-populate some pricing and job details. Here are the top level details: Main table is 'Job Status Log' which has 100s of job entries that are connected to my...…
-
Auto-populate Music Library Fields
I am working on databasing all of my sheet music and would like to auto-populate a field on one table with information from two other tables if possible.…
- Answered
-
Create records from dynamic multiple choice
Hi guys, I hit a bump trying something new: I have a dynamic multiple choice field called 'Keuze kritieke fases' I have a subtable 'Kritieke fases'. I have a button that I gave following code on…
-
Using a table selection in script
Hi, I'd like to be able to scroll through a set of records in a table and update values on each record. I want to select the records using the selection feature on table view, as used for bulk update,…
- Answered
-
Help with Google Charts in Ninox
So, I just wanted to start with a very basic Google Chart in ninox. With Google's default data, the chart shows, however when I try to replace it with my data it no longer works. Below is my code.…
-
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,…
-
Create new records with a button
Hello! I've been learning a lot with Ninox and this forum has been very helpful. This is the first time that I would be creating a button. But I think it is possible to make the process easier and…
-
Pass current viewing record Id to a view element column formula
Hi all - I have a table that has a view element. I'm trying to do formulas in the view element that requires data from the record I'm viewing. As we know,…
-
Formula to Include Multiple Filters from Choice Fields
Ok, I have been stumbling a few days over this trying to get the right formula. What I am doing is creating a sub table to give me the values I need, so then I can draw those into a chart correctly.…
- Answered
-
extractx() “g” flag workaround
Here is a basic UDF for extracting all of the values that match a regex pattern... function extractxg(src : text,regex : text) do let extValue := “”; let idx := 0; let idxLen := 0; while testx(src,…
-
Embedded eCharts into Ninox
I have tried to embed eCharts into Ninox but have yet to succeed. For example, I put the following code inside a function field, but nothing: var _style := "* { margin: 0; padding: 0;…
- Answered
-
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
-
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
-
Ninext : Native JavaScript
I start here a new post about the Native JavaScrip to differentiate it from the EvalJS function in which I had previously put it... I discovered one weekago that it was possible to add comments in…