-
Using a Dynamic multiple choice field to filter a dynamic choice list
I'm searching the forum but there is no correct answer to my question (or maybe is nested in a very crowded forum). I have a Dynamic multiple choice field (Country) with a list of countries.…
-
Delete a record and related records in other tables
I have a table named « Accounts » which is the main table where I add all my customers. From the Accounts table, I created a Yes/No field which has the mission of deleting the selected account…
-
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…
-
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.…
-
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…
-
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
-
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