HELP ME RANK PLEASE

I have a table in Ninox, lets call this table, Table A. This table consists of the column Name of cars, and Scores. Please see the screenshot in the attachment.…

Need Formula on Chart

I have a multiple selection dynamic let uni := unique(((select Gastos) order by Categorias).text(Categorias)); for i in uni do first((select Gastos)[text(Categorias) = i]) end Copy I need the Formula…

• Answered

Select records through Dynamic Multiple Choice Field

Hello, I've been looking for a solution for a couple of days but I can't find it even if it's a simple thing. I have a TabCategories table. I have another table, TabCustomers, where there are,…

Yes/No function

Hi, I want to change my multiple choice function to several yes/no functions. All works well but one choice. I want to use a yes/no function (named OHW) to indicate that a client is no longer an…

• Answered

Create Record Button in a Table > Create R. to a Subtable

Hi, I thougt this would be easy, an that I have done similar before, but now I'm stuck. I Have a table "Placenames" , with a Subtable "Farms_Places", whitch have all the sub-places under the main…

• Answered

Formula to sort month

@Fred Hi Fred. Need to sort the graphic from Jan to Dec, the data is in the Gastos table (the gray data). I try this but don't work select Gastos order by month(this.Mes)

• Answered

Problem with this formula

sum((select Expenses).'Amount Spent' where Categories = "Gas") sum((select Expenses).'Amount Spent' where text(Categories) = 8) Where Categories is a Choice field.

• Answered

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…

Ninox tutorials stopped working?

I'm brand new so had been looking at tutorials here (on this web site). But now, when I select a specific course to view, all I get is a. blank white screen, no window to play the video.…

• Answered

How to get to images to edit

Can anyone tell me on icloud how I can get to the images for my database and crop and edit them and update? Thanks

Print report with Multiple choice....how!

This screen shot is pretty much how I would like my report to look: There are three multiple choice fields. When I print this, I get a concat of the choice fields but what I am hoping to achieve is a…

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