All topics

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

Differenz zweier Datensätze berechnen

Hallo zusammen, meine Tabelle hat die Felder „Datum“ und „Betrag“. Die Tabelle hat derzeit 5 Datensätze (31.12.2019 … 31.12.2023) Ich möchte nun den „Betrag“ des „Datum“s = 31.12.…

• Answered

How to hide the Printer,Trash,Duplicate and Add Record Icon in the latest version of Ninox

In the previous version of Ninox, I was able to hide the Printer, Trash, Duplicate and Add Record Icon with the Formula....... html(“<style>.hud-menu-button.menu-icon.menu-icon-trash{display: none;}.…

Images size on printouts

So after much head scratching, and i am sure there is an obvious answer but ..... I am somewhat stuck Does anyone have any idea how to control the image size on standard print layouts I now need…

PrintRecord layout and printing attachment images

Hi all, Some of my records have images attached and when I print the record, I want to add the image. Ninox has a clickbox for that feature that I can use. So far so good.…

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

Sms several receiver

Hello I'm looking for to do a quick solution to send message from my phone through ninox. I have found the fonction sms, however I would like to add severals number in the conversation I have tried…

duplicate bug?

Hi, This bit of script let newRecord := duplicate(this); openRecord(newRecord) The first line duplicates the record for sure, but returns null inside the script (I believe) so the second line will…

Records filtered by Dynamic Multiple Choice

So, I have many fields that are dynamic "single" choice. My goal is to filter data using a multiple choice dynamic field but am having issues with scripting it correctly.…

• 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

How to modify multiple if statements (I'm not sure if that's the right way to express it).

In the database below I have two key buttons, I will temporarily call the code in "Key1" "if1". Now I need to run the "if2" code after meeting the "if1" condition "avg(test) = 1",…

• Answered

Avoid delate table

Hello, with the edit mode disabled, how can avoid to delate a table? Thanks.

how to export a file attachment

hello, i want to create a button to export a pdf file, created by printandsaverecord, in a external(https://www.....) location. This in order to use this file in the mailing to the client in another…

Warning on button coding: "Field must return dynamic values..."

Hi there! After some trial and error, I came out with this coding that works as expected but I can't get rid of the warning sign saying: Field must return dynamic values...…

• Answered

How to use code to edit out unique non-repeating random numbers?

How to use code to edit out unique non-repeating random numbers? Thank you for your reply.

Trigger after update & Alert anomaly

Community - I developed a database in the Mac app. The database is deployed on the web. There are 2 fields in a table that have code entered into the 'Trigger after update field'.…

merge pdf

Hello, In my database when I send a bill from a customer, I have to create two documents. The invoice in pdf and the payment in pdf. After that, I sent it by email.…

Select only the Phases to Audit  by the Area Audit: Multiple Choice Dyn

@Fed In the table AUDIT I define the Audit #, Date Audit, etc... and the Area to Audit (Multiple Choice dynamic) then click on ADD to Audit and then update the Table Audit Plan,…

• Answered

Dropdown menu on database icon not working

The dropdown menu on the upper right corner of the database icon at the Ninox home screen (showing rename, and other functions) doesn't work since update 3.11.5 update (Mac desktop version).…

Manual sorting view?

Is there a manual sorting view? One that stays the same until you drag and drop records up/down? If not that's feature request.

Date format in formula

I am trying to set up a multiple conditional if statement. Having trouble figuring out how to put a date for the script to check against. Here is my code.…

• Answered