Multiple Choice Field - How to get possible values/choices

How to get all possible choices of a multiple choice field? With choose() I can get only chosen values, but I need all.

Time interval use and sum

Hi, there is something I don't seem to understand (odd, uh?) when use time interval fields. I want to define the daily working time and since it doesn't matter when job starts or ends,…

• Answered

Auto create record on first day of the new year

I have a table ( Invoice Summary) which summarises the monthly and quarterly totals from my invoice table. Each record in this table has a number field where I enter the year I want to summarise and…

Print Table?

Is there a way to shrink the conents of a table so I can print it all on one page? I have just a bit of overflow onto page 2.

Concatanate - Two For loop -

let check := dialog(" ATENCION ", " ¿Confirma el SETUP de la tabla de AVANCES_PROYECTO ? ", ["Si", "No"]); if check = "Si" then for loop1 in select BASELINE do 'Date:' := loop1.…

• Answered

Calculate integer from decimal value

Hello, For a calculation I need to know the integer part of a decimal value, ie. 34.25 would give me 34 as the integer part. I expected to see a trunc() (or similar) function in the Ninox logic set,…

• Answered

Conditional format Combo box

I have an Invoice Table with a choice field "Status" which has three options Outstanding, Paid and Cancelled. Is there any way to change the background colour using something like:…

Limited to One form per table?

I can't see a way of creating multiple forms from the same table. I also found an posting in this form that stated that each table has only one form. So is that in fact the case that I cannot create…

Very slow opening table

I have a table with many many fields (about 55). The form associated with it performs okay, but opening the table itself takes almost a minute even though there are only 36 records so far.…

• Answered

Apertura modulo con dimensioni specifiche

Hi, I need to open a form with personal dimensions and not by default ninox. In fact, I would like to open a small form in the center of the screen, such as an alert or dialog mask

List field content using rsort()

I'm trying to print a list of all entries in a given field between two specified dates. With the precious help of other posts in this forum I managed to get the list but it still brings up all the…

SUM COST By CUTOFF_DATE

@Fred Hi Fred I hope help with that. On the EVM Table I have the KPI' Activities Form in that form have the Field Actual_Cost here I charge the accumulated cost Week by Week in each activitie (need…

• Answered

NINOX Not Working in Web Browser - Windows 10

I work from NINOX every day from my corporate office using the web version from my windows 11 PC. When working at my 2nd corporate office in a different location the same way via the web on Windows…

Not Displaying Appointments on Mondays???!?!?!?

Hi all, I have a very weird situtation occuring on my Ninox Database. For some very strange reason, it is refusing to show any appointments on Mondays for 2 of my tables.…

How to get a dynamic multi choice field to update

Hi all - I'm using the MacOS app. So I have this code in the Dynamic value section of a field called dMC2: let prevDMC := numbers(dMC); (select Table1)[(var t := this;…

• Answered

google chart in form

I am trying to insert google chart in a form what is the code

• Answered

Emailing from Ninox

Email functionally stop working, it worked up September 29 and then stop, it is not sending email to any address. They are not going to Junk or Spam folders, all checked and whitelisted email address.…

Production: should storage tanks share a table or each have their own?

I need some advice regarding the basic logical layout/relationships of my database. I'm tracking production and inventory in a distillery. I have a table for distillations,…

• Answered

Server nicht erreichbat

Moin, seit heute früh (31.5.22) bekommen wir in der cloud Version die Fehlermeldung "Der Server antwortet nicht." Bei der App Version von Apple werden eingegebene Daten nicht synchronisiert.…

When to use "do as server"?

I've been using "do as server" code in lots of my buttons just to make my forms a bit snappier. Unfortunately I've found that on an older/slower computer for some reason the code isn't executed…

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…