Get help Category

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

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…

sum and count function?

Is there sum and count function for column

Relations between records in the same table

Hi, I have a table for Invoices, where the type of the invoice can be selected: Fee requester, Proforma invoice, Invoice, Modified invoice, Storno invoice.…

Workspace

Ive deleted my workspace by accident and now can't get in to my program can you help please

Currency Conversion

Has anyone successfully implemented the European Central Bank's currency API for getting real-time currency exchange rates to use in a Ninox database? I managed to use fixer.…

Change the color of Number text(field) depending from the value

Hello Everyone I want to change the color of the text (field) of my Number field depending of the added value. For example: I have two number fields - Number and Number1 I am using that in the…

Address split into separate fields

Hi community. I am trying to find a solution whereby I can paste full addresses (as below) in a text field, that then splits the information into ADDRESS, CITY, STATE, ZIP text fields.…

Display of columns in table 1:N

Hello Relationship between tables 1:N and when I click on the button to add an existing record, the display of the columns does not suit me, how can I change it and save it?…

• Answered

Spotify API Request

Hi to all Has anyone attempted to connect to Spotify through an API Request? let token := "BQB7FiB1M60v_z...VlaJOMjdE1-I"; let artistId := "0TnOYISbd1XYRBk9myaseg"; let response := http("GET", "https:…

How can I calculate which week of the month a specific day falls into in Ninox?

How can I calculate which week of the month a specific day falls into in Ninox? There doesn’t seem to be a monthweek function. How can this be calculated? I want to create a heatmap using this data.…

• Answered

Steps Progress Bar Misalignment Across Stages

Hello everyone, I’ve set up a progress bar with steps, but it’s not correctly distributed across each stage as shown in the image (the correct setup should be: Submit in the first stage,…

Create an Array from a dynamic Choice field

I want to create one row for every choice selected in the DCF. I wrote this code and something don't work. let a := numbers('ISTRUTTORI.'); let aa := 'ISTRUTTORI.…

• Answered