Show value in Choice (dynamic)

Good evening everyone In d table "Mine Table" - "Table1" field "Choice (dynamic)2" need to show table records from "Wendors" - "Name" - "Salary" - "unit" I can't create a formula for the select…

• Answered

Export to excel

Hi, Is it possible to export a table to excel to a specific folder of your choice and execute this with a press of the button. So using code. Tx Regards Michel

Formula for deriving the value

Hello I am attaching a table because it will probably be difficult to explain and will confuse everyone. Everything is done and configured in the table,…

• Answered

Trigger on create with numeric fields

I am creating a table from another table with trigger on create with this code. let a := Factura.Cliente.Cliente; let b := Empresa; let c := Monto let d := Fecha let p := (create Flujo); p.…

• Answered

Dynamic Choice/Multi-Choice

Hello, Is it possible to add a list item to a dynamic choice within the Dynamic Value code section? For example, I have: (select Building where Entity = ent) order by Entity.…

• Answered

Regarding issues with editing the chart code

Hello everyone! Through studying the dashboard template Dashboard Template shared by Sotirios Zormpas, I have learned chart code. The following code already implements the display of accumulated data…

Duplicate a quote a change its number

Hello, I have a quote table. On «Trigger on new record», I have that script: let myLastNumber := last(((select Quote where 'Quote #') order by 'Quote #').…

• Answered

goto another record from calendar

Hi there, have anybody ever tried to jump to a record from calendar where the record I not the one which created the calendar event. I have this situation that I am in a table where I create a…

Print Report Layout

I noticed I cannot access the Print layouts to edit etc. when using the latest Ninox Mac app vers 3.13.6 I have a script that prints out data using the previously built layouts,…

How to write code for data filtering?

How can we filter out the top three salespeople with code? Xiao Ru $382.00 Jiang Ningwei $648.00 Xiao Ru $1,704.00 Jiang Ningwei $2,883.00 Xiao Li $11,760.00 Yang Daibing $4,640.00 Li Yanping $980.…

• Answered

adding eg 7 days to a date+time field

Hi, I just cant figure out how to add days to a date+time field and I couldnt find anything in forum. Lets say eg 15.10.2024, 9:00 date+time field := date(year(date+time), month(date+time),…

• Answered

Delete view tabs

I'm trying to learn how to use Ninox. I'm coming from 20 years of Filemaker. I clicked on the + to create views (Table, Chart, Kanban, etc.). Now I'd like to delete these tabs,…

Dynamic printing and join tables

Hi, I have several join tables set up because I need the many to many relationship. So I have a Programme table that links through a join table to a Staff table for ex.…

• Answered

Android (Chromebook) selecting a record in table view using mouse click issue.

Hi, For some reason I am unable to select a record in some table views when using a mouse the only way is to use TAB to go through records one by one, am I missing something or is this the only way…

View of table sorted by date within groups

I have a table that I want to create a view group my people, sorted by date of records by people and then sliced within each sorted group. I have it working for a specific person but want to process…

• Answered

Enterprise plan

Hi, I just found out that Ninox has a new pricing page. It doesn't say you need at least ten users for the Enterprise plan. Can you buy the Enterprise plan for one user?

Filter by icon in a column

Hi everyone, I'd like to know how can i filter icon in a column. As you can see in my screenshot, i have a column with a formula that returns differents kind of icons.…

Data Model

I have the Mac version of Ninox. I believe something has changed recently as I am unable to find the "Data Model" option. Any help would be appreciated.

• Answered

Create lines for CSV

Hi there has anybody done a transfer from one table to another where one record in the in the main table become 3 or more records in another table - the thing I am trying to solve is that I today has…

• Answered

Photos are way too big

I take photos with a iPhone and put them in my Ninox app. Ever since the update from apple or Ninox, the photos are super big when they are uploaded on Ninox.…

JSON and for loops

Hi all - I was reviewing the set() command and noticed this: for i in response do let new := (create Contacts); for key, value in i.fields do set(new, key, value) end end Look at line 3,…

Fire email field from button

Hello, I have an email field, which is populated this has an email subject and body based on other fields. Is there a way I can create a button on another tab that would fire the normal functionality…

Styled text

Hello How to style text negative positive and zero? there is a formula when there are two values, but you still need to add a text color when there is zero let AA :…

• Answered

Ninox APP update problem

Today I updated my NINOX App to version 3.13.3. The design has changed, but I probably need to get used to it, no complaints here 1 -The columns in the tables disappeared 2 - when saving the changes…

Copy record Id failing

I have the following script on a button. Everything copies over except the record Id. Any ideas on why? The target newInventory.(PurchaseItem := me.Id);, is a number. No errors are apparent.…

• Answered