-
Where to write a global function
I have to make a calculation: Total = Qty * price -/- discount.I know i can make the Total a calculated field but you don't need to fill the price or discount.…
-
Change the default file name when using Print PDF
Hi, When I click Print PDF I get the the file downloaded with the name stuctured as follows: [TABLENAME][ID] Is it possible to chnage this so it uses a different name structure such as:…
-
Converting min/mile
Is there a formula in Ninox that can convert a time of say "32:14" for 2 miles into Min:Sec per mile? In other words, I don't want 15.50 min/mile, rather I which to generate a text of "15:…
-
Button to local folder
Is it possible to use a button that will take you to a folder located on your computer
-
TEXT SIZE IN RICH TEXT FIELDS
When I paste or type copy into a RTF the font size comes out very small. Is there any way to assign font sizes to paragraph text and header levels (H1, H2)?
-
How does Ninox support traditional database type 'forms'.
I have three tables. Flashcards, Tags, and a many-to-many join table called Cards_Tags. I need to create a form so that non-computer type members can add/modify a flashcard and, at the same time,…
-
sum values for a specific data
Hello everyone, I've tried figuring this out by myself and searching in the forum, but with no luck. I'm trying to replicate the Excel 'SUM.IF'. I've a table (Table_A) with 2 columns:…
-
Issues Select Where function
Good morning, In order to avoid duplicating SO# in a table, i am trying to search the Sales Order table for any record with the same SO# upon creation of the record.…
-
Form disappears with Escape key
When I'm in a form e.g. Invoice Form and hit escape key the content disappears. Is this a bug or a feature I'm on Ninox Mac App
-
Can I open and use two databases at the same time?
I created a database for keeping track and billing my time. I created a second database to keep track of certain referrals and cases that come into my office.…
-
Help with SELECT query needed!
Hello, guys!this task is too much for me, and i ask your help please!! I got 3 tables that are joined as 1:N as shown. Patients Visits Treatments As you can see, every patient can have various visits,…
-
Use of a variable following a Select statement
Using a script as follows: let myAccount := text(Account);let myCategory := text(Category);let myYear := number(text(Year));let myMonthIndex := monthIndex(text(Month));…
-
Examples using SELECT
I’m a high school Economics teacher and I’m trying to create a simple bank system to teach my students how to manage their finances. I’ve successfully created a database that will update a running…
-
Order by descending
When selecting records you can't specify descending?
-
create a new record in subtable
Hello,I have an invoice table and a sub-table for the invoice items. I'd like with a button to reproduce the same behavior as when I create a new item when I'm on a record of the sub-table.…
-
Printing multiple forms
I have magazine content (text) that's spread over 15 records (one record for each item). I want to make it easy for my graphic designer to lift the text.…
-
What are all the parameters I can use when sending an email in Ninox?
I know you can set the subjct, the body (HTML) Is there a way to set priority? Set CC/BCC, attach MULTIPLE FILES (if so how?), set the reply to a different email, change the name of the sender?…
-
Changing the global unique Ninox ID
I am transferring from Filemaker to Ninox. In Filemaker I used the unique ID to generate another ID, which I use to identify my artwork (e.g. ArtID 50240 which came from the unique ID 240 + 50000).…
-
Expression to check if empty field
In an expression, I need to determine whether or not there is anything on a particular text field. When I try that, using the example below, the result is always True.…
-
Duplicating records - Keep some data and clear/reset other data
I want to be able to duplicate a record, but only keep some of the data in some of the fields (all sorts of field types). I'm using these records as templates,…
-
Date Field Question.
Is there a fast way to enter a date? The best I have found so far is jan12001. I would like it if I could enter it like 1/1/01. Also, can the date format be changed to show as 1.1.01 instead of this?
-
Table and Subtable
Hi, using ninox I discovered that deleting a subtable it becomes a table, is it possible to reverse it? Or is it possible to transform an existing table in a subtable? Many thanks, Max
-
how can i automatically link two fields from two tables?
I have two Excel files. I imported them into Ninox, in one database. Each Excel is one table. Each table contains approx. 1.000 records. Both tables contain one similar field, called: ParticipantID.…
-
How do you copy or move a record?
I need to move some records from one table into a different table, but I cannot find a way to do this. In most database programs, you can cut some records from one table, then paste them into another.…
-
sub-table
I'm a new user of Ninox and am learing to use it. I don't undersatnd what a "Sub-Table" is or how it's used. I'd be apprecitive if somebody could answer the question or direct to a source of…
Answer questions and share your knowledge