choice field color

I have created a multiple choice field where the different choices have different colors. How do I get this colors to print out in a form? they appear as just text

Sums and Counts based on a text status

I am trying to total the value of some invoices based on the status, like "Paid", "Overdue", etc. Ive tried some simple formulas with various adaptions and they are still not working,…

Sum a field based on a multiple choice field

I am trying to sum a field based on the value of a multiple choice field, ie = 1, 2 or 3. This works for values 1 and 2 here sum((select 'Personal details')['Bond/Insurance Provider' = 1].…

How to sort concatenate values from linked table

Hello, got hard time in order to find a way to order concatenated fields from a linked table. In short I have to create a report from main table that use a linked table to feed a grid with "Note…

change the labels on search

hello, how to configure the labels that appear on a search? thank you. alain

integrated Google Maps Formula.

Good Morning All, I have a formula in pleace in which im trying to add an option for to select if i display a pin location on google maps by either, name of the business, the street address,…

Pre-Populate Choice Value List

How can I pre-populate a choice value list (Year) based on another choice value list (Make) selected? Ex: Make, Year, Model Thanks,

Deleting Images via batch update or formula

Hi, I've noted that when using the formula : Image := null , rather than deleting the image it shifts it into the attachements area. Is there a formula which will delete the file?

Contains formula

What is the formula to display something if it contains a certain text in that field?

hidden table

Create un subtable record from the parent table with a script button

Hi, Need help... How can i do that please ? Thanks !

Deriving dates

Hi all! I am looking at projects. I have different phases and duration for each of those phases, which vary per project. My first phase is definition. And my second phase (configuration) cannot start…

Should I be able to send formula fields from Ninox to Gmail using Zapier?

I can get text and number fields from Ninox to transfer to an email via Zapier but I can't see data created via formula fields. Should these fields be accessible to link via Zapier?

Add color to a line break?

Is there a way to add color to a line break? I want to have visual dividers on my record view. So far, all I can do is a hearder with no text workaround.

left pad How to use

I understand substring, but cannot get left pad to work.

Different colours in Calendar

Hi, I have created a database that lists Composers their Compositions. Both contain date fields, that I have set to appear annually in the Calendar: - Composer:…

"Like" and "not like" formula selection?

I want to create a formula that performs an action if a certain value is selected (like) in a choice field, or if a certain value is not selected (not like) in that same choice field.…

Icons in Choice

Hi, how can I add custom icons to choice buttons? I see posts from 2018 saying it will be in the future. I hope we are in the future now.

Keyboard input for decimal

Hi, this may be a stupid question. On my laptop the decimal is a comma and PC the decimal is a fullstop, how can I get that they are both the same.(MAC).…

Calendar and ical Synchronization

Hello, I downloaded Ninox for individual use and installed it on my macbook pro. I've just created my first database: an organizer for my business tasks.…

Button delete all record

Ciao, How can I create a button field that deletes all data in a table record? Thanks for your answers Valter