-
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,…
-
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...…
-
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
-
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…
-
WISH LIST: Easy one!
DIALOG function that accepts up to 255 chars of text.
-
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
-
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'.…
-
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,…
-
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 :…
-
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
-
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
-
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…
-
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…
-
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:…
-
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
-
Progress Stepper in HTML.
Ever wanted to create a step diagram to point users to the steps to follow in Ninox? Then this can be done with a choice field but a nicer representation is with HTML and some CSS.…
-
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…
-
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
-
Hiding Icons HUD - choosing which to hide
I use this to hide ALL icons etc on forms. I have tried to show only the PRINT icon by removing 'none' in the relevant line but regardless of refreshing the page or toggling the HUD Y/N the print…
- Answered
-
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