Scripting and Functions

How to select different options in bulk?

I have a table, and I want to select 'Star' as 1 for all 'old code' less than 100, and as 2 for all 'old code' greater than 100. How should I write the code in the button? Thank you for your response.…

• Answered

generate PNG invoice files?

Can Ninox directly convert PDF to PNG and other image files? Or generate PNG invoice files? If so, how to write the code? Thank you for your reply.

Multi language solutions best practices

Hi again. I don't know if this is the best place for this question, but I will try... Here in Spain, about 70% of our clients sell their products and services in at least 3 languages: Spanish,…

• Answered

Thoroughly delete image elements with code

I have image elements in a table. I found that using the code "Images:=null" does not completely delete the images. How can I use code to completely delete them?

• Answered

Payment of several unpaid invoices

Hello everyone, I have something difficult (for me at least), but I'm not afraid of you, I trust you :-) I have built a database of my finances. All good so far,…

• Answered

Need to link each expense from this week to a record and then link it to the main table

Hello! I have in this issue, three tables: 1st Table: Management (for each week there is a record. 2nd Table: Fixe Ausgaben (every record is one expense, which is recurring monthly on a specific date.…

• Answered

A way to find out where a specific field is referenced anywhere in your tables?

So, one thing that I find would be helpful, is if there was a way to search for everyplace where a field is referenced or another formula is dependent upon in your tables.…

show only relevant table columns based on two criteria

Objective Map relevant terms, people, and institutions to respective slides. Hurdles Show appropriate table columns based on source/target language. Hey Ninox Experts, Hey@Fred /@Jacques TUR ,…

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

Expression to extract text in a string to the right after a dash character

I need to extract text in strings (product labels) after a dash character. An example string: Pavé Nameplate Necklace - "ADHD". Ideally, the result would be ADHD, but "ADHD" works as well,…

• Answered

Dashboard Help to Compare This Years Data to Last years Data to same date.

So I am in the process of creating an Insights Dashboard. I am needing help in putting together the right syntax to compare this year to present vs last years data to today, but 2023.…

Is it possible to convert Chinese characters into the initials of their corresponding Pinyin using code?

I would like to convert '你好' into 'nh' (the Pinyin for '你好' is 'nihao'). Can this be achieved through code? Thank you for your response.

Creating Chart with Multiple Series

I've searched around to see if Ninox supports this, but can't find anything. Can I create multiple series for 1 Ninox line chart?

Help with Button that inputs Date into parent record

Chronos is a subtable of Leads. When creating a Chrono, I have made an option that allows a user to push the button to create an "Active Date" that matches with the Date of the Record in the chrono…

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…

Bizarre Results from Filtered Records

Ok, this has never happened to me before and is only occurring with one field. I have a simple choice field called 'Reason'. However, when filtering results by choice ID #,…

Can't get results to exclude a field value of 0.

I am having more difficulty than I should in having this following formula exclude any records that have 0 value in my 'contact attempts' field let curRec := this; let xStart := 'Start Date';…

• Answered

json add array

Hi everyone, i have spend several hours solving this Problem. I have this code: let myURL := ""; let myBearer := (select Einstellungen).'Bexio API-Token'; let contact_id := Kontakt.…

• Answered

How do I filter data in charts?

How can I set the chart view in the "inventory" table to only show "meat" and "bread"? I tried Filter but it only works when I enter one "food name", is there another way? Thank you for your reply.

• Answered

Dialog on Trigger on new record

Am I correct that a Dialog will not work (cloud version) when creating a new record. Example dialog below in case there is something wrong with it. let title := "Serial and/or Bundle Required";…

Find the minimum value in a group of records

Hello Ninox users! I’m completely addicted to Ninox but still young in scripting… so… Does anybody knows how is scripted the formula used to find the min/max/… of records grouped in a category (see…

• Answered