Searching not working as expected (new to Ninox)

I have a column with a Status. It has values like Complete, Partially Complete, etc. I just want to show the values where it's "Complete", but I can't figure out how to enter that in the search…

Ninox Not Syncing with iCloud

I downloaded the iCloud Ninox app, but it doesn't see the Ninox databases that are in my iCloud account. The only (apparently non-synching) way I can get the data on iPhone is to save an archive.…

• Answered

How to create balance table from income and expense tables

Hi. I have two tables: 1. Income table - consisting of several fields and a formula named "total income"2. Expense table - with "expense amount" field. How can I create a balance table that will show…

database wide variables

I'm a teacher, and a lot of the formulas/views/filters are based off the current school year. Multiple times I reference either a students grade, the current school year, the current trimester etc.…

Joining text strings with carriage return

I have a clients table where each record has several address fields. Eg. address 1, address 2, city, state, post code, country. I want to join these fields into a single multi-line address but…

# of linked records in LINK FROM fields and VIEW fields

Another question: How can I access in code the # of records linked in a particular LINK FROM field? How can I access in code the # of records in a VIEW?

LINK FROM tables

If I link a record from another database using a LINK FROM table as above. How can I access that linked record in code? Or to multiple records linked this way?

Populate a Related field

I need to populate a related selection field (consignee) based on the value previous selected in other selection field (entity). The consignee selection field will have various values available…

Not to update a field after completed

Is it possible to block a field after it is change or writen after first time? I mean, I dont want to be able to update it.

Basic Beginners Help Please! How do you use info in column count as a table field?

I am on a trial version of Ninox after using MS Access for years. I am trying to figure out how to find the percentage of the count of 2 columns on a table.…

Rich text formatting disappears in final PDF file

Im on the cloud version. I have read all the posts about printing rich (or formated) text. Although in the print layout screen the formating is present, in the final pdf file not the rich text field,…

New To Ninox

Using HTTP function, how do you update the Ninox field(s) with the return value from, say, a POST call? Thanks,

Using an iFrame in Ninox to view a website

Can someone help with a sample script to add a website into a formula using iframe?

• Answered

print

is there a way to print by word or excel office directly? not pdf, export to word or excel?

• Answered

Formula Problem.

Hi I need That if Horas Ganadas Real is = 0 then Horas Actuales is = 0 too. The Horas Actuales is a Formula let t := this; sum((select 'Horas-Actuales')[Semana <= t.Semana].'Horas Actuales')

• Answered

Seek help to find array position number in a array loop

Hello, This is my first post, so please bear with me if the formatting and my wording dont make senese.... I am creating a genealogy database just for the fun of it,…

Formula with a value of the last record

First of all excuse me for my poor english. Let's se if I make any sense. I have a field of total in a record of a day and want that same field start as a balance on the next day i tried to use this…

ID of a newly (Create 'table name')

How can I extract the ID of the new record created by: let i := (create 'table name');

• Answered

if, then not working within a function field script.

The following is code in a field. I want to have the field contain one value if a dynamic dropdown 1 is not empty and another if it is. I store the record ID of records in table A in field BPID1 and…

monthName Format

Hi I would like to return "Jan" instead of January when using the "monthName" function. Any tips?

How to use Date, Start time and time interval Field

Hi all, I'm having problems working out how create an appointment based on a date, start time and time interval. For example. I would like to book in a meeting by putting in the date,…

Dynamic Choice Field text (Value) vs Number - Where can I find them?

I have an excel with Country, Region,District I import this to my GEO table. Then I have a DCF in my MAIN table that show all Countries and I pick what I want.…

Form

How can I disable the resizing form ?