scope of variables

Can someone please explain how/where one would setup variables for a database that are 'global' ? thanks

Map

hello, is it possible to display several customers on the geographic map and assign them flags (done, in progress ...)? Thank you for your answers.

How to autocomplete a text field?

How can i autotomplete a text field with the information already entered?, Thanks

Technical Question/ How to choose the lowest value from several fields in a record?

Hi there- I am new to Ninox and was wondering if anyone had any bright ideas- I basically want to just choose the lowest of three fields that are prices of the same item form different suppliers and…

Hi. How can I add a price to current record from previous record from different fields

Hi. How can I add a price to current record from previous record from different fields

Is there a way to modify text that follows blue bar in gantt chart?

Hello, I am finding the Gantt chart very useful, but am wondering if there is a way of choosing which text is displayed after the blue timeline bars? At the moment it displays multiple fields without…

Extracting individual records from a sub-table to text field

I have a subtable with 32 records, only 6 of those qualify from further filter criteria. I want to create an individual text file showing the array of the ID codes of those six records.…

Having records sorted in Table by more than one column

In a table view we can sort records by one column only.We have to click the column heading and then click Ascending or Descending box. Suppose now that 2 columns in my table are CN (as Client Number)…

Sub table thumbnail size

Sub table thumbnail size

Global Search Button

Hello It's there a way to Start a Navigation app from the Location field on a mobile device? For example - when I have a customer with location field with his address I want to be able,…

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…