-
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') +…
-
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…
-
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.…
-
how calculate date from year, week number and weekday?
Date:= year(2019)+week(14)+weekday(0)
-
Hide field in app
Hello everyone, I wonder if it is possible to hide a field on the Ninox app. But it is important that you can still see this field via the web version. In this way I hope to make my form clearer via…
-
Console vs Button on Click using Mac App.
Technically .. what is the difference when running logic from the console vs running logic from the Button On Click event in the Mac App? I have a global function that reads 7,000+ rows in order ..…
-
Filter tables
Hello, I need your help.I have a customer table and several tables which list its equipment, as indicated on the screenshot, some equipment was checked in 2019 and others in 2020.…
-
New line in text-field
How can i simulate the "enter" button for a new line in a textfield? field 1 + " enterfunction? " + field 2
Answer questions and share your knowledge