-
Ninox script to work with csv files
Ninox has a convenient wizard for importing (.csv) data which is well featured and easy to use. If you regularly work with data contained in csv files, you may be keen to to avoid retracing your…
-
Problems with condition statement in a while do structure
Hi there! Hope you can help me out with this: So, I'm building a Many-to-Many relationship between two tables, one for journal entries ("Asientos por Registrar") and another for Vendor Invoices…
-
Auto-populate pricing from another table?
Ok Ninox wizards, now I'm trying to auto-populate some pricing and job details. Here are the top level details: Main table is 'Job Status Log' which has 100s of job entries that are connected to my...…
-
Auto-populate Music Library Fields
I am working on databasing all of my sheet music and would like to auto-populate a field on one table with information from two other tables if possible.…
- Answered
-
Get count of chosen values from different table
Hello, The formula below counts the number of records in the table Timetable where the choice field Jim has been chosen the value "norm" (it works). count(select Timetable where text(Jim) = "norm")…
- Answered
-
Auto-populate tax depending on another dropdown field selection?
I'm wondering if it's possible to tell Ninox to apply tax based on my 'job type' dropdown field? For example, if I pick 'shipping' that would be taxable,…
-
Ninext : Debug Tracer
Hello everyone, For some time, I wanted to offer you a possibility to debug your programs. I am happy to present you a first debugging tool. It's simply a tracer to display the messages coming from…
-
Pass current viewing record Id to a view element column formula
Hi all - I have a table that has a view element. I'm trying to do formulas in the view element that requires data from the record I'm viewing. As we know,…
-
Conditional formula to calculate 'taxable' and 'non taxable' items...
Hello, I'm trying to figure out how to include two fields that calculate the sum of taxable and non-taxable items. If you look at the attached image, you'll see that there's a field for the base…
-
Count of records in joined table
I have a table for our Corporate Events we plan called Event Details. There is a table named Staff that is joined to it containing all of our staff. One event could have multiple staff and a single…
-
Conditional Formatting Advice Please
The screenshot here shows I having grouping selected and a count #. For sake of clarity, I would like to emphasize the #Count so that it is more prominent for the reader when records are exported as…
- Answered
-
button for Duplicate a record and its links to a sub table
Hello Community! I needs some help to create a button in my table Navire. Each record of Navire has multiple links to another table Options (1:N) This allow to create a navire with its own options.…
- Answered
-
WISH LIST: Easy one!
DIALOG function that accepts up to 255 chars of text.
-
QR Code management
Hello everyone. I would like to start managing QR Codes in my database. I saw on the forum that creating a QR Code is actually quite simple. “It is enough”, in summary,…
-
Need Script for calculating workdays between 1st record, 2nd record, so on.
Ok, Thanks to @Fred I am able to calculate the working days since a previous record for a client. with the following script let t := this; let xBase := ('Clark Leads'.…
-
Add elements to a choice field
Hi to all Is there a way to add, edit, delete elements in a choice Field through a formula? ex. Field 1 (formula field) I assign values in a formula: let x := "Napo" let y := "Orso" let z :…
-
import an Image from WEB
This procedure allows you to download an image from a public website and display it in an Image field: Usually, I go through the following steps: Image Field text field labelled in this example…
-
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
-
Has anyone wanted to hide the add new record button on the popup link?
simply add a formula with CSS and add the following .stringeditor-button2 {display: none;}
-
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
-
A new way to comment out code in the console
With my friend Jan, we discovered a new way to add comments in the Ninox console. Simply add /* before and after the text you want to comment out : var a := {lastName : "tur"}; /* var a := {firstName:…
-
Custom Widgets (Release 1.0)
Dear Ninox Community! Many of you have asked how you can easily and cost-effectively use our Custom Widgets in your Ninox databases. The time has finally come
We have worked hard to find a…
-
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