Link tables during import CSV

Does anyone know if this is possible - or do I have to run a script after import ? I know how to link two tables from button where they both have for example same type of field for a member number ,…

Changing an imagefield

Dear all I have a membership database where shooters obtain a certain licenscard, when they have had a kind of education. for this purpose I have a choice field with the different licensetypes an…

how can I write the latitude and longitude information obtained from the map into the X and Y fields of a database?

Hello everyone, how can I write the latitude and longitude information obtained from the map into the X and Y fields of a database? Thank you for your help.

Substitutions for ui.popupRecord

Hi all - What are the other solutions to ui.popupRecord? Ninox said back in v3.8 that it, and a bunch of other commands, are being depreciated. Though it hasn't yet.…

• Answered

openTable issue

Hello - openTable script stopped functioning. Starting with 3.15 I have button scripts that direct the user to a table and view openTable("Supplier", "Inventory") .... has been working for months.…

HTML and Ninox

So I'm trying to understand the difference between using double quotes ( " ) and --- when creating HTML code. I have the following code: let tbleHead := " <thead class='tableFixHead'> <tr>…

• Answered

Keep rID information in a JSON?

I have created a JSON object let t := this; let xPart := unique(Results.Partners); let xNewData := xPart.{ Name: Horse.'Horse Name', rID: Horse.Id, Atm: switch t.…

• Answered

recurring events in calendar

Hi there I have been told that one can make a script in Ninox for creating recurring events. Can anybody give me an example for a script to create recurring events ?

Making a field writable based on a condition

Hello Friends, I am not able to wrap my head around this thing. I want to make the "To Address" text field writable if the selection in the choice field is "OTHER".…

• Answered

How to Track Client Changes in Ninox (Audit Log Table)

Hello everyone, I am trying to create an Audit Log Table in Ninox to track changes made to a machine registry table. Objective: Every time the associated client changes for a machine (which I lend),…

How to use setItem in a button?

I'm having difficulty using setItem to modify a JSON in a text field with a button. I have a text field called json. It has a simple json object which is created with another button.…

• Answered

Sort by Nb Numerical Size

let data := [ "{'food': 'bread', 'Nb': 3} {'food': 'apple', 'Nb': 7} {'food': 'rice', 'Nb': 1} {'food': 'banana', 'Nb': 5} {'food': 'milk', 'Nb': 9} " ]; let sortedData := (data) order by Nb;…

• Answered

Hide multiple elements at once

Hello friends, I am trying to hide two or more form elements (text boxes) from within the "Display field only if" setting of one of the elements. How can I achieve this ??…

Looking to automate record creation based on a date

Long story short; I have a 'Tenant' record, which has their 'Rent payment date' in a date field. I've so far been unable to find a way to reliably create a new record triggered by a date. I.e.…

Ninox Bug Report 14.0

Here are a list of some bugs I have identified with the newest version: Rich Text Fields are not encoded properly in print view when using HTML A white screen flashes up occasionally (began in…

Hiding Edit Mode switch

Is there anyway to hide this: Edit Mode primarily. Thanks

• Answered