-
Would like to link a record in my table to other records in the same table
Is there a straightforward way to create a link from one record in a table to several other records in the same table? Would appreociate some guidance or links to documents that describe this. Thanks!
-
must you buy a subscription
Must i buy subscription
-
jordimeca
hola soy jordi de barcelona
-
Get the id of a user that created a record
Hi, I would like to get the informations about the id who created a record and the informations about the last id who modified the record. I already checked in the manual but the functions don't…
-
Printing Labels
Until you can print labels on Ninox, is there a way to print labels with a 3rd party add-on using Zapier or Integromat?
-
How do I include a date field in a file name using "importFile" command?
I have a button on my form that when pressed, generates a new pdf file with a specific filename using information entered into the form. I almost have it how I want it,…
-
Filter not working for Formula
I've added a field to a table view. It simply counts the number of attachments for each record: count(files(this)) Next, I add a filter to that column: =0 I still see all records,…
-
Links allow multiple choices
Hey. So I'm not even sure how to describe my problem properly. But here's what I'm trying to do. I have events table created in my database and I would like to assign items from another table to that…
-
Command for Read Only
What code can I use to make a particular text field become Read Only when clicking on a button? Thank you. Kevin
-
People to Invite
Hi Sir / Mdm Just to check with you. On this Ninox, I would like to know how many people I can invite
-
Is there a way to automatically create multiple records from a button?
I have a database I use to maintain a small budget for a coffee club (32 menmbers). I have a members table, income table and an expense table with a invoice subtable.…
-
Link records in 2 tables
Hi, I have two tables: Table 1 is called "Checks" and table 2 is called "Customers".The relationship between the two tables is N to 1. The two tables share a field called "codclt".…
-
Limit number of records in a subtable
Hi, I have a table Suscripciones and a subtable ´Planes Suscritos´. What would be the way to limit that the user can create only one record in ´Planes Suscritos´? Thanks. Jaime
-
Technical Help/Create new record in child table
Hello all. Newbie question- How can I trigger a new record creation from a parent table in a child table. i.e: I create a record in the parent table and it automatically creates a new record in the…
-
Location of data file?
Where is the database data file located locally (I'm quite sure it is stored locally)? Also, how can I tell if it is located locally or if its stored in iCloud
-
what is the formula to obtain the standard deviation ?
Hello, I'm trying to find the standard deviation of a serie but don't know the formula. Some help ? thank you
-
Constraint formula to prevent double
I have a table (Station) and a composit table (station composition). I also have another table (products). Inside Station table is some station name and inside station composition,…
-
General Knowledge question about Databse structure and Logic
As you all know, I am completely new to this wonderful program. First, is there anyplace you know of where I can get a general overview of how to go about data modeling and the logic behind designing…
-
I have a table in a database that is hidden, how do I un-hide it?
I have a table in a database that is hidden, how do I un-hide it? I don't even know how it got hidden. I've searched the manual to no avial. Thanks in advance! Marek
-
Have SQL Command That I Am Trying Run with Ninox
I have a table named DOTList and I want to run this SQL script but it's not working UPDATE DOTList SET DBA_NAME = LEGAL_NAME WHERE DBA_NAME = '' I get this error message: Field not found:…
-
Ciao
Salve, vorrei sapere come nascondere un valore in un campo di un report se tale valore è <= di 0, grazie mille!
-
Adding colour to records
Dear forum I have set up a table and everything is functioning just perfect, only, I would like to mark some of the records in colours according to their content.…
-
Update Multiple Records (assign calculated value ) vs Formula Trigger on create
Please, help. 1. When Using formulas like this in Field for Trigger on create Field, perfect. 'Invoice No' := "ArtNr.-" + format(cnt(select Rechnungen), "0000") 2.…
-
All Records Suddenly Disappeared
I have Ninox Database Premium Version 2.6.7, and I am running it on macOS 10.15.3 (Catalina). Today I was editing a database that I have been working on for years.…
-
Is there a way to get a checkbox to look and act like a checkbox in the TABLE view?
I just want to check off the item that was done without having to go to the attached form. Apple Reminders is an example of how this works.