Accidentally hid all columns in linked table view

Hi, I have a table reference, and when I click on the field for that table (in form view) it takes me to a blank page (with the search bar at the top but no columns),…

How to modify the view of the file .txt created with createTextFile ?

createTextFile(this, 'Name' + Surname, "prova.txt") This is the formula I am using right now but in the txt file I will see the information like: Mario Rossi I need to make the two information one…

Maybe linked databses?

I'm making progress since me previous question, and found the free trial - thank you! I see the data from my embedded tables in something like sub-databases? I'm not sure what they're called.…

How to automatically fill in the field "user" data of the user who created the record

Hi, How to automatically fill in the field "user" data of the user who created the record

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,…