Optimize this Code is to large

let s1 := if Status = 1 then 1 else 0 end; let s2 := if Status = 2 then 2 else 0 end; let s3 := if Status = 3 then 3 else 0 end; if s1 then let reply := dialog(" 🟢 Audit To History",…

• Answered

Share view no longer works

I have used the "Share view" for a couple of months now and after having worked flawlessly, the link does not work any longer for two particular views. As a result,…

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…

Page Break

Hello, In order to keep my invoices tidy, I need to insert a page break. For example if I add more than 10 items on my invoice, my invoice form gets all messed up.…

duplicate table problem

I duplcated a table. Not many fields, maybe 10. I didn't change the field names etc. When I try to open the new table I just get a twisting circle in the middle and cannot stop it.…

Duplicate a Table fields

How to duplicate a table with the fields (i.e., without the data)?

word document

how can i export my data to use in a export word document. for example. my database has a name and adres wich i would like to see in an export word document.

Something wrong in this script.

let s1 := if Status = 1 then 1 else 0 end; let s2 := if Status = 2 then 2 else 0 end; let s3 := if Status = 3 then 3 else 0 end; let check := dialog("Attention", "Are you sure?", ["Delete",…

• Answered

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…

Search field doesn’t recognise apostrophe…

I have a database with song titles, and have noticed that titles that include apostrophes do not show up in a search… For example ‘Don’t Go’ will not show up when I search for the word:…

Create an appointment for next week

Hi All, I have a button in a Dashboard to create an appointment and popup the new record. The new Appointment record has the date field set for Today as the default. It works fine.…

• Answered

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