-
Normalising existing data
I've imported a spreadsheet to a table and now want to normalise it. In SQL I would have done a 'select distinct' on a given field to generate the list of values,…
-
Conditional Formatting at a stretch using a Filter
Sometimes I miss the filter funnel in the header which throws me when I know there are more records than I see. Especially if the column being filtered is off to the right out of sight so to speak.…
-
Creating a Button That Goes to Table with only Linked Records
I have been searching endlessly and can't find the correct formula. I want to create a button that when you click on it, it will display the child table but only the linked records to that specific…
-
syntax problems
Hi everybody, I'm hoping that the power of the community could help me out, I've found myself stuck and cannot find the solution to a problem. First some background information:…
-
Production: should storage tanks share a table or each have their own?
I need some advice regarding the basic logical layout/relationships of my database. I'm tracking production and inventory in a distillery. I have a table for distillations,…
- Answered
-
POS System ( Sales,Income,Expenses,Stock,Supply)
Hello, I have been working on a POS System all created in Ninox, What I'm trying is that when the sale of 1 product happens (Sales Table) the product is deducted from the Stock table and money added…
-
Understanding file attachment strategies
I have a few use cases that involve managing inventory items - like my photography and RV equipment. I want to link a variable number of pdf/photos/other (e.g.…
-
How to select a row from a composition table to display in a superform
I am new to Ninox and am struggling a little with programmatically searching records - the equivalent of SQL-world Select statements) . I have many years of relational database experience in…
- Answered
-
Design Table for WBS
Hi One consultan, I have a Database with some tables, ones of them are correspond with the structure of the project WBS Work Breakdown Structure I have four level.…
- Answered
-
Convert table to subtable
I would like to turn a table (B) into a subtable of Table A. Table B provides reference to A already. Many thanks in advance.
- Answered
-
Transferring Filemaker relationship
Hi, I'm transferring some FileMaker Pro database to Ninox and I can't find how to recreate the relationship. In Filemaker, relationship are built out of existing field,…
-
How to import data from text field to dynamic choice field
I am importing data from a CSV made from an older table. The old table had 'Patient Name' as a text field and the new table I am importing it into is a dynamic choice field.…