-
This code works erratically sometimes it works and other times it doesn't
This code works erratically sometimes it works and other times it doesn't. delete (select 'Evaluation table'); let myY := year('Evaluation Date'); let myYM := yearmonth('Evaluation Date');…
- Answered
-
Automatically link record from one table to open record in another table using a button
In Audits Plan I have the field 'Audit Code' and need to open on 'Non Conformity' field the same 'Audit Code' on the 'Non Conformity' table the 'Audio Code' is a N1.
- Answered
-
Formula returning specific values depending on multiple choice selection
Hi all, I have a multiple choice field with around 40 options and I would like to set up a formula that returns a certain text depending on the options selected.…
- Answered
-
Type error: i.updateUI is not a function. (In '.updateUI()', 'i.updateUI' is undefined)
Hey, When I add an image (PDF, JPEG or JPG) to the Ninox database I get this message: Type error: i.updateUI is not a function. (In '.updateUI()', 'i.updateUI' is undefined).…
- Answered
-
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
-
Error to send Email
let check := dialog(" Audits Report ", " Confirm the sending of this email...> ", ["Do Not Send", "Yes Send"]); if check = "Yes Send" then sendEmail({ from: userEmail(user()), to: "ruben.leal@vepica.…
- Answered
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
Answer questions and share your knowledge