-
Set auto completion on Ninox editor
Hello everyone, I was fed up with always having to close the code editor to fetch the name of a field or table, so I set up the Ninox code editor to have an auto-completion function :…
-
add onselect event for view field
In response to @Alain Fontaine & @Fred Christmas wish (https://forum.ninox.com/t/h7hbkmp?r=h7hbvzj), I have added a viewEvent function to Ninext project.…
-
acces to array items like with Where fonction
Hello to all, This new forum made me want to share something with you
. I chose this code which allows to find elements in a table by filtering as we would do with the Where function of Select.… -
Order by descending
When selecting records you can't specify descending?
-
Character Occurrences Count
Hello, I'm wondering if there's a way to count how many times a given character is in a string. i.e.: I have the field 'mytext' which contains a string (let's say "rockandrollwillneverdie") and I…
- Answered
-
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.…
-
Matching Phone Area Codes to Region
So, for a lot of Data I receive, I don't have any location material besides one's phone area code. I know that the area code is not the most accurate in todays cell-phone age,…
-
import an Image from WEB
This procedure allows you to download an image from a public website and display it in an Image field: Usually, I go through the following steps: Image Field text field labelled in this example…
-
html() function
I uploaded a database named HTML Tricks. So far it only has one example, but I've got some other ideas I've been playing with. If you are interested in a blinking formula field you should give this…
-
POS System ( Sales,Income,Expenses,Stock,Supply)
Hello, I have been working on a POS System all created in Ninox, What I'm trying is that when the sale of 1 product happens (Sales Table) the product is deducted from the Stock table and money added…
-
Ninext : Important information
This message is addressed to all those who use the Ninext project. I regret to announce that the Ninext project will be unusable on Ninox very soon. This should happen at the beginning of February.…
-
Delete Files added to paper clip
I have an archive that I want to BULK delete various images attached to records. I want to keep the records but no longer need the images that are attached to them.…
-
Multi language solutions best practices
Hi again. I don't know if this is the best place for this question, but I will try... Here in Spain, about 70% of our clients sell their products and services in at least 3 languages: Spanish,…
- 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.…
-
Conditional formula to calculate 'taxable' and 'non taxable' items...
Hello, I'm trying to figure out how to include two fields that calculate the sum of taxable and non-taxable items. If you look at the attached image, you'll see that there's a field for the base…
-
Dynamic Reports - my first attempt
Hi there, Here I was thinking it would be straight forward. I have a docx template and in Word I added {d.'PROJECT TITLE'} as a data field (it's spelt correctly, all UPPER).…
- Answered
-
Renaming part of title attachment
I need to assign the rename function to the button "Manuell Nr zuweisen". By clicking on it, an alert field should come out in which you are asked to enter the number you want with a blank field to…
- Answered
-
Complex Select statement for View
Summary of what I need to do: I have a table called Actions within which I am trying to create a view of all actions which are compatible with the current action.…
- Answered
-
Generate QRCode to File or Image field
Following a discussion with @CISOFT Sàrl ,I embedded Sangmin Shim's code in a Ninext function to generate a QRCode on Ninox. The QRCode generates a file on the attached files or in the Image field.…
-
Get count of chosen values from different table
Hello, The formula below counts the number of records in the table Timetable where the choice field Jim has been chosen the value "norm" (it works). count(select Timetable where text(Jim) = "norm")…
- Answered
-
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');…
-
Accessing a single line item on an invoice
I'm trying to pull the TOTAL value of a single line item in an invoice that has 3 line items consisting of £195, £56, and £18. After trying everything I can think of,…
-
A question about Choice and Multiple choice
How to select or unselect all options in a Multiple choice by code in bulk? How to select or deselect options in a Choice by code? I want to use it in "Trigger after update",…
- Answered
-
Need Script for calculating workdays between 1st record, 2nd record, so on.
Ok, Thanks to @Fred I am able to calculate the working days since a previous record for a client. with the following script let t := this; let xBase := ('Clark Leads'.…
-
Fonts, Colors and Borders
Hello, I uploaded an interactive CSS generator database titled "Theme Helper" in the Webinar EN 2021 team. It is very slow to respond online in the browser,…