-
Createtextfile: dimension file
Hi, I am using the formula CreateTextFile to create a file.txt in which I have to put a precisely number of characters and I did it completing the field with rpad formuala.…
-
Attendance record
This my setup. I have 1. Table Students1 (all students) and 2. Table Classes with: - 'Linked from' table Students2 (subset of Students1 that belong to a class) - Sub-table Sessions (with date and…
-
Unique Record Id & Id Field - strange behaviour
I'm finding that using (Mac OS Mojave 10.14.6) the internally generated Id field in calculations/scripts tends to produce odd results. I'm trying to build a database and tables to manage various…
-
Copy data.
Hello, I would like to transfer a data from one field to another fiels by pressing a button. In the same table.Thank you for your suggestions
-
if true then formula?
How do I write an if true then formula? I want my formula filed to display a result of a number field if a checkbox field is checked.
-
Syntax to use URL in function
case "Seats, BEV":"wattev2buy review & compare the " + 'No-Doors' + ", " + Seats + " seat " + 'Model Year' + " " + " " + "<strong><a href=" + html(WEV_brand_link) + ">" + html('Marque Brand') +…
-
Color Code Due dates on form
Is it possible to color code due dates on the form and table? I know that you can on the calendar and in other fields, but can't figure it out for a "date" field. Thanks, Kari
-
Cursor on iPad
Hello, Do you also have this problem with iPad in a text field : I can't insert my cursor or I want it in my word, it always places it at the beginning of the word or at the end. Thanks for your help
-
Multiple Choice in nested if formula
Help please - I have a multiple-choice and want to create text from it. When a region is selected it must form part of the text. But with the formula when the first selection is not chosen it does…
-
Justify Form Elements with common top line
I'm trying to layout a form with multiple different types of elements in a row. For instance I have a formula field, and to the right of it a View into another table.…
-
Calculation of running balance
I'm trying to transfer a number of databases to Ninox and I'm struggling :-) I've got the date into Ninox but the calculations and scripts are a problem.…
-
Formula outcome in the calendar
Hi hoping someone can help with a problem that has me stumped. I am importing a CSV file that has a date field on there but it is poorly formatted. I am using a formula to translate that into a date…
-
How to remove the duplicate button in a form view?
In invoice form I program a automatic number but if I use the duplicate button I have identical invoice number. It is possible to gray out the duplicate number? Do I have to use role?
-
Define a start up script / default table open view
Folks.. any thought about providing the capability to define a "start up" script? This script would execute upon database open. In conjuction with this request..…
-
html or pdf print out of table - bulleted list in each cell
Hi, I am a doctor, using Ninox for handoff, I have a question. I created tables and wanted to print in pdf or html. pdf does not display the whole text in each cell,…
-
Sort related records by specific field
I have added a new formula field to a table. The forumla needs to get related records from another table, sort those records based on a specific numeric field,…
-
html style not working
I'm trying to use the "html()" function inside a formula to try and style some text fields. Here's an example of what I've tried: html("<h1 style=""""color:blue;font-size:86px;…
-
duplicate a table
When I duplicate a table only 8 fields are duplicated on te new duplicated table
-
Trigger Before Closing a DB
The Options Panel has a Trigger After Open box that is executed whenever we open a Database. Is there is some kind of Trigger Before Closing that would be executed after clicking on any button to…
-
Riportare righe di un documento in altro documento
Salve, dovrei creare da un preventivo un documento di trasporto, e trasportare nello stesso le righe del preventivo. ho provato con la seguente formula, ma mi cancella le righe nel primo documento.…
-
Alert message
hello, how to generate an alert message if a field is not filled?thank youalain
-
How to import FileMaker multi-line fields
Each line within a FileMaker multi-line field is delimited with a vertical tab character, which is not supported by Ninox. I just created and used the following Ninox global function to replace all…
-
Loop error / syntax
Hi all, this piece of code is adding summing up multiple times: let me := this;for i in select Pupil dolet myInvoice := (create Invoice);myInvoice.(InvoiceDate := now());myInvoice.…
-
A plugin for Gatsbyjs the react based blazing fast static site generator
A plugin for Gatsbyjs the react based blazing fast static site generator https://www.gatsbyjs.org, then ninox could also be used easily as a headless cms and take on companies like https://www.…
-
Ability to export a file to a dropbox location
Would be useful to have the ability to export a csv file to a dropbox location as one of the options to overwrite a file of on the shareable view the option for the public view to have .…