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

• Answered

Zapier and Ninox Formula Fields

It looks like Zapier doesn't want to recognize Ninox formula fields as I'm setting up my trigger. Have any of you found a workaround? Can I maybe copy the info in my formula field to a text field?…

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

Click on button in Ninox to view Gmails

Hi everyone, I'm new to Ninox so forgive me for asking this question. When I'm logged into Ninox and also my Gmail account, I'm wanting to click on a button that searches for all emails related to a…

• Answered

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

Lookup, referencing.. Help!

Hi, I have 2 tables. Lets say Table A and Table B. I would like to call data from Table B to Table A, hence I get into table A and made a relationship to Table B...…

Print to File with Invoice Number

Hi, Could anyone tell me how to export to file from print to PDF with a particular field information in it? Such as Invoice Number? Thank you.

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

V Lookup between 2 tables

Hi I have a table called Reports which has text field called Column 1. The string "1" is entried in the Column 1 text field. Theres also a formula field in which I would like to lookup the Risk…

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…

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

Help me LOOP please.

if 'Column 1' = 'Static Site Data'.'Risks and Mitigation Costs per Site'.'Type Specific Risks'.'Risk List1' then 'Column 1' = 'Static Site Data'.'Risks and Mitigation Costs per Site'.…

double click in a cell puzzle.

Can someone enlighten me please. double click to edit a cell content is not possible in all cases. Sometimes when I try the form slides in from the right on the first click.…

• Answered

Total of the selected option

let vRaiting := "minRt: " + text('min. Raiting') + "| maxRt: " + text('max. Raiting'); let vRtMin := 'min. Raiting'; let vRtMax := 'max. Raiting'; let myFilter := trim(this.…

• Answered

Updating related fields

Hi there. I am new to Ninox and am trying to build an app for my business. We do boat charters. I don't even know if this is possible. I have a tabel "Stocklist".…

• Answered

Warning / alert triangle on Table name

Hi - I have just noticed that a couple of Tables have small warning triangle symbols over their names / icons in Edit mode. As far as I can see, there are no functional problems.…

• Answered

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…

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

Search by Artist ? HTML

Is there a way to search by Artist in this table in HTML. ? The Code is let vRaiting := "minRt: " + text('min. Raiting') + "| maxRt: " + text('max. Raiting'); let vRtMin := 'min.…

• Answered

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

Creating a Script Similar to Excel NETWORKDAYS

So, I'm thinking of replacing my workdays formulas with something similar to excel's networkdays function. What I would need it to do, is combine the workdays function and then reference a Table I…

• Answered

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