-
Newbie Formula Question
I think this is quite basic, but I'm new to all this and still learning! I have a table of contacts and one of the fields is a choice field that lists about 50 or so electoral ridings and I have…
- Answered
-
Ninext : Native JavaScript
I start here a new post about the Native JavaScrip to differentiate it from the EvalJS function in which I had previously put it... I discovered one weekago that it was possible to add comments in…
-
Fix to resize Console window
I don't know how it all works. I just figured out how to implement the code that Jacques posted here. Thank you very much Jacques. This code can be entered in "Trigger after open",…
-
Ninext loading modules not requested
Hi @Jacques TUR I just saw that my DBs are now loading all modules even when I specify only specific ones. Here is what I have in my formula: var configLoadModules := { badges: true, evalJS: true,…
-
Array trouble after update
I have some code that creates 2 arrays of records, which I then combine thus:- array(thoseDirect, thoseDupes) The combined array then gets used in a Dynamic Choice field.…
-
Button for create a new record which has a connection to a record
I have a table, where in every record, i have a connection of records from a different table showing up. (1:N) when want to get a new record, normally click "+ Neuer Datensatz" at the 1:N,…
- Answered
-
Extract year from date field in text format
Hello. I have a date field in text, format DD/MM/YYYY. How can I have an fx-formula field that returns only the year? For today, 15/09/2022, the formula field must return 2022.…
-
Put comments in the scripts
I discovered that it is possible to easily metre comments in scripts with a notation that was not documented: #{here I can put any text}#; var y := year('Start date'); var m := month('Start date');…
-
Explanations and examples of Ninox functions available in our docs
We added a separate page with explanations, examples and tips for each of the current 164 functions in our documentation. These pages are currently available in English.…
-
Sending emails reminders automatically in Enterprise version
Hi there. I'm searching the forums but can't find an answer for my needs. We have an Enterprise account, and want/need to send a remainder to our costumers when certain event occurs (time based):…
-
table numbers
Hello I have a reference to a table (1 : N) where all the relevant records are displayed. It would be very convenient if we were able to see the number of the array.…
-
Carriage Return and Line Feed (CRLF)
Hi there, In Ninox, I want to create a text file for an import into a 3rd party solution. The 3rd party solution requires line breaks to be formatted as carriage return + line feed ("CRLF").…
- Answered
-
Filtering data based on manual dates entered.
Ok, another question here. I feel I am in the ball park. I am trying to sort my data based on when clients were terminated. However, those dates I want to use can always change based on what…
- Answered
-
Formula to Include Multiple Filters from Choice Fields
Ok, I have been stumbling a few days over this trying to get the right formula. What I am doing is creating a sub table to give me the values I need, so then I can draw those into a chart correctly.…
- Answered
-
Linking to a record using the iCloud version
Hello! Is there a way to link to a record using the iCloud syncing? I tried to use the urlOf(this) function as described here: https://forum.ninox.com/t/m1hrtam .…
-
Auto generated email
hi, I'm trying to automate the email report. Like my aim is to fill fields and then my email would be ready. Here my workflow : Fill fields > Generate email > Mailto from ninox I can generate well my…
-
Custom HTML Dashboard
Hello, i was looking to create a custom Dashboard in Ninox to have a clear overview over some important KPIs and also allow controllers to get a quick view at key data.…
-
Get Previous Month
Hi, Hopefully a simple one. Im editing the body of when the email field is clicked. Whats the syntax to get the previous month. I have tried everything with no luck. Thanks
-
"Join" script function will not show line breaks
I've just started using Ninox. I've set up a database for my contacts with it. The database has two tables: "Contacts" and "Organisations". Contact details that are specific to individuals (eg,…
-
Neuer Editor Auto-Ergänzung ist ein absoluter Sch...
Könnt Ihr bitte diese Autoergänzung abstellen oder zumindest in der nächsten Version einen Ausschalter einbauen? Es macht keinen Spaß mehr Ninox-Anwendungen zu bauen.…
-
How to get a filtered sum() from a table-value, where all have a common category?
I need to get the sum() Formula working that it not only gets me the sum of a specific field of a table, but also a filtered value. Like, all data-entries have a numbervalue and i just want to have…
- Answered
-
while loop stops before reaching end
Hi everyone, I created a button in one table which is to export some values to another table creating new records there. I am using a while loop to create the records.…
-
Disable Duplicate Function
Hello, How can I disable the duplicate record function for one of my team members?
-
Unlink Images from database to reduce the size
I have a database of my client session records which is now over 1 Gb in size mainly due to the images. Each session has multiple images of my handwritten notes.…
-
Multiple Choice Field - How to get possible values/choices
How to get all possible choices of a multiple choice field? With choose() I can get only chosen values, but I need all.