-
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),…
-
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.…
-
Delay field update for zapier integration
Hi there, When a certain stage of a form is reach I have a zap going to zapier for further actions. This is all working fine. However when the same field is edited in any way the zap wants to fire…
Answer questions and share your knowledge