Scripting and Functions

JSON and for loops

Hi all - I was reviewing the set() command and noticed this: for i in response do let new := (create Contacts); for key, value in i.fields do set(new, key, value) end end Look at line 3,…

Copy record Id failing

I have the following script on a button. Everything copies over except the record Id. Any ideas on why? The target newInventory.(PurchaseItem := me.Id);, is a number. No errors are apparent.…

• Answered

Connect 2 entries

Hello. I have this code in the table Solicituds in a button: let dniActual := DNI; let personaEncontrada := (select Personas where DNI = dniActual); if count(personaEncontrada) > 0 then alert("El DNI…

• Answered

Trigger after update not triggered when updating by copy&paste

I have a table with code for trigger after update (for the table, not a field). When I edit an existing record by typing in a field, the trigger gets called as expected.…

Open URL button w/URL parameters (ninox replacing characters)

Hello, Ninoxians! I am trying to create a button that will open a URL and pass parameters into that URL from my record; however, Ninox is replacing parts of the URL with different characters.…

Control of HUD icons

Can anyone tell which one of these switches off the paperclip and comment icon? Also, the print icon. I am hoping to be able to switch off everything and just leave the paperclip,…

• Answered

how can I make the options in HOME not include the items that have already been selected..

Hi friends, how can I make the options in HOME not include the items that have already been selected (inside the blue box)?

• Answered

OpenURL and parameters being replaced

Hi, I am trying to pass two fields to a URL as parameters, then use a button to open that in a new browser window. I have a formula to generate the following link which works correctly: https://www.…

Best practice to duplicate a record

Hello friends, I am using the Ninox macOS client (now that it has been updated to 3.13.3) I have created a "Duplicate Product Item" button to create a duplicate record of any product item in order to…

Hash of a string and check

Hello everyone. I use SHA-256 algorithm to generate hash from strings. Hashing is generated correctly and the value is copied to the clipboard. function sha256HashAndCopyToClipboard(string :…

• Answered

Trigger After Update does not get Triggered

, Hi@fred @sean I am facing a very weird issue. I have some code written in the "Trigger After Update" event of a DCF (Dynamic Choice Field). When I physically choose "empty" from the list in DCF,…

NINEXT Idea for table view (ALL)

@Jacques TUR Is it possible to freeze a column in (all) or even a view so that columns to the left are locked but scrolling to the right is enabled. Much like Excel where one can lock a column to…

How to track the selected item in a DCF

@Fred @Sean I was following the below post, but I think it got too long and complicated for me to understand.…

• Answered

multiple choice: delete option and set option on create new record

I'm sure that until recently it was possible to delete a row from the options of a multiple choice field. Now I can only edit the text and re-order the options.…

Selecting Product Items based on Product

Hello@Fred I have a Reference field where I select the main Product from Products table. Product Items is a child table of Products. I have added a button (Update Records) and a new column (Product…

Regarding the issue with selection

I want to choose “M” for option 2 in Table 1, but as shown in the picture, it doesn’t confirm the selection of “M”. What could be the problem? (I noticed that as long as the option is not covered by…

• Answered

Hiding HUD

Does anyone know how to hide these two elements - the + and Edit Would like to add these two to my HUD formulae. TIA

Button with script to populate table

Hi. I have a database as per the model in the picture. 1. Table with students. 2. Table with classes. Each class has a table of students (3) picked up from 1. 3. Table with assignments.…

For the HTML/CSS boffins out there please help.

New Ninox release has broken this in the sense that the Ninox setting for background color no longer works. How does one set the background color for a formula that is colored to be invisible with…

Trigger - Update Number Field with Formula Value - en masse

Question about Triggers. Any help would be greatly appreciated! I have a table that calculates a Price formula. This Price formula is compared to a Current Website Price number field.…