-
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,…
-
Add elements to a choice field
Hi to all Is there a way to add, edit, delete elements in a choice Field through a formula? ex. Field 1 (formula field) I assign values in a formula: let x := "Napo" let y := "Orso" let z :…
-
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…
-
OPENAPI
I'm trying to write the openapi-api code to import company data from the VAT number. I can't figure out how to tell which value to put in which field. I don't understand anything about API but I'm…
- Answered
-
Mutually exclusive choices
Hello forum, I have an extremely basic question. Imagine a list where each item should be assigned one and only one value. In my experience this ought to be the use case for a "radio button",…
- Answered
-
Show form of combined select (or array) logic
Hello, I want to show something in a form which is a combination of multiple wheres and conditions. I want the entries from table_A which have no value in the field bakery.…
- Answered
-
Newbie Formula Question
I think this is quite basic, but I'm new to all this and still learning! I have a table of contacts and one of the fields is a choice field that lists about 50 or so electoral ridings and I have…
- Answered
-
Carriage Return and Line Feed (CRLF)
Hi there, In Ninox, I want to create a text file for an import into a 3rd party solution. The 3rd party solution requires line breaks to be formatted as carriage return + line feed ("CRLF").…
- Answered
-
Weird switch issue
I'm using the MacOS app, so if I put this in a formula field: switch Number do case Number < 5: 10 case Number > 5: 20 end with Number being a number field in the same table.…
-
Filling Lines of Orders/Articles with Dynamic Multiple Choice Fields And Cascading Dynamic Choice Fields.
In this database you can fill order lines with Dynamic Multiple Choice Fields and Cascading Choice Fields. It is located in the EN Team webinar and is called Cascading DCFields. Steven
-
Auto populate fields with the value from the previous record?
Hi I'm only new to Ninox and setting a database to suit our business. Is it possible to auto populate fields with the value from the previous record? This was a very handy feature in Filemaker.…
-
Is it possible to merge two records in same db?
I have a contact db and wanted to update the records that originate in Google Contacts. I created a csv and mapped the fields, then mapped the fields with identical labels, e.g. First Name, Surname.…
- Answered
-
Need help with my JS/HTML Kanban Board
I've been working on a selfmade Kanban Board in Ninox for some weeks now. I am a beginner and just starting courses + searching for code snippets everywhere.…
-
Button script to select all items in defined Dynamic Multiple Choice field
Contents In a jewelry database, I have a series of Dynamic Multiple Choice fields to identify items and add them to orders/invoices. As an example: Choose Items in Article table with Dynamic…
-
Thoroughly delete image elements with code
I have image elements in a table. I found that using the code "Images:=null" does not completely delete the images. How can I use code to completely delete them?
- Answered
-
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 ,…
-
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
-
Why using a choice field's text does not work in an "if" statement?
Hi all. Using the number next to the choice's text in an "if" statement works. Using the text part does not. Why? Looked in the documentation, the only example I could find does use the number,…
-
Transform Table <-> Page
Leonid Semik has once again delivered a little script masterpiece that can convert a page into a table or a table into a page. Simply create a button in the corresponding table and copy the following…
-
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.…
-
How to Iteratively Add Items to a New Array
I'm new to Ninox (less than a month of use), so if this is common knowledge I apologize. However, I feel compelled to post this because of the incredibly steep learning curve of Ninox.…
-
Beginner: Database for research project - Transition from Excel
Hi, I'd like to use Ninox for my research project to store some information regarding fieldwork (date on which a specific sample was sampled, comments, photos, etc.…
-
New functions
Hello everyone, I put up this post to list all the new undocumented features of Ninox. I started a post here (https://forum.ninox.com/t/g9hs0n7/v3-7-11-new-functions) but its title limits it to…
-
Script not working dilemma
This simple script does not work in a working DB but is 100% in a restore and I cannot figure out why. No fieldnames have been changed, removed etc. The script does not indicate anything is amiss.…
- Answered
-
selecting only first record meeting a criteria
Hi to all! Database tables Masters Reference Events inside a the Events Table I have this formula: let xEvent := Event; let xDate := Date; let x := (select Reference where Date = xDate and Event =…
- Answered