Bizarre Results from Filtered Records

Ok, this has never happened to me before and is only occurring with one field. I have a simple choice field called 'Reason'. However, when filtering results by choice ID #,…

Can't get results to exclude a field value of 0.

I am having more difficulty than I should in having this following formula exclude any records that have 0 value in my 'contact attempts' field let curRec := this; let xStart := 'Start Date';…

• Answered

json add array

Hi everyone, i have spend several hours solving this Problem. I have this code: let myURL := ""; let myBearer := (select Einstellungen).'Bexio API-Token'; let contact_id := Kontakt.…

• Answered

How do I filter data in charts?

How can I set the chart view in the "inventory" table to only show "meat" and "bread"? I tried Filter but it only works when I enter one "food name", is there another way? Thank you for your reply.

• Answered

Dialog on Trigger on new record

Am I correct that a Dialog will not work (cloud version) when creating a new record. Example dialog below in case there is something wrong with it. let title := "Serial and/or Bundle Required";…

Find the minimum value in a group of records

Hello Ninox users! I’m completely addicted to Ninox but still young in scripting… so… Does anybody knows how is scripted the formula used to find the min/max/… of records grouped in a category (see…

• Answered

How to modify multiple if statements (I'm not sure if that's the right way to express it).

In the database below I have two key buttons, I will temporarily call the code in "Key1" "if1". Now I need to run the "if2" code after meeting the "if1" condition "avg(test) = 1",…

• Answered

How to use code to edit out unique non-repeating random numbers?

How to use code to edit out unique non-repeating random numbers? Thank you for your reply.

Help with Changing Multiple If Statement to a Case Statement

I need help converting this multiple if statement to a case statement. Withdrawn and Graduated fields are yes/no. if Withdrawn = 0 and Graduated = 0 then let t := 'Enrolled Date';…

About writing conditional code.

I created a formula field in the home table. I set the condition that if the associated item in (copy here) (choose=1), it returns (A: 848); if the associated item in (copy here) (choose=2),…

How can I adjust this?

In the Home table, I selected the Alcohol option. The three charts below show the corresponding values. Starting from the second chart, I added the condition (choose=2).…

• Answered

How do I write the code within the formula?

I want to create a formula in the Orders table that displays "AAAAA" when only Warehouse A is selected in Inventory; displays "BBBBB" when only Warehouse B is selected;…

• Answered

Why is there no response?

I want to display the corresponding data after clicking the button, but 1 and 2 did not work. I verified with code 3 and it is correct. Where is the problem? Thank you for your reply.

• Answered

How can I structure the extraction of inventory data?

I have an inventory database. My products are recorded in two tables based on whether they are opened or unopened. (Unopened: whole boxes; Opened: whole boxes * units).…

• Answered

I have two questions about HTML code.

This is the starting code. <style> th { height: 30px; background-color: #4970FF; color: white; font-size: 28px; } td { background-color: #FE4A49; color: #FAFAFA; font-size: 22px; vertical-align:…

• Answered

transaction or deferred

the query below currently takes almost five minutes (browser) with just 30% of the final data expected. It's okay to wait this long , but I was wondering if anyone has an idea how to tweak its…

Retrieve the data from a button variable

Hello! I have a database in which I have a table "Dashboard" which is the page that displays when I open Ninox and another table "Accounts" containing all the contact details of my customers.…

• Answered

Retrieving the past 14 working days dates

So, I am creating fluid charts on our dashboard. I am having difficulty creating hidden fields that will have the specific #'s to work with. I want these fields to be calculated based on working day…

about the chart display problem.

I want to make my chart (image) to be sorted by value in chart 1 and display name in chart 2. How can I set it up? Thank you for your reply!

Importing Data into a Dynamic Choice Field

I know this was addressed many years back and at the time it did not appear to be a solution. However, has anyone come up with a way to import data into a dynamic choice field when the text being…

Count of records/table per day

Is there a way to count how many entries have the same day in some date field? Eventually, I need to calculate the average of records over several months,…

About the copy problem

I tried to copy the content of "copy" to "copy here", but they are not complete copies. Where is the problem with my code? Thank you for your reply!

• Answered