-
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.… -
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,…
-
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.…
-
Custom Widgets (Release 1.0)
Dear Ninox Community! Many of you have asked how you can easily and cost-effectively use our Custom Widgets in your Ninox databases. The time has finally come
We have worked hard to find a…
-
Where does the cat sleep (find the closest sentence)?
I had a somewhat unique case where I needed to import data with sentences indicating where to store them, but sometimes the sentences were not all spelled correctly.…
-
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…
-
How to pop up a dialog if a record in a table meets a criteria.
I have a table with three records each with a specific date in a field called next date. I am trying to use the trigger after open function to allow a dialog to pop up when the date in the next date…
-
Rest Api filtering documentation
Hi forum, I'm missing the filter docs? I see examples of how to filter and I get a sense of what is possible. But where is it described? Or am i just not that bright :…
-
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 filter fields from a linked table
I have a "Project" table and is linked to a "Contact" table. Inside "Contact" table I have a "Class" choice field and "Name" text field. On the Project table I'm able to see all contacts and I would…
-
Exporting all data
I have a table with a lot of columns and i want to export it to CSV. I can only export visible data, is it possible to export all columns (visible and hidden) or any way to make all columns visible…
-
Using Ninox ChatGPT to create a search
Hi, My first shot at creating a button to search a field (RTF) to find and mark results. I have a field SEARCH for the search terms and the RTF field is NOTES.…
- Answered
-
Using the Filter option
Is it possible to filter a field based on criteria in another field. eg: Field 1 Serial Required is 'Yes/No' Field 2 Serial Number is 'nnnnnnn' In Field 2 Filter: Field 1 = Yes
-
Selecting Product Items based on Product
Hello@Fred I have a Reference field where I select the main Product from Products table. Product Items is a child table of Products. I have added a button (Update Records) and a new column (Product…
-
Search formula fields in another table
Buenos dias, tengo una tabla (Medidas) en la cual tengo 50 campos numericos y 50 campos de formula, en los campos de formula tengo esta formula, si Pos1 >= 0 y Pos1 <= 6000 entonces styled("REPLACE",…
- Answered
-
Formulae in Global Search
@Jacques TUR Is it at all possible to work your magic so that based on user wishes formula fields can be excluded from the view that result from a global search? Example:…
-
Merge visible PDF in one file
I have a table named "Allegati". Inside it, there's a field called "File" which contains a PDF. In another table called "DOC FIERA", I have created a reference to "Allegati" in such a way that if a…
-
An idea for a Ninext tweak.
@Jacques TUR Would this be possible? To have a tooltip concept when hovering over a cell that displays the full content of that cell. This could be handy where cell width is reduced,…
- Answered
-
Displaying Data in View by Dates
Hello, I don't know if anyone can help, but I assume this is quite a simple task for the more advanced users, I am trying to display data in a table view,…
- Answered
-
show only relevant table columns based on two criteria
Objective Map relevant terms, people, and institutions to respective slides. Hurdles Show appropriate table columns based on source/target language. Hey Ninox Experts, Hey@Fred /@Jacques TUR ,…
-
Search field doesn’t recognise apostrophe…
I have a database with song titles, and have noticed that titles that include apostrophes do not show up in a search… For example ‘Don’t Go’ will not show up when I search for the word:…
-
conditional unique() in column
my view should select all records in elements where the column "text" is unique for one label (being a linked record). So text "a" might appear both for label1 and label2,…
- Answered
-
Need Assistance with Creating a Search Button and Displaying Results in a Table
Hello Ninox community, I am an IT professional assisting my wife, who is a real estate agent, in utilizing the Ninox platform. We have just discovered this tools few days ago.…
-
Search and select the most similar text
Hi, I need help to search and select a supplier in a table when I select a reference in another tab. I have 3 tables: one for suppliers one that acts as a register one for imports from another…
-
For the question of using N:1 search
When searching for the same content in the same database, there is data returned on the MAC port, but no data is returned on the web port. how are the search keywords defined?
- Answered