globale Änderung eines Tabellennamens

Hallo zusammen! Habe folgende Herausforderung: ich greife bei verschiedenen Tabellen auf die Tabelle X zu. Diese Tabelle X möchte ich nun durch die Tabelle A (neu) ersetzen.…

• Answered

I Need Help for this Script.

if Status = 2 then let reply := dialog(" Major - Non Conformities", " This Audit was not compliant therefore within 14 days the major non conformities will be reviewed ", ["Confirmed",…

• Answered

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

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…

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.

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'.…

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

Need the Diferent Between Two dates, Without Weekend and Holidays

I have Two days example 4/Mar/2024 and 11/Apr/2025 need the days wiithout Weekend and Holiday. I have define the table Holidays.

• Answered

About signature Questions

How to copy the images in the (signature) field of table A to the (Image) field of table B? What should the code look like, thank you for your reply.

• Answered