-
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
-
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.…
-
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.…
-
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:…
-
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…
-
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…
-
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.…
-
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,…
-
video or detailed feature list for the 3.10 release
Does anyone have a link to either a webinar or a feature list for the new 3.10 release on private cloud. I am going to be motivating a client to go 3.10 and would like to be as fully armed as…
-
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
-
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
-
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…
-
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
-
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,…
-
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
-
displaying map/location in iframe in Ninox.
Is there a sample DB that has an iframe that shows Google Maps of a location field in Ninox? If not can anyone help with a solution? In other words once a location is found a formula field displays…
- Answered
-
Laptop vs iPad
Hi, I have a database with code. When I perform a certain action (processing and saving) it takes about 4 seconds on my laptop and less than a second on my iPad.…
-
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.…
-
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
-
Unlink composition records
Would love if there was a way to unlink composition records without deleting the entire thing or changing the table to not be a composition just to unlink.
-
Go to a specific record
Hi! I have 4 tables: TAB1 with the respective sub-table TAB4 TAB2 with the respective sub-table TAB3 Through the links I start from the N record in TAB1,…
- 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
-
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:…
-
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…