Format a Formulae Field to Show time

Hi All, Trying to work a formulae field to show the data of a Time field in another table. My current Formulae is (select 'Private Snorkel Booking')[Session = 1].…

Formula Problem

if Schedule_V < 1 then styled(" UNDER PLANNED COST ", "white", "warn") else if Schedule_V > 0 then styled(" OVER PLANNED COST ", "white", "ok") else if Schedule_V = Plan_V then styled(" GOOD ",…

• Answered

(Invalid)

There are any way to remove (invalid) until the other values arrived

• Answered

Colour Coding

Hi There, I have a formulae field that sums the number of guests in a subtable. I would now like it to be green if the formaulae field number is smaller then "Max Pax" and red if larger I have used…

Automatically Displaying referenced data based on String

Hello, I'm sorry if this is a dumb question but I can't seem to figure it out. I'm attempting to use Ninox to help organize summer camps. Based on already imported data,…

function between two numbers

hi everyone i have the following issue... I need to show a message following numeric rules. for example.. if number < 5 then "Result 1" if number > 10 then "result 3" but now,…

• Answered

How can i send the Calendar feed to Apple Calendar

Up till now we have been using the Apple Calendar so we see it across all our devices. In Ninox i have the Calendar working see screen shot, But i do not see other Calendar features we use.…

Help with wedding base

I am starting this new chat as the other one got long and i now have made a sample database and have a lot of info to better understand what i am trying to do. Here is the info.…

• Answered

Two bases Ninox side by side on an ipad ?

Hi Does someone know if it is possible to open two bases Ninox side by side on an ipad ? Thank you

Accidental Kanban Movement on Phones

Is there a way to confirm the movement of cards in Kanban view? We have team members that keep accidentally moving the cards from one category to the next because they are trying to scroll…

all databases disappeard

I'm using Ninox Mac, with my databases in cloud. when I open Ninox, I get a complete empty window. when I look in mobile documents, databases are still there A suggestion? I'm a little bit desperate.…

• Answered

Show/Hide One Record

I am trying to figure out how to Show/hide one record. I don't want to hide the whole column, just one occasional record. Is there a way to do this?

Can i hide empty fields in the customer view?

After starting this new DB in the middle of the year i have many customer items that do not have the full information in them so when looking at them it shows all blank fields when doing a ascending…

• Answered

Small problem with this formula

@Fred I have a small problem with this formula: let check := dialog(" ATENCION ", " ¿Confirma el SETUP de la tabla de AVANCES_PROYECTO ? ", ["Si", "No"]);…

ninox database

i am trying to add purchase order to the list but once i refresh my ninox the order disappears from the database. is it that my table has limits ?

Report Writer

Is it possible to sort on a field in the report writer but not display it? I have to sort on multiple fields so I had to concaténate them and it has to appear on the report..…

Is it normal for ninox to crash almost every time i go back

I am using the Mac ninox App on my Mac Mini M1. Almost every time i click to go back to the My Databases it crashes 9 out of 10 times it will do this. Here is a screen shot of what pops up.…

Database limits

i have many database and i want to ask if every database has a limit of data it should recieve?because my first database doesn't receive records but the other doesn't and is there a way to increase…

Can't open the database

I've created a new database and I have imported a table from another one. This table has no formulas, only text and number data. If I close the database and enter again, all works fine.…

How can I set up two fields, one showing date/time record was created, one showing date/time of last modification?

No clue as to what is required here

Jump

There are any way to jum from LT_Actividades to Disciplinas associated. When click the LT_Actividades Display all Activities link with all Disciplines, can I choose only the Display on DISCIPLINAS.…

• Answered

Complex Select statement for View

Summary of what I need to do: I have a table called Actions within which I am trying to create a view of all actions which are compatible with the current action.…

• Answered

Rich text

Hello, I have a Rich text with many line. To end of every line i have a CR. Now with a function of text or another how can find then CR position. In a other word i need to parse line by line the rich…