-
Global Search Column Customisability
Does anybody know whether it is possible to customise the columns which show when you perform a global search? It seems bizarre if this has not yet been implemented,…
-
Ninox API issue
Below am able to query the records But while trying to use `where` am getting `null` why ? ``` { "query" : "(select 'Klant_Client' where 'Skinvision_Customer_Id' = 'FX0000000108_412').…
-
Select result if more then one - Rest API
Hi, I have an API-Code in Ninox let auth := { Authorization: "Bearer TOKENNR", 'Content-Type': "application/json" }; let Paiva := 'Inserisci p.iva (solo nr) o cod.fisc.…
-
Proper Syntax for counting any combination in a multiple choice field that includes at least one selection.
I have been trying all sorts of syntax along with using +, and, or to no avail. Here is my formula. let xStart := 'Start Date'; let xEnd := 'End Date'; count((select Chronos)['Date + Time' >= xStart…
-
Wrong ID in Multiple Choice?
I have a multiple choice field where I write a Note, and then assign it a Note Type. I'm trying to make a view where I can see what the Note is for ones that are "Issues".…
- Answered
-
Highlighting entries in table A that are selected as reference link in other tables.
I have a table of many contacts, and various other tables (applications, log, opportunities). Each of these tables have a reference column to contacts (akin to the example in the CRM Template…
-
How to create a unique list of records
Let us say I have a table, Table1, with records that store years in a field called Number. Now I want to create a dynamic Choice field in Table2 that shows the unique years that are in Table1.…
-
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 .…
-
Conditional Formatting at a stretch using a Filter
Sometimes I miss the filter funnel in the header which throws me when I know there are more records than I see. Especially if the column being filtered is off to the right out of sight so to speak.…
-
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.…
-
syntax problems
Hi everybody, I'm hoping that the power of the community could help me out, I've found myself stuck and cannot find the solution to a problem. First some background information:…
-
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…
-
Targeted deletion of records in tables
Table management is an important task in keeping your database clean and running by avoiding redundancies, accidental double entries, etc. While you could open every record in question and delete…
-
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
-
Operators for searching one/several texts in the field filter (Boolean)
From time to time you need to search for several texts in a table column at the same time or you want to exclude certain texts from the search. To do this,…
-
In Forms, search for string only returns one record
When I search for a record in a form, the search string is either not found or only one record is shown when the string should be found in multiple records.…
-
Look up value in table based on two other values
I'm new to Ninox and am trying to set up a database for a distillery's production records. One thing I need to accomplish is a formula that can look up a value in another table based on two inputs.…
- Answered