-
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
-
Ninext : Fields inspector (evaluate the impact of changing/deleting a field before to do)
Hello everyone, Have you ever had a cold sweat before deleting a field in a table ? I always wonder what will happen. And the more my database is important,…
-
All I want for Christmas!
Ninox Support (When you are monitoring this forum - Please pay attention to this Santa Wish List thread. This is what your user base are listing here because we need a few (err probably more that…
- 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…
-
Ninext : Important information
This message is addressed to all those who use the Ninext project. I regret to announce that the Ninext project will be unusable on Ninox very soon. This should happen at the beginning of February.…
-
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…
-
Ninox names vs user names
Is it possible to access a list of the Ninox element names used for the User defined names? I inadvertently deleted a link to a table 'Projects' which Ninox has 'CA'.…
- Answered
-
Thoughts on a DB redesign
Hi all - So I've been developing my team show jumping DB the last few years quite organically. I knew almost nothing about setting up a DB when I started and had zero knowledge of DB coding.…
-
Multi language solutions best practices
Hi again. I don't know if this is the best place for this question, but I will try... Here in Spain, about 70% of our clients sell their products and services in at least 3 languages: Spanish,…
- Answered
-
Renaming part of title attachment
I need to assign the rename function to the button "Manuell Nr zuweisen". By clicking on it, an alert field should come out in which you are asked to enter the number you want with a blank field to…
- Answered
-
Using triggers for yes/no field
I have tried using the visual part of the Ninox formula and various forms of this text in the script writing, all to no avail. if Status = ("Closed" or "Expired") and 'Campaign Premium' > 0 then…
- Answered
-
Dynamic combobox/dropdown list
Sorry in advance if this has been solved before. I'm trying to create a table with a couple dynamic comboboxes. If option 1 is selected for combobox 1, then only options 1 to 6 will be available in…
-
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,…
-
Linking tables after importing from database
I have imported several tables via CSV and would like to link them afterwards. I have a unique ID (company name) which I could use as a link. How can I link tables that were already linked in another…
-
Relationship between 2 tables - how to?
Hi I'm a musical director with a choir. I need to track which songs are going to be sung at each rehearsal. So I have created a table with all the songs:…
-
NEWBIE - CONFIGURING ONE-TO-ONE AND AUTO UPDATING
AFFILIATED GMRS REPEATERS USERS DATABASE DESIGN NOTES FOR NET CHECK-INS September, 2023 Software: Ninox – v 3.9.3 downloaded free from Apple App Store, single computer only.…
-
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:…
-
Reset line id to 1 with new invoice
2 Tabels: INVOICE and LINE ITEMS. Goal: Each row in LINE ITEMS to have an serial number that starts at 1 with each new INVOICE
-
Automated Multiple Choice: Is it possible?
Is it possible to automate Multiple Choice field based on trigger/update from another fields – which is two or more fields. See situation below: Multiple Choice (MC):…
- Answered
-
Formula ID count also deleted records
Good morning everyone, I have a formula field with ID in it. This shows me the record number. My problem is that I have noticed that this formula also counts me the record ID's that have been deleted.…
- Answered
-
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
-
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
-
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.…
-
Print report with Multiple choice....how!
This screen shot is pretty much how I would like my report to look: There are three multiple choice fields. When I print this, I get a concat of the choice fields but what I am hoping to achieve is a…
-
Sub-Tables - Add existing record
Has something changed with the new version (3.7.6) with regards to sub-tables? When a table has a sub-table linked to it there are now two buttons on the sub-table to "Add existing record" and…
- Answered