-
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
-
Copy to Clibboard button
Can I create a button to select the contents of a field and copy them to Clipboard? (In FM Pro that was v straightforward)
- 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…
-
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.…
-
Print and save more than 1 PDF
Hi there, hoping someone can help me. I have several different Print Layouts for one table and I would like to be able to press a button and have the system print all of them in one go and merge…
Answer questions and share your knowledge