Reference of Functions and Language

Hi, I understood the use of the select statement, but I need a confirmation, please... 1. I can use the select statement with a not linked table too, from any table in the DB? 2.…

how to project this db

Hello need to manage my small business. Every day X products goes out from my store to my clients, and Y products return (my client has not sold them all).…

Data Field Types

Hi, I'm trying to use this Db for the first time on a mini-Ipad, I'm trying to use the data field "location" but I cannot find any instruction on the on line help.…

Two search in a base

Hi Among others I have 2 fields in a base. -One with a cross inside sometimes (x) -Another one also with a cross inside sometimes (x) What should I do to find the both with their crosses displayed ?…

Change

How can change number to text. For example amount in invoice is 5000usd . I will see text too in down invoice. Five thousand dollars

Text / Date Functions

I need to have a field that calculates 342 days added on to ‘breeding’ date entered in a table - So if someone enters 1/1/2016 for a breeding date I need the foaling date to show:…

Is it possible to link automatically (via a function) fields in two tables that contain the same text?

Formulas

Hello, When attempting to link entries together from two different tables via the cross reference function, Is there a way to get data entries to show up in the search results of "Find:…

Table References and Relations

Please provide a little more detail for your Person, Company, Employee example. What I specifically need is what you have to put in each table to tie them together,…

Function and Language Reference

Is it possible to create views called "This Month" and "Last Month"? The same formula could be used for "This Year" and "Last Year" as well as "This Week" and "Last Week".…

Bigger or equal…

Hi I have a formula in wich I should like to put the math symbol > or = I am on an Ipad and the virtual keyboard have not that possibility; just touch > or touch =;…

http() function isn't working

Or it isn't working the way it used to. Can anyone confirm this?

Function parameters - which types are possible

I've found this old post https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/types-of-parameters-for-a-private-function-5c0962c08d9fa6683abafc7d And not really any docs on the topic.…

Printing

Hello, It's possible to print the field name ? Thanks

Detect list selection

In a table view/list, select a row and the form slides out. One can move the selection up and down the list and the form data changes to reflect the selected row. Standard Ninox behaviour.…

Is there a way to enforce the required fields so a record row will not be added unless all required fields are completed?

Is there a way to enforce the required fields so a record row will not be added unless all required fields are completed?

Views

Hi, I would like to know how to show timeline in calendar? For exemple: I have contract from 1.07.2016 till 31.10.2017, and the second from 1.08.2016 till 31.07.…

How I can prevent duplicate records being added?

Hi. I'm a new user on my first project and have set up a simple database. I need to find out how I can prevent duplicate records from being entered in a table.…

Undo function

Hello, Is a "undo" function available for Ninox Online? Or how can we do if we don't want to save changes? Thanks in advance for your help. Have a nice day, David W.

Trigger on Open....

Is there any way to trigger actions on open a record? (there are on create and on update) Background: I am implementing a "cancel / undo" option where I want to rollback the values in case of…

MAJOR problem (v3.7.14 Mac)

Made some changes yesterday for first time in a few months. Made some minor structural modifications and went through a fair bit of data, updating to suit the changes (a new field or 2).…

Why can't I move these formula fields?

I'm using formula fields to display an image stored in another table, based on what is selected in the table reference popup field. The problem I'm having is that the formula fields are being forced…

Need a field formula that inserts a unique and sequential number?

What is the formula to insert or create a unique and sequential number for a record? I need that number to never change by itself, in other words, a customer's account number never changes and is…

Multiple records print with button

Hi, Is there a way to print multiple pages (records) in a button ? For one page, it already works with this : let myPdf := printRecord(this, "name"); Actually,…