-
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
-
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…
-
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.…
-
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
-
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.
-
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
-
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…
-
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
-
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
-
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
-
Return JSON
Hello, I have this JSON data that is returned from a SQL select statement: {"result":{"recordsets":[[{"status":"Enabled"}]],"recordset":[{"status":"Enabled"}],"output":{},"rowsAffected":…
-
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
-
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.…
-
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:…
-
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
-
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
-
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
-
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";…
-
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
-
Avoid delate table
Hello, with the edit mode disabled, how can avoid to delate a table? Thanks.
-
Submit button with required fields notification.
Hi, I have a very limited knowledge when it comes to writing scripts so please consider this when answering. I have form for managers where they have to fill up information about sales and production…
-
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
Answer questions and share your knowledge