Global search with a button

Is it possible to start a global search with a button from a Form View?

age(some_date) function not working on Console

age(anydate) works when used on a formula field. But does not work on the console!!! I'm getting the following message: Function is not defined: age([date]) at line 2,…

Attachment locally or in a cloud?

I have 45 licences of Ninox and went my students used the attachment button they only store there files locally. It is normal? so when I check in the database I don't see the attachment

"while" vs "for" statements in Console

The following code:let total := 0;for x from 1 to 5 do total := total + 1; total;end produces the following ouput:1234 For each cicle total is returned.…

Getting location field by calculation

I'm trying to populate a location field with given lat/long coordinates. The table has 2 fields with the lat/long coordinates: for a in select 'table' do; a.LocationField:=location(a.name, a.lat, a.…

How deep can I go in a select statement

Hi all I'm a newbie transistioning from FM and trying to wrap my head around how Ninox does things. First I have the following tables: Riders Results Teams Team Membership I'm working in Team…

select do' coding issue

I would be very grateful for somebody's help with this little issue... I am trying to set a field's value (i.e. the 'Price' field) by using a set of statements from 'switch do' coding,…

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.