-
Two fields stuck In the form!
Hi In the form of one of my base I have an issue with two fields. These two fields are side to side and it is impossible to separate them : they are stuck ! If I try to detach one,…
-
Database limits
Hello What are the database limits (if there are). In my Invoices database there are 3800 invoices and 16000 invoice items and many other tables (with fewer records).…
-
display only once names in a list of names ?
Hi Is there a way to display only once names in a list of names ? EG : John John John > >John Peter Peter > > Peter James James James James > > James Thank you
-
Display last 3 records in a table
I would like to display the last three records in a linked table that containes , among other things, dates, actions and task owner. I have figured out how to use the last() function,…
-
DATE CREATED FIELD
Does this exist? I want to sort records by how recently they were created, but the only option seems to be the automatic field "modified on". Am I missing something?…
-
Finding a "lost" database
Ninox Desktop, running on MacOS X. After a crash, I lost (can no longer find) the database I had had open and had been working on for three months (yes, I know,…
-
Issues re-ordering tables in side-bar
Hello, I would like to re-order the tables in the sidebar, but it doesn't seem to be working properly. Some tables can be moved into the desired location,…
-
How to link a table to the values in a “choices” field?
I have a lookup table, it has a list of vendors. In a table of inventory items, I have a choice field called “vendor”. I’d like to populate it’s choices from the vendors table rather than by…
-
If I want to send one of my team a link to a record can I construct a URL?
Ideally, I would like to be able to send a notification (email/slack/etc) to one of my team letting them know about a specific record (e.g. new record or updated record event),…
-
Code erasure
I sure hope this means that all your code isn't wiped out because the compiler doesn't approve... ^^^ That replaced about 480 lines of code in "Global script definitions".…
-
Help ! I removed a field ! Can I restore it
Hi Help ! I removed a field ! Can I restore it ? Thanks.
-
Displaying the number of documents
Hello, Is there a formula for displaying the number of documents stored in the attachment section? Thank you
-
Reference table Child/Master setup
Hi all, I'm trying to create a database that lists document numbers and their application documents. I accomplished this in Access but I was hoping for a more mobile database.…
-
display numbers in ascending order that are in a text field ?
Hi, Is there a way to display numbers in ascending order that are in a text field ? Otherwise how can I copy quickly numbers that are in text fields into number fields ? Thanks
-
Need help with a basic view
I'm having trouble figuring out to construct views. I am used to doing this via SQL. I have a Contacts table with a Products subtable. I want to query all records where the product is of a certain…
-
How do I remove or change a table reference?
When editing a subtable directly, there is a field with option to "search" and fill in the reference to the parent table. Once that field is filled in, how do I change it to point to a different…
-
Issue with reserved space in the form
Hi I try to use what is called "reserved space" to the form of my base. I click on the red key and click on "layout element" I place it where in the window onnthe gear tool.…
-
Issue with reserved space in the form
Hi I try to use what is called "reserved space" to the form of my base. I click on the red key and click on "layout element" I place it where in the window onnthe gear tool.…
-
Fast searching with the alphabet letters
Hi Would it be possible to have a kind of repertoire in Ninox ? EG I search all the names beginning by the letter "j" in a very long list of names. Instead to swipe along the huge list to find it,…
-
Trigger after create - update quantity field on secondary table
I have quite a simple trigger but I'm struggling to get it to work. I have two linked tables, Stock and Sales When a Sales record is created I want the Stock.…
-
Barcode scan inventory number using iOS app
I am using Ninox for managing my artwork inventory. For every new record added I am using a forumla to generate a random number. I print these out as labels to stick on the back of paintings.…
-
How to create a button for opening a file from the local computer
I know, that most probably it's a stupid question, but I can't find out how to set a buton to open a file from the local device. For example C:\Test\test.pdf
-
Check box and formula
Hi - i have a choice box regards to how im to bill a customer 1. to invoice. 2 to deduct from their credit on account. i have built a system so one takes away from another,…
-
Date range and the Ninox Id..
Hi, I have been struggling with the date range and Invoive Id system I created for some time. I have sorted the Invoice system, thanks to Steven and I may have sorted my date field.…
-
Prevent record pop-ups when clicking the view table or a subtable
When clicking on a row of a view table or a subtable, respective record pops. Is it possible and if so - how? - not to have this effect? I.E. clicking on the view table does not do anything.…