-
Simple delete button for the current record
How can i create a simple delete button for the current/open record? Layout element > button > formula Many thanks, Maarten
-
Recall data automatically
Ciao Please, I'm asking for your important help...How can you do it, by typing data in a new field automatically search if these data are already present and, if they are present,…
-
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…
-
Getting the Year & Month between two dates
I created a convoluted formula to calculate the age of a student at the start of a course. The basic idea is 'Course Start Date' - 'Student Birthdate' I was hoping someone could give me some pointers…
-
Can you do secondary sorts within a view?
I would like to have a view that made one column the primary sort, but when that column had duplicate entries, be able to sort by a second column. For example a column for "order number" and a…
-
Trigger based on multiple fields
I have a proofer who may be called to work on several projects, and I want a single choice column that I can use to alert her that one of these projects need proofing.…
-
How to sync ninox with Google calendar
How do I get Ninox to sync with Google calendar? When I select Google in the calendar options it says it can't create a calendar because events are not supported.…
-
Define text variables in the console with the iPad version?
I can define number and date variables in the console, but when I try to define text variables I get a “Field not found” error.
-
Displaying Multiple Image Attachments from Multiple Records
I have a table that holds records with one image attached to each record. Multiple of these records are linked to the same parent.The other table has the list of parents and for each parent I am…
-
Can a field appear on TWO tabs of the same form view?
Doing a bit of RTFM (Read the FUN Manual)... https://ninoxdb.de/en/manual/tables/forms I see the following. You can interchange data fields between tabs using drag & drop.…
-
Filter Column Records That Have Entries?
How do I filter a column to show only those records that have data in that column?
-
http() function isn't working
Or it isn't working the way it used to. Can anyone confirm this?
-
Print
Hi, i maked button in form of invoice items, then when i changed a goods i click print form and i can see in attach. Problem is when i change for example items and will print againe ,…
-
How use popupRecord() and openRecord() ?
I try to create a button to open (may be in a popup) to go to an other record but I don’t know how use this fonction. Someone can help me please ? Thank’s in advance. Gwendal (Sorry for mistakes.…
-
UD Array Functions by Index
This has definitely been a progression. Typically, array manipulation is done by using the array's index rather than by the index value and that's how these functions work.…
-
If Statement between dates
I am trying to figure out a formula to give a value using the If statement but am struggling to make it work. I need something like this: if 'datefield' >= '01 Aug 2016' and <= '31 Jul 2017' then…
-
SQL “flavour”
Is there a proper, up to date reference on the SQL that Ninox uses anywhere that doesn’t involve picking through sample apps? I’m a MySQL user mainly (I’ve used some MS SQL and ages ago, Access).…
-
New formula field formatting
Has anyone noticed any unwanted formatting changes of formula fields since the latest update. I have a database that I haven't worked with in a while so I can't remember if both the table view and…
-
REST API
In the documentation for REST API it is mentioned not to put the client-side API code. Then it is mentioned that you have to use the API code to get data from a ninox database.…
-
is it possible to copy a view?
I find the possibilities of formatting a view have improved hugely since the last version update. Now I have a luxure problem: I would like to create multiple views that differ just a little bit.…
-
XML Data File
Hello, Is there a clever way to import data from an XML file into Ninox? Andrew
-
How can I select a record based on a value in a multiple choice field?
Hello all, I need some help selecting one record in a table based on a value in a multiple choice field in the record. Here is the setup: Table: Client_Address Contains one or more addresses for a…
-
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
-
fillable PDFs
Is there a easy way to complete fillable PDF forms and import them into Ninox? Can you use importFile() with an http API request that returns a PDF file?…
-
Help Please
I’m trying to set up a very simple database to help me with a two-weekly task. Firstly, I need my first field to contain a consecutive number for each entry.…
Answer questions and share your knowledge