zenmom
-
Need help with filters
Filters are relatively easy to understand, at least the simple version. But I've run into trouble backing out of a set of filters. I had some filters on one of my table to see a subset,…
-
What is the syntax for operations between fields in different tables?
Dear Collective Wisdom, I want to perform an arithmetic operation between two different fields. I would think that would be fairly straightforward: [field A] + [field B], or in my particular case,…
-
Date functions & calculations
Next question! I've got a situation where I want to indicate when a regular payment or bill happens. Sometimes ths can be framed as "the 2nd Wednesday of each month" and sometimes as "the 1st (15th,…
-
Sorting?
I'm baffled & could use some help. I've learned how to filter records by clicking on the header in a table. And can sort ascending or descending. But I can't figure out how to construct a (relatively…
-
Date calculation
I'm working using the date functions. I've been able to use them to calculate a date at [specified date]+1 year, or +1 month, or +1 day ("1" =N in these cases).…
-
Charts from more than one table?
Is it possible to produce a chart that is line charts from several different tables overlaid on top of each other? I want to show a line that's daily bank balances,…
-
Don't see the chart icon
I'm running Ninox locally on my iMac. I have a simple table displayed, which consists of dollar amounts (number field) and dates (date field). I'd like to see the data as a chart,…
-
Question about subtables
First, let me say that although I understand various relational database concepts, I'm a long way from being an expert user. There is no such thing as oversimplification when describing something to…
-
Display two tables at once?
One other question for today... Is there any way to display two different tables, in table view, on the screen at the same time? I want to visually compare some of the data between two tables,…
-
Table relationships, data model
Very new Ninox user here, used to use FileMaker long ago. I'm trying to learn how to create relationships between tables. I tried creating a relationship between two tables (in the same database),…
-
Can't find the field width control
I'm new to Ninox. So far, so good, but I've got lots of "how do you ...?" questions. Today's question is this: In the User Manual, Section 5. Tables, 5.…