Will Bindings come to Views (of Tables)?

This to me makes most sense for utilising the power of bindings. Not everyone wants to view tabular data with the same columns, same filters, etc. Great new feature and fun to play with,…

Refining a selection to use in a loop.

Is there an easy way to refine a selection that I have assigned to a variable? I'll explain my use case. I'm having some performance issues when using select inside a loop.…

Can you make Ninox trigger to zapier on specific columns?

Hi, I just started with Ninox as a possible alternative to our Google sheets. So far I have been able to create a complete crm.I would like to send triggers to Zapier when changes are made to a…

A big shout out to RoSoft_Steven Rooryck

Hi Steven, a big thank you for all of your help. You are greatly appreciated and without people like you to answer questions l would be well and truly up the creek.…

Cards view cover photo

I have records with images at the top. In form view, I can edit the Image field to select “cover” as the image display type. Is there a way to do that in Cards view? In other words,…

Pulling data from linked table

Thanks to you all, I've learned quite a bit. I have a table called Players and another called Roster. I have linked Roster > Players (name). When I choose the appropriate Player,…

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

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…