-
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...…
-
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.…
-
Really dumb .... just want to add 2 number fields together and display total in a 3rd field.
I must be an incomplete moron but I've been struggling to create a very simple database that sums two number entry fields and displays the total in another field.…
-
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…
-
NEWBIE - CONFIGURING ONE-TO-ONE AND AUTO UPDATING
AFFILIATED GMRS REPEATERS USERS DATABASE DESIGN NOTES FOR NET CHECK-INS September, 2023 Software: Ninox – v 3.9.3 downloaded free from Apple App Store, single computer only.…
-
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…
-
Solutions are there for small hotels
The table has two fields for dates and I can indicate from what day and on what day to occupy a hotel room. But you also need to count those days when he is not busy for the last two months,…
-
Help on changing record color
Hello, I'm new to Ninox. I'm trying to change a record based on a value of a field: I'm using script in "after update" if Estado = "Aberto" then color("Green") else color("Red") end But nothing…
-
How to connect this table
Ninix gurus, Just when you think you now have your app ready, yet..... it turns out there is another catch. In my database for musical works, the main table is: Titles.…
-
Parent - child??
Hello, I am building a database where I store all the sheet music titles for my work (conductor). To that I link a location where that music is stored (room, closet, shelf, box) Composers, lyricists,…
-
OCR with worksheet
Hi, I'm looking for an OCR solution I could plug with Ninox to convert old printed worksheets with 3 column into separated records, one per line. I'd also need to validate each line and modify the…
-
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,…
-
iOS calendar entry duplication
Whenever I update a date entry in my Ninox database, my calendar entries on my iPhone are duplicated. That is, if I have a calendar entry from the database for, say,…
-
Automatic incremental numbers (modifiable)
Hi, How to auto-complete a field on a newly created record with a number incrementaly +1 than the previous record (starting on 1), but still bee able to modify it manually later ?…
-
Created On - Duplicate Records
I have a field called Created which is a formula "created on" Sometimes I need to duplicated a record, but the Created field becomes blank. It works only when I created a new record.…
-
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'.…
-
video or detailed feature list for the 3.10 release
Does anyone have a link to either a webinar or a feature list for the new 3.10 release on private cloud. I am going to be motivating a client to go 3.10 and would like to be as fully armed as…
-
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 :…
-
clearing the Filter option in a column on closing a view
As you can see there is an applied filter to PROJECT in this screenshot. Is there a way to reset all filters that might be applied when a view is closed.…
-
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.…
-
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.…
Answer questions and share your knowledge