Records filtered by Dynamic Multiple Choice

So, I have many fields that are dynamic "single" choice. My goal is to filter data using a multiple choice dynamic field but am having issues with scripting it correctly.…

• 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

Avoid delate table

Hello, with the edit mode disabled, how can avoid to delate a table? Thanks.

Warning on button coding: "Field must return dynamic values..."

Hi there! After some trial and error, I came out with this coding that works as expected but I can't get rid of the warning sign saying: Field must return dynamic values...…

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

Trigger after update & Alert anomaly

Community - I developed a database in the Mac app. The database is deployed on the web. There are 2 fields in a table that have code entered into the 'Trigger after update field'.…

Select only the Phases to Audit  by the Area Audit: Multiple Choice Dyn

@Fed In the table AUDIT I define the Audit #, Date Audit, etc... and the Area to Audit (Multiple Choice dynamic) then click on ADD to Audit and then update the Table Audit Plan,…

• Answered

Dropdown menu on database icon not working

The dropdown menu on the upper right corner of the database icon at the Ninox home screen (showing rename, and other functions) doesn't work since update 3.11.5 update (Mac desktop version).…

Manual sorting view?

Is there a manual sorting view? One that stays the same until you drag and drop records up/down? If not that's feature request.

Date format in formula

I am trying to set up a multiple conditional if statement. Having trouble figuring out how to put a date for the script to check against. Here is my code.…

• Answered

Need the Diferent Between Two dates, Without Weekend and Holidays

I have Two days example 4/Mar/2024 and 11/Apr/2025 need the days wiithout Weekend and Holiday. I have define the table Holidays.

• Answered

About signature Questions

How to copy the images in the (signature) field of table A to the (Image) field of table B? What should the code look like, thank you for your reply.

• Answered

print view

How can I print view without subtable

Duplicar archivo

Buenas tardes, al darle a duplicar archivo te tienes que salir de la base y meterte para verlo. Me pasa desde hoy. Tengo archivos que duplico y edito pocas cosas pero ahora sale mal.

join with conditions

i want a formula where i join a table to a text file, this i allready got working, but i want a condition where in the table i line is called "eis" i want a text with all the line with "eis" and a…

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

Distribute dates between two others days.

@Fred I have the fields Plan 1 to Plan 5 with the following milestones 10%,25%,70%,90% and 100% in the Plan 1 date field I have the start date 8/02/2024 and in the Plan 5 date field I have the date…

• 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

Create record in another table on a switch

Hi all, Bear with me as I'm a new user and don't have any tech / db-skills. If the answer to my question is in another post, please show me a link. I've tried to search the topics,…

Find in View (Today, Last Week 5 days, Last Month, Last Six Month and Year.)

Need a script that find the info by (Today, Last Week 5 days, Last Month, Last Six Month and Year.) Somebody helpme.

• Answered

Scaling up - multiple users

Hi, What happens if we use Ninox to build a field app, and then need each employee (up to 25) to use it to enter information? Basically i cant afford each user to pay a licence,…