Choice Field Trigger

Hi to all! I have got this structure: MasterSearchTable - fields: Choice Dynamic MusicBrainz ID MBIDsTable - fields: MBID Description as you can see the Choice Dynamic field is correctly connected to…

• Answered

Rounded amount

There are two fields in the table, and when they are equal, it shows green in the middle, when not exactly red. For convenience, the amount is rounded off to the left and shows the amount without a…

• Answered

Formula for button

There is a Table1 where information is entered and when the button is pressed, the information is written to another table - table2 Here is part of the formula Date := xCurrRec.…

• Answered

stop users changing view sort order!

How can I disable a "view' table that is on a form? I hve a view in place to show the cild table (subform) for line items of a quotes (parent table). This view is sorted into ID number (ascending)…

• Answered

CSV Problems.

I have a csv file with records, I add new records and try to import the csv file (I Choice the new records) but import all records again, I can't import only the new records. Some ideas.

• Answered

Retrieve a Previous Record Date

Okay, this one is turning out to be a little tricky. For my contact tables, I also have a sub table labeled Chronos. This is the table for all the notes kept on each individual contact.…

• Answered

Matching Phone Area Codes to Region

So, for a lot of Data I receive, I don't have any location material besides one's phone area code. I know that the area code is not the most accurate in todays cell-phone age,…

join function to get an ordered output

Hi to all i have a formula: let data := text(response.result.relations); let bandData := parseJSON(data); let artists := ""; for i in bandData do let artistType := i.…

Open a website

I am a Ninox newbie. I have a simple database where I keep track of movies I watched on various streaming services. I would like to place a button to access a website. How do I do it?

• Answered

Message in Print pdf when..

Any can help width: i want show a message ( in print pdf ) example "mymessage" when found any data in the field ( is a select field called (data) is possible ? Thank you W

Import CSV fail to link fields

So, before the last update, when i tried to import a csv to ninox, it was all perfect. Since the update i try o import the same csv but it fails to connect two id fields i have.…

HTML formatting

Hi to all, with this formula: let AR := "Artists"; html("<h1 style='border: 0px solid darkslategray; padding: 11px; font-family: Helvetica; font-size: 10px; color: black; text-align: center; cursor:…

• Answered

Issue with Formula for Clearing Data in Ninox

Hello everyone! I've encountered a problem while creating a formula for my Ninox database. I have a button that creates a new day based on the previous one,…

• Answered

Ninext function onclick on iPad or Chrome (Windows) doesn't work

The onclick function in a view works great on native Mac Application an Web-Application (Safari & Chrome) on Mac. Last Week i had two installations, one on Windows (Web-App over Chrome) an one on a…

• Answered

Integration of the ICD-11 Coding Tool into a Ninox database

Hi, I use a Ninox database to keep electronic medical records of my patients. I am writing here looking for help to integrate the ICD-11 Coding Tool into my Ninox database.…

• Answered

Trigger on a choice field (new)

i have a table with a button with this formula: let xCurrRec := ID; let xDiscogsRelease := 'Release Number'; let xtoken := 'Insert Your Discogs Token Here'; let url := "https://api.discogs.…

how to make it multilingual DB?

Hello everyone There is a solution for multilingual database? Who did to solve this problem and how? I need 3 languages

Trigger on a choice field

Hi to all I have a button perfectly functioning on a table with this formula: let x := dialog("Edit", "Edit Release", ["No", "Yes"]); if x = "Yes" then let xCurrRec := ID; let xReleaseNumber :…

• Answered

A timer to execute a scipt after a timer interval?

Is it somehow possible to have a script executed after every hour, every day, every friday etc?

how to create space in text

I want to add 2 seperate field into 1 but i want to create at least 3 space in between the program automatic makes field 1 + " " + field 2 into field 1 + " " + field 2

Wrap a text in a Rich Formula field

Hi to all! this formula : let tracklist := response.result.tracklist; let tracklistInfo := ""; for track in tracklist do let position := track.position; let title := track.…

• Answered

Response in JSON Format alternately functioning

Ok. I finally achieved my goal to get informations from a site and used to fill my fields in Ninox for Example The formula request for the formula field called Artist name: let xDiscogsRelease :…

Ninox names vs user names

Is it possible to access a list of the Ninox element names used for the User defined names? I inadvertently deleted a link to a table 'Projects' which Ninox has 'CA'.…

• Answered

Script for Search by Artist Name

Need a script for search by artist name, the screen is a Dashboard and take the from Albums. On view Discography

• Answered

Use choice fields in a formula field

Hello, Here is what I have: - A number field called (Bedrag) where I put in a value, the number field is in an parent table called (Kosten). - A choice field where I have 6 options in parent table…

• Answered