Search and Filter

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…

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

Auto-populate pricing from another table?

Ok Ninox wizards, now I'm trying to auto-populate some pricing and job details. Here are the top level details: Main table is 'Job Status Log' which has 100s of job entries that are connected to my...…

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…

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:…

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

Sum service amounts from three tables based on dates

Hello. I pay my employees weekly based on how much they bring in for services, products and off-site events (three separate tables) throughout the week. I am using a date field.…

• Answered

clearing the Filter option in a column on closing a view

As you can see there is an applied filter to PROJECT in this screenshot. Is there a way to reset all filters that might be applied when a view is closed.…

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…

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.…

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

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…

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:…

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…

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

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

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

Auto-populate tax depending on another dropdown field selection?

I'm wondering if it's possible to tell Ninox to apply tax based on my 'job type' dropdown field? For example, if I pick 'shipping' that would be taxable,…

double click in a cell puzzle.

Can someone enlighten me please. double click to edit a cell content is not possible in all cases. Sometimes when I try the form slides in from the right on the first click.…

• Answered

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…

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 ,…

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.…