-
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…
-
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,…
-
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
-
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
-
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.…
-
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
-
ARGGHHHH! New 3.8 Cloud version
Cannot get into "Trigger Before Open" - anyone else have that issue. Left the Ninext script in and now the "Trigger Before Open" will not open to allow me to delete it.
- Answered
-
Build a Report Advice
Ok, I want to create a Form within my Ninox CRM that will allow a user to select pre-defined reports, click a button, and then than upon click it will create a new record for that corresponding…
-
QR Code management
Hello everyone. I would like to start managing QR Codes in my database. I saw on the forum that creating a QR Code is actually quite simple. “It is enough”, in summary,…
-
A trip down memory lane
I found an archive of my DB from April of 2020. Here is the data model: I had some idea of relationships. What I didn't know was not to try to do stats in your table views.…
-
User Roles/Security
I am working through my database setting up roles etc. Doing the basics first and I have created a user/member (me under different credentials) as Editor only.…
-
Those pesky hidden fields....
So for folks who hide fields that are only for designers, admin...those yes/no, lock fields and that sort of thing that you need to get to but cannot recall where on the form they are or need to get…
-
Dynamic Multiple and Choice fields help
I need to set up a commission check list system for equipment and it seems to me the best way to do this is with Dynamic type choice fields. To give an example:…
-
Copy "text" field contents into "Choice" field?
Hi all. (Real newbie question) Searched, found two answers which I don't understand, so here goes: I already have a database, populated with records. I'd like to take the contents of a "Text" field…
- Answered
-
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.…
-
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…
-
How to merge columns together while merging unique cells & offsetting same cells
Hello Ninox community, I'm new to Ninox, a crm that I honestly never heard of before until half a month ago. I've primarily worked on salesforceDC and homebrew crms, so any help is appreciated.…
-
Why does NINOX recommend entering data from a form?
Hi everybody. Really struggling, trying to understand views, tables vs forms, relationships, parent-child, etc. So on a Friday afternoon where the stock market has been very kind to me (well... the U.…
-
Top left Global search
I never use the Global Search top left because it really does need some refinement by Messrs Ninox before it really comes into its own. For one users need to be able to choose columns.…
-
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
-
Problems with condition statement in a while do structure
Hi there! Hope you can help me out with this: So, I'm building a Many-to-Many relationship between two tables, one for journal entries ("Asientos por Registrar") and another for Vendor Invoices…
-
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.…
-
Bulk search for LinkedIn profiles and get clean data with: title, first name, middle Name, last name, suffix, job title, name company
Easy search for LinkedIn profiles and add them to your CRM into Ninox. Join it to your CRM. From this: To the end result: https://html.duckduckgo.com/html/?q=linkedin.…
-
Global Search Column Customisability
Does anybody know whether it is possible to customise the columns which show when you perform a global search? It seems bizarre if this has not yet been implemented,…