format numbers

let api := "a7e22d237021e918cbaa602fe168f52b"; let artist := replace(Name, " ", " "); let album := replace(Title, " ", " "); let url := "https://ws.audioscrobbler.com/2.0/?method=album.…

• Answered

I can't format number in formula field

Good afternoon everyone I have a table called "Tasación" that is related to a call "Inmuebles" that in turn is related to a so -called "Contratos de arrendamiento" in which there is a field called…

• Answered

All Scripts (Copy to Clipboard) no longer working (local DB)

Dear forum members. For years, I have been using Ninox as a library for my tracks, which I plan, perform, and archive for biking and hiking. There are also many scripts that I implemented to copy a…

Retrieving values in Dynamic Choice field

New user here - exploring the potential for Ninox to help me with a fairly simple database task. But I’m now getting into it! In Table-A, I have successfully populated a DynamicChoice field called…

• Answered

Error """ in formula field

Hi, In a formula field I have a value to insert between two "". The field with the value is called ROLE and contains a number. If I write """+ROLE+""" I would like to get "1234" instead it shows me…

Text value from dynamic choice field

How do i extract the text value from dynamic choice field? text(field_name) is not working

Substring avec apostrophe

Bonjour, j'aimerais traiter une chaîne substr comprenant un champ Ordre dans une table Mots et transformer la chaîne "l'appel de l'ange" en "AA" j'ai essayé :…

Google Maps navigation from Location field error

Reported the following issue to support, but almost 1 year later they say its s bug and have more important things to look into. The function is crucial to me and used to work fine before I needed to…

Array switches from rid to nid

I have the following piece of code: let allRGRecs := record(Leagues,leagueRecID).RiderGroups; let finalRGsbyTeam := allRGRecs[false]; let getRidersByTeam := RidersAnnounced[TeamID = 119].…

• Answered

Best way to transfer multiple databases?

Hello, Let me explain the situation. I , as director, have developed about 10 databases for a dance school into 3 different teams covering our needs to follow teacher employment,…

How do you create a Google map with multiple locations?

Hi, I want to integrate into my Ninox database a Google map to display multiple locations. Has anyone been able to come up with a functional solution that could be shared here or at least give me…

• Answered

Collective message on iPhone

I found on the forum the syntax to send an SMS to a single contact: openURL("sms:" + 'PhoneNumber' + "&body=" + 'Body' But to send to several contacts? I couldn't find the syntax ;…

use of for fonction

Hello ninox! I struggle with the for function (I think this is the one I need but maybe it could be where...) Here is my script: (sum('PV coque PRO à date') + sum(Options.…

• Answered

Pricing

Hi, just checking this product out for first time. I was checking on the price. If i wanted to use it on Mac, local only, no cloud sync, is there still a subscription required.…

Global NONfunctionality

Creating a new database and added 4 global functions which all work as they should, but then added a fifth function which simply doesn't work. The function just has 2 'text' parameters which it…

Print Image

I have the cover images stored in a ShareLink field. How can I include it in the Print Word format ?? let vTbl := ((select Albums where Availavility = 1) order by Name); let vObj := vTbl.…

Formula values not appearing correctly in table view

I have a few formulas in a "People" table that sum up various amounts from another table. These amounts appear correct on each record in Form view. When I look at the data in Table view,…

• Answered

createXLSX

Has anyone managed to figure out how to implement this to your script using the new createXLSX function?

can I hide a table only for one user?

can I hide a table only for one user?