-
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.
-
Calculate integer from decimal value
Hello, For a calculation I need to know the integer part of a decimal value, ie. 34.25 would give me 34 as the integer part. I expected to see a trunc() (or similar) function in the Ninox logic set,…
- Answered
-
List field content using rsort()
I'm trying to print a list of all entries in a given field between two specified dates. With the precious help of other posts in this forum I managed to get the list but it still brings up all the…
-
Customized button
Hello everybody, I added the buttonEvent to Ninext. This allows to dynamically change the caption, the color and the help title of a button. Just add the onUpdate function in the "Display field only,…
-
Automatically Displaying referenced data based on String
Hello, I'm sorry if this is a dumb question but I can't seem to figure it out. I'm attempting to use Ninox to help organize summer camps. Based on already imported data,…
-
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…
-
Da numeri a lettere
Mi serviva una funzione per stampare delle ricevute in cifre ed in lettere così anche se non sono un esperto ho scritto una funzione che può essere utile a tutti.…
-
Improve performance: Save Calculated values in Static fields
Views of the tables can sometimes take longer to be displayed due to the functions which are calculating the values. Formula fields have to be calculated every time the view is opened.…
-
Create records from dynamic multiple choice
Hi guys, I hit a bump trying something new: I have a dynamic multiple choice field called 'Keuze kritieke fases' I have a subtable 'Kritieke fases'. I have a button that I gave following code on…
-
number() function stops convert strings with letters
Hello, I think that function number(), was converting strings like "XX23" to number 23... I've used it lot to convert record id to number for function record(Table,number(id)) .…
-
New 3.6 Script Editor
Is there a way of turning off the auto-complete function in the new 3.6 script editor? If I want 2x " (double-quotes) or a pair of braces () or {} then it assumes I always want a pair.…
-
Display linked records within the according table view
If you have a main record with several linked records (e.g. record of a contact/customer with a list of linked invoices) and you want to access those directly in the according table view,…
-
Switch Case statement in Ninox
Another great structure in Ninox that can help you in the automatization of your processes is a Switch Case statement. Simple syntax, fewer lines of code, and faster result in your app.…
-
How to "scan" a table?
If I want to loop through all records in a table, how do I do that? I don't see a way to create an independent script I can call. So, even within a button,…
-
Weird switch issue
I'm using the MacOS app, so if I put this in a formula field: switch Number do case Number < 5: 10 case Number > 5: 20 end with Number being a number field in the same table.…
-
Improve performance: Count records from subtable WITHOUT select statement
If you are counting records from a subtable, you can avoid using the 'select' statements... For example: Instead of using the code: let t := this; count(select Invoice where Customer = t and Status…
-
Private Function to Check Empty Fields on Button Click
Hi, Is it possible to create a function and pass it an array of fields to check if any of them are empty? My example is that I want to send a send a task to outlook using integromat,…
-
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
-
How to action a trigger after form close?
Hi, am wondering how can i action the update trigger after i close the edit window? What is happening it keeps on sending numerous notifications on every field i update which is cumbersome.…
-
How to query a table using a dynamic combo box value?
I have the code below, i want to return the email address where the the full name of the staff is the one assigned to the ticket. let i := 'Assigned To';…
- Answered
-
Passing data from a Text field or MultipleChoice field to a DynamicMultipleChoice field
If you have a MultipleChoice field, and want to pass the same chosen options to a DynamicMultipleChoice field, follow the steps below: - Create a new reference table with the options written exactly…
-
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.…
-
How to select a row from a composition table to display in a superform
I am new to Ninox and am struggling a little with programmatically searching records - the equivalent of SQL-world Select statements) . I have many years of relational database experience in…
- Answered
-
Seek help to find array position number in a array loop
Hello, This is my first post, so please bear with me if the formatting and my wording dont make senese.... I am creating a genealogy database just for the fun of it,…
-
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