-
Dynamic multiple choice filter that works only on Server
Hi Ninox Brain Trust, Attached will be found a small database that has a filter for a dMC (Customer.Location) that only works on the Server. Please look to see if there is an alternative formula that…
-
Dashboard Help to Compare This Years Data to Last years Data to same date.
So I am in the process of creating an Insights Dashboard. I am needing help in putting together the right syntax to compare this year to present vs last years data to today, but 2023.…
-
CreateCalendarReminder - Access not granted ---- how did you get around it?
The function CreateCalendarEvent works... "CreateCalendarReminder" does not... it brings the message "Access not Granted" In System Preferences / Security & Privacy / Privacy....…
-
Is it possible to convert Chinese characters into the initials of their corresponding Pinyin using code?
I would like to convert '你好' into 'nh' (the Pinyin for '你好' is 'nihao'). Can this be achieved through code? Thank you for your response.
-
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
-
Creating Chart with Multiple Series
I've searched around to see if Ninox supports this, but can't find anything. Can I create multiple series for 1 Ninox line chart?
-
Edit PDF
After editing a PDF contained in an image-field using the new editor, if you click on the image-field that contains the PDF, Ninox displays the PDF only in the PDF editor.…
-
Have a Page number on the Print document
Hello :), I'm working on the template for my invoices. Is there a way/ formula do add on the Print document the Page number? I'd like to have on my document:…
-
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":…
-
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
-
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…
-
Best Solution to Import PST to Office 365
Hello everyone;I want to tell you about an excellent tool that helped me a lot to import PST files into Office 365. Using MailsDaddy PST to Office 365 Migration Tool I easily shift my complete PST…
-
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,…
-
Pages - uncontrolled restoring of previous versions by Ninox
I think I have experienced an incident: one of the Page I have developed within my database was restored to previous version. Only I have rights to enter this page, no one has higher rights than me.…
-
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:…
-
Weird browser constraint bug
Hi all - I've encountered a strange bug with the browser vs app with a constraint that is based on a choice field. I have reference field that has a constraint and it was working in February.…
-
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
-
Heads Up folks - a neat byproduct of using hide icons.
I have used this to hide icons and you will note that the print icon is not included iro what to hide. The print icon is displayed. What is interesting though is the 'trash' icon when editing the…