Calculating an age at a certain time

I am trying to calculate the ages of students when they start a programme. I had this in a ms sql database as (floor(datediff(day,[DATEOFBIRTH],[LEARNSTARTDATE])/(365.…

A formula for < and >

Hi I have a numeric value field and I would like to find the values smaller than 100 and bigger than 20 Can you tell me wich formula I should write ? Thanks for your kind attention and advices.…

guest

hello everyone, I wanted to ask if there was the possibility of having a guest accout to let my customers access the database

How customers access the database?

https://www.dropbox.com/s/q745debiyaslnxi/%E5%AE%A2%E6%88%B6.ninox?dl=0 Suppose I have three (or more) customers A.B.C. How do they access the NINOX database (only applicable to the data I opened to…

Move value of field to a new field for entire table

Hello, I need to copy the value of one field to a new field in the same table but I need to do this for all the records in the table. I know I can do it for one specific record at a time but what…

Embed /URL

Hi. Where can I find the embed code or the url to my database?

FILTER ON "ICON"

I created a formula to get an icon as answer : if ACTIF = 1 thenstyled(text(" "), "white", "done")elsestyled(text(" "), "white", "x")end It is better to get an icon than a "Yes" or "Not" in the…

integrated Google Maps Formula.

Good Morning All, I have a formula in pleace in which im trying to add an option for to select if i display a pin location on google maps by either, name of the business, the street address,…

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

Read File Data

Is it possible to read the actual file data in a record attachment? I'm currently trying to use the ninox programming language to read the actual file contents.…

How to create balance table from income and expense tables

Hi. I two tables: 1. Income table - consisting of several fields and a formula named "total income"2. Expense table - with "expense amount" field. How can I create a balance table that will show…

Link to file on computer

Is there a way to link text to a file on my computer? Click the text in my database, the linked file opens.

Can you do secondary sorts within a view?

I would like to have a view that made one column the primary sort, but when that column had duplicate entries, be able to sort by a second column. For example a column for "order number" and a…

Maps and Locations

Hey, I want to perform a search in my addresses database, in a 100 mi radius for example. How do I do that with location fields, or a formua? Is it at allpossible?

can I set and use global variables ?

for example i go to the option panel of my database (admin mode) and i type : let pn := 110;void and then i would use pn (how to call "pn" back btw ? just use pn ?…

Automatic alert for new comment

Hi! I'd like to create a field that 'll show warn icons when 1) comment section contains comments 2) there is a new comment in the comment section Anyone can help me..?

Custom made Icons

Hi, is there any workaround to add custom made icons? thank you

Find Highest Number

This must be simple, but I need some help. How can you display the highest number in field? Example: I have 1000 Records with 1000 different numbers. I'd like to show the highest number and then add…

Trigger After Open

I use this trigger: if ninoxApp() = "iphone"then openTable("TableName", "PhoneView") else if ninoxaApp() = "mac" then openTable("TableName, "MacView") I want when the Table opens to go to last record…

Default value for Location (lat / long)

The following steps are needed to record the current location when using Ninox on an iPad. I see now "default" value. Is there a function that can be called?…

sum and count function?

Is there sum and count function for column

Calculation of dates

Is there a formula that will return a date after a certain number of months, years or days from a given date? For example, If the date entered is June 27, 2005 in Field 1,…

Sorting for a View Element

I have a relation field with multiple records in it and I display it via a view element. Now I want to have some dynamic sorting by name, or by a number, but with the sorting I dont have some luck.…

Formula Problem ?

The formula in Cost Field. 'Fully Loaded Cost Rate' * first('b_Bid Hours'.'Spend Hours') 55.22 * 1,100 = 60,742 the formula give me 60,736.60. 5,5 diference.

• Answered