Is it possible to add a condition at the beginning of the table?

I am using concat here to display the data from (invoiceitems.‘1 or 2’). Is it possible to use conditional statements in the code, for example: if it returns 1, then display 0; otherwise,…

• Answered

Forumla Conversion

Hello, I have a subtable which has some fields that does some calculations (see screenshot). The profit field is worked out on Project Cost Quoted - Project Time Cost,…

Regarding the issue of matching records after splitting the data.

I have created three tables: "product," "invoice," and "Create." In the "Create" table, I have set up a button. I want to quickly create orders by clicking the button.…

• Answered

Regarding the issue of storage space.

Hello everyone, regarding the database size of Subscriptions, what are the impacts? My database download is only around 1M, but it is already showing that it has occupied 4GB of storage space.…

• Answered

Sudden change in screen layout.

I don't have a version update as far as I can see - 3.12.7 is what I have now but this morning when I loaded my APP everything is messed up UI wise. Anyone else have this happen or do I need to…

Script Error on line 15

#{ Get the selected categories from the Choice (dynamic) field 'Categories' in the Control HH table }#; let selectedCategories := Categories; #{ Start an empty list to store the associated Rates to…

• Answered

Argument with Ninox AI and reference field

Hi, I'm new to Ninox and the AI option is just an amazing lifeline I have an argument with Ninox AI that asks to establish a "Reference Field" when I am supposed to open from the attached…

Is there another way to display the filtered data?

I want to display the data according to the SHOW in HOME, but I can't sort it by the number of repetitions in descending order. Is there a way to use Functions to display it?

• Answered

Buttons in Tables View (Ansicht) needed

I need to have the possibility to have few buttons in the view of tables, because i want to have a list of different Students and then have a button for each day and if i press a button,…

The script don't work

" Variable 'Categories_>' is n:1 relationship "; let catg := 'Categories_>'; let rate := (select Categories where Category = catg).Rate; 'Rate by Categ' = rate I try once choose the 'Categories_>'…

Dynamic choice (programatically selected)

Hi All, My doctor only wants to see the items that are relevant to an appointment. Items is a dynamic choice field. I am able to find out the items that he can't charge for that appointment,…

Active Multiple Choice (dynamic)

There are any way to active MCd when enter data on field. Example When enter data in T4 check T4 on MCd and the same on ther others P7,P6,P3. Thanks

How to formulate a multiple if/then/else statement?

I’m trying to formulate a logical function that depends on a “Choice” field. If ChoiceType =1, then I want to display the result of Formula_1 If ChoiceType =2,…

If condition not working with comparison operators

Hi, I have got a headache trying to understand why can Ninox scripting engine comprehend such a simple If condition together with "and" and "or" operators: let currentDate := today();…

• Answered

Questions about loop code...

let aa := this; let mois := ["January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December"]; let sommes := [];…

• Answered

Way to Assign multiples fields to another table.

Hi. Attach a Dummy DB. Table 'Hours by Resources' and table 'Documents' It is necessary to assign each categorie for each document. Each document can have several categories.…

• Answered

(JSON) Object parser Browser vs. Client

I am despairing of what I would call a bug. I have a function (global) that works fine in the browser, but fails in the app and breaks the entire global script.…

• Answered

Populate a choice list with values based on a selected value from lookup

Hello friends, I am trying to build a Sales module in Ninox. My Setup (Database is attached): 1. Clients table with a subtable called 'Client Contacts' 2.…

• Answered

loop in query for view -- how to aggregate?

I use the below formula for a view and a dMC. Yet, it will only return the last record i, not all of them. When I create a button to alert all i, it will prove the loop works correctly.…

Still no field alignment options?

I guess I got distracted by life and didn't notice this until now. Am I missing Left, Right & Center alignment options?

Storing array in a table column

Hello friends, I am new to Ninox and learning to get acquainted to it. I have a Parent/Child tables setup (Products and 'Product Details'). In the Products table I have T-shirt types (Round Neck for…

I encountered a very strange problem.....

I encountered a very strange problem. I set up a table in one of my databases, and the code is as follows: let Table := (select 'Procurement').--- <tr onclick="ui.…

Regarding the issue of popping up another table record from a table...

I set a button in table1 to jump to the first record of table2, but there seems to be an error. Where could the problem be? Thank you for your help.

• Answered

A question about writing HTML code.

I have two pieces of code. I want to write the table data from code one into code two while retaining the style of code two. How should I write the code?Their structures are different,…

Help Needed: Error: Database Connection Failed on Ninox

Hi everyone, I have migrated my complete data from Salesforce and imported it successfully, yesterday it was working fine, but right now, I'm encountering an error while trying to connect to my Ninox…