-
How to auto-fill the relationship field choice?
How to auto fill this relationship field when I create new record, instead of click into the field and choose what record. I want it auto fill because the date is just the latest date,…
- Answered
-
How to auto create new record every day?
I have to create a daily record, but I have to hit the button every time. Now I want to use loop function to create new record every day. can someone show me how please?
- Answered
-
Using a table selection in script
Hi, I'd like to be able to scroll through a set of records in a table and update values on each record. I want to select the records using the selection feature on table view, as used for bulk update,…
- Answered
-
How to select different options in bulk?
I have a table, and I want to select 'Star' as 1 for all 'old code' less than 100, and as 2 for all 'old code' greater than 100. How should I write the code in the button? Thank you for your response.…
- Answered
-
Regarding the issue of non-administrative accounts not displaying the field.
I have confirmed that the read permissions for this field have been set to allow everyone to read, but it still cannot be displayed for non-administrative accounts.…
- Answered
-
Payment of several unpaid invoices
Hello everyone, I have something difficult (for me at least), but I'm not afraid of you, I trust you :-) I have built a database of my finances. All good so far,…
- Answered
-
Need to link each expense from this week to a record and then link it to the main table
Hello! I have in this issue, three tables: 1st Table: Management (for each week there is a record. 2nd Table: Fixe Ausgaben (every record is one expense, which is recurring monthly on a specific date.…
- Answered
-
Thoroughly delete image elements with code
I have image elements in a table. I found that using the code "Images:=null" does not completely delete the images. How can I use code to completely delete them?
- Answered
-
Find special Codes
I have to kind of Code 'AUxxx' and 'AUxxx_x1' There are way to find all codes finish on _x1, on a select 'Audits Plan' where 'Audit Code' ???
- Answered
-
trying to add 6 months to a date
Hi I have trying to add 6 months (ideally less 1 day) to a date. The formula I am using is date(year(date('Format date')), month(date('Format date')) + 6, day(date('Format date'))),…
- Answered
-
How to count number of lines and contents
Hi. Your help is greatly appriciated. I am going to be surveying fire doors. for my report I have a question (Is the door compliant) 1st - I would like to be able to have a formula to count the total…
- Answered
-
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
-
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
-
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
-
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
-
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
-
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
-
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
Answer questions and share your knowledge