-
Global image signature field
How can the contents of a image signature field be made global, so the same image appears across all records in a table, but is only saved once?
-
How does Ninox decide what columns to show when performing a global search?
How does Ninox decide which columns to show for each table and the order of the columns, when a user does a global search?
-
records
how to prevent duplicates records
-
Android app
Questions about Android app: 1) Is it possible to use barcode scanner? 2) How does one access the Find(Global Search)?
-
Button action to switch from one table form to another table form?
How can I create a button action that switches the user from the current form to a form in a different table? If there is not already a built in function for this,…
-
can I set and use global variables ?
for example i go to the option panel of my database (admin mode) and i type : let pn := 110;void and then i would use pn (how to call "pn" back btw ? just use pn ?…
-
select and sum only if and if
1)how can i sum values in sub table that are between start date and end date in parent table? in parent table i have name , start date , end date. in sub table i have date , amount.…
-
Formula not working - number doesn't increase?
I have this formula working for my orders and quotes table, but when I try to adjust it for BLA's each records BLA Number is the same let myyear := format(today(), "YY");let myBLANr :…
-
Different data between computers on the same icloud account
I have desktop and macbook. I usually input data from the desktop but when not at home I use the laptop. This morning I noticing that some of the datas are not synchronized between them.…
-
Blank row prevention?
I've prevented write on some of my tables, as their content is unlikely to change in the near future, and if it does, i can disable write prevention and add the new records.…
-
Calculate records with dropdown value
Cant seem to get my if statements working. I just want to sum up the 'Total' field of my records that have the dropdown (Status) set to 'Sent'. Any help appreciated!
-
Has anybody already fetched invoices from Getmyinvoices or invoicefetcher and transferred them to Ninox via API???
I want the invoices to be placed in a table in a way that both the invoice data and the invoice document itself (pdf) make up the data record. Greets, Thomas Beck
-
How to pass field name to a function that returns field value?
function getFieldValue() do record(tableName,1).'Contact Person'end The above function returns the value of the "Contact Person" field. How can I change the function so it will return the value of…
-
Ideas & Suggestions / The Red "You have modified the application" element should not have two buttons
The Red "You have modified the application" has two buttons for saving and reverting, however, it appears to the user as one big red button. This violates common interface standards.…
-
iCal sync issue
Hi, I'm using the iPhone version of Ninox, and have an appointment field, which syncs with iCal. Appointments appear in my calendar just fine, with iCal showing the length of the appointment…
-
Barcode scan
I am using a bar code reader to insert a number into a field I would like to add a new record on each read. Using the Create table command My problem is that once it is created I would like to go to…
-
Ability to save import settings for a csv file
Say for instance I have an inventory file that I wish to import every day it would be useful to be able to load an existing import configuration that you could save the first time you set it up.…
-
Two Wishes for Choice and Multiple Choice Fields
1) In form view, I wish there was "Add Value" command at the top or bottom of the list so I could quickly add to the list and sort the list. As it is now there are far too many steps for adding vales…
-
Problems with conditional display of fields in food ingredients database
I have checked the synthax over and over but can't make this work... I want to create categories and sub-categories but, in order not to crowd the input screen,…
-
Tenant and sub-tenant
Hello, I have a trooble for modelization a schema. In fact i have a table tenant and in this table i have record that is sub-tenant. But how can recognize the record tenant or sub-tenant?…
-
How can I apply a constraint on all results : (select table) [ xxxxx ] ?
I need to have a constraint but to be applied on multiple results. number(b.ID) != (select Achats)[number(Atelier.ID) = number(a.Atelier.ID)].Contact.ID I wish to exclude all contact ID that…
-
I need to run a formula on each field of a table...
I have a table with some ''class'' and each ''class'' contain some contact. I need to set a constraint that prevent the selection of a contact already in the actual ''class''.…
-
Clear History / Rebuild Index / Rebuild Thumbnails
This may be a bit of a stupid question, but I'm new to databases. I'm trying to understand exactly what happens when each of these actions are performed.…
-
Format Date
I have a Date field, I am trying to format that date field to display in MM/DD/YYYY. I have had many unsuccessful attempts in doing so. How do I do this?…