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

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

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

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

Extract Record from a Table meeting some criteria

Hi to all, i have a table called Album, with a relationship with another Table Called Release (1:N) Each album could have 0, 1, or multiple Releases i am trying to extract in a formula field the name…

• Answered

Dynamic Reports - my first attempt

Hi there, Here I was thinking it would be straight forward. I have a docx template and in Word I added {d.'PROJECT TITLE'} as a data field (it's spelt correctly, all UPPER).…

• Answered

Automated Multiple Choice: Is it possible?

Is it possible to automate Multiple Choice field based on trigger/update from another fields – which is two or more fields. See situation below: Multiple Choice (MC):…

• Answered

Calculating hours from Appointment

I bet there's a better way of doing this: if text(duration(Appointment)) > "2:00" then "More than two hours" else if text(duration(Appointment)) > "1:00" then "Two hours" else if…

How to pop up a dialog if a record in a table meets a criteria.

I have a table with three records each with a specific date in a field called next date. I am trying to use the trigger after open function to allow a dialog to pop up when the date in the next date…

attachments: Add from another table

I have a child table in which I have an email button. This is the script: sendEmail({ from: "alan@blah blah", to: EMAIL, cc: " ", bcc: userEmail(), subject: "A new Task has been added for:…

• Answered

Ninext not closing in spite of "True"

Just started happening in the last couple of tries. When I open a database the Ninext loads but the dialog which is set to close (true) does not. Anyone else have this happening? Cheers

• Answered

Display a maximum number of data

Hi! I use a formula field to display text data which is itself from another formula field which contacts data. I would like to find a solution to display only the last 5 lines and not all of them as…

• Answered

Sending emails - ChatGPT example

Can anyone confirm if this would indeed work in Ninox? I'm guessing not. do you have an example of code for sending emails using Ninox ChatGPT Certainly!…

What3Words

Has anyone used What3Words in any way shape or form with Ninox.

How to style a numeric fields?

Good morning! I've had issues with the styled() function these days and after having read several articles in the forum: it seems that the stlyed() function converts the variable to text.…

JSON: add a block based on a given condition

Hello. I am creating an XML file and would like to start with a JSON because it offers greater readability and ease of maintenance. In the structure of the JSON how can I decide to add blocks…

• Answered

Delete a record and related records in other tables

I have a table named « Accounts » which is the main table where I add all my customers. From the Accounts table, I created a Yes/No field which has the mission of deleting the selected account…