-
Trying to count using where with child and linked tables data
Hi, I am new here and have spent a long time trying to do a simple count count formula. I can use cnt(Observations.Regulation.Code) to easily count all the codes on the form,…
-
Calculate new date by adding months to an existing date
I have gone through some of the posts and tried to use the syntax but don't seem to get it right. I want to add the number of months (Fieldname Tenancy Period) to date field Tenancy Start Date into a…
-
related fields in Pivot Table
I have a table which contains a date with a price fields. The day is broekn into Day field, Month field and Year Field. The Pivot Table view is then created using Year for left axis and Month for…
-
Filter field
Hi I need to filter out only data for the current week.. i can't seem to use a formula in the filterfield. I need to get only the records with the current weeknumber How do i filter out only the…
-
Prevent the reading of a field or reset it (make it null) if it is not displayed
I would like to know if it is possible that, when a field is not displayed thanks to a condition entered in the "Display this field only if" parameter, its value is not "active" or "taken into…
-
More Spam
For those checking in for answers, hang in there. You might have to load a few more pages to see your response.
-
Show a form within a form and link it to a contact.
I have a Form which is called "Contacts" for my customers. On this form is data such as name, address etc. I have another form which shows around 30 choice fields for pupil progress,…
-
Popup related record
What is the script to open the related record in another table ? Thanks in advance for your reply.
-
How to force to synchronize all devices?
I have a database in the iphone and I want see it in my macbook too. How to do this?
-
count comments
Is there a possibility to show the number of existing comments attachent to a record? I've programmed that for attached documents: cnt(files(this))
-
Select from another table
I am trying to display value from another table's record with criterium based on comparing fields from two tables: first((select AnotherTable)[FieldFromAnotherTable = FieldFromThisTable].…
-
Using Ninox seems like pulling teeth!
Having attempted for the past week to create a database of relationships between family members, husband-wife, siblings, parent-child, and failed miserably,…
-
Why is the "constraints" feature available only in 1:N relationships and not for the N:1 relationships ?
Hello, Is there a workaround to effectively apply a constraint on all types of table relationships ? That feature is crazily useful !! many thanks
-
I need help on Invoicing Table
Hello, I am doing a DB for one of my friends with tables as follow: Invoice Contacts Products Appointments In Invoice table, there is a type drop down Offer/Invoice.…
-
Relationship between a table and itself
Hi, Is there a way to have a relationship between a table and itself without having to duplicate the table. An example of this would be a "PERSON" table and a table "RELATIONSHIP",…
-
Sharing Databases
Good evening I was just wondering what the best way was to share the database with other users. No editing just viewing. Not sure if its mobile app etc. or share in a web page. Thank you.
-
(Newbie) Create New Record from Button Formula Please
The (+) is too difficult to use as low contrast and need to move mouse to top of record to create new record. Therefore, at the end of the record form I have added a big blue button named [Create New…
-
Adjuntar archivo
¿Es posible adjuntar un archivo en la base de datos? Me refiero a archivos word o pdf, no a una foto.
-
Use filters in REST API to filter Array field.
I have a table, which returns following response via REST API:{ "City": "BORRALHA","Parish": "Borralha","CAE": [11029,11030],"Projetos Relacionados": [10776,12135,13112],"Fontes de Dados": [2,161,…
-
Modify columns in views : all users ?
Hi, one user (not admin) told me he was able to modify views (hide/show column) before and I probably changed a parameter but he can't anymore. Two questions : - How to reconfigure that ?…
-
Create / Update Record
Hi, I am relatively new to Ninox, but finding it extremely powerful. I have however encountered a challenge that I am struggling with and hope someone can help point me in the right direction...…
-
Wie macht man eine Begrenzung der Treffer in einem dynamischen Auswahlfeld
Es gibt eine Tabelle Kontakte. Darin gibt es ein Feld Kontakttyp. Dem Wert "Gerätebenutzer" ist die interne ID 12 zugeordnet. Ich möchte aus einer anderen Tabelle mittels einer dynamischen Auswahl…
-
Ninox App is Crashing on my iMac
Hello and thanks in advance for your esteemed help with my issue herein: I have Ninox Cloud and also open the online database through my iMac, Macbook, etc locally syncing with the online version.…
-
Get total number of pages in REST API
In REST API, is there any way we can get total number of pages ?
-
Retrieve data from a table and display them in other table
Hello, I would like to retrieve data from multiple records from a table to display them in a table in order to have a summary of old customer data.I don't know how to do it.…