-
How to reference a field value on a parent table from a sub table form in the On Create trigger
Hi support,I have DB with a table named Claims, it has a sub table named PaySlips. When I initiate add record for the PaySlips table (from the Claims form view),…
-
A little AI is a big help learning about NX
I am a new user of NX (database administrator). Struggling with the disorganized user manual and chaotic forum. Decided to apply AI to the problem. Early results are encouraging.…
-
Admin rights on Mac
Hi, I created a database on my iPad (paid version) and stored it on iCloud. When I open it on my Mac I don’t see the wrench. Is it possible to have admin rights on both devices (iPad and Mac) in such…
-
created on' still broken on Mac ?? Or is there another way ?
Documentation says internal field 'created on' is broken on Mac ("_cd" parameter). It sure is broken on my Mac -- doesn't return anything at all. Is there any other way to access the date stamp (date…
-
Date
How to enter dates in format: YYYY-MM-DD ?
-
Ninox vs FMP
I am considering moving away from FileMaker Pro so I am looking for another Database solution for Mac. I have written a few databases for my business but I am not a high end user.…
-
In the iPad version is it possible to view in table mode same as Mac version rather than just table with form view OR is there a way of selecting multiple entries in one column - example select all phone numbers from all clients to paste in mac SMS
In the iPad version is it possible to view in table mode same as Mac version rather than just table with form view OR is there a way of selecting multiple entries in one column - example select all…
-
Current schema modification. Your changes have been reverted
When i try put a new field, i have the message when i want save my change. How to resolve this problème. Thanks. Robert
-
Left Column Disclosure Triangle?
In the "Contacts" example database file there's this disclosure triangle drop-down. What is it and how do I make use of that feature in my databases?
-
I delete some register in one table and need view the deleted register, its possible view all register deleted?
Hello, I think I or some member of may team delet one register in a table, maybe too the register never again was created. I see in the Historial from db and dont have a view whit all changes,…
-
Export / Query Ninox Database
Hello, I'm discovering Ninox at the moment. Really interresting product I must say, especially to quiclky organize data capture. However I need to make a lot of custom reporting with my data and for…
-
Count subtable
Hello, I have a table Projects which has a subtable Missions. Upon creation of a new mission for a specific project, I want to get the count of all the already existing missions for that project.…
-
how to use popup?
Hi. I'm trying to figure out how to make the popup function work for my needs. I know that popupRecord(record('Table',1)) pops up line 1 of 'table'. Now let's say I have multiple lines in 'Table' and…
-
Export data table
How to export data table in .csv?
-
Reference of Functions and Language
Hi, I understood the use of the select statement, but I need a confirmation, please... 1. I can use the select statement with a not linked table too, from any table in the DB? 2.…
-
Iphone ou Ipad
Hello, I would like to know if there is a function to know if we are on an Iphone or Ipad Thank you
-
How to divide time by a number?
I'm hoping to find out how I can take a time interval (hours/minutes) and divide it by a number. E.g. - In a delivery company, I have 52 stops that have been completed in 6:52 hours.…
-
Print image with record
For example, in the "Custom CRM" example database, how can you print the record data with the image?
-
how can I email data
Can a trigger be set to email a record of data after a record has been updated or entered?
-
Multi Link
Link multiple https://www.dropbox.com/home?preview=Multi+Link.ninox
-
Automatically move data
Hi, I have 2 tables one called “Banned” and one called “Previously Banned” the tables fields are identical. Is there a way i can get a record to move from the “banned” to the “previously banned” once…
-
Can I set both the text value and color value of a formula field so it looks like a color formatted field?
Can I set both the text value and color value of a formula field so it looks like a color formatted field? I have a choice field with text and color value updated through an if statement that is…
-
Fast Link
레코드 수가 5000개 이상이면 자동 링크가 느려집니다. 더 빠르게 링크를 형성시킬수 있는 방법은 무엇입니까? If the number of records is more than 5000, automatic linking is slower. How can you build links faster? let myID := Id;let x :…
Answer questions and share your knowledge