How do you manage money from one year to the next?

I am not sure how to track some money when payments are made in two different years. For taxes for year years total income to see the right amount that was paid.…

Sum Specific records of certain year based on a date field

Hi All, Is there a way to make ninox recognise a certain year of a date field. i.e I have a date field in one table a count of people in the table I would like to get a total count of people in a…

sum((select......... with two values

Hi, I try to use this formula but don't work sum((select Line).Plan_Earned_Act_E; Plan_Earned_Act_P) or sum((select Line).Plan_Earned_Act_E + Plan_Earned_Act_P)

• Answered

Speeding up data insertion

Hi again is it possible to insert data without repeating those that have to stay fixed (for a few lines, but not for every line). To explain better,…

Cascading Selection Fields with a twist

Hi beautiful people, I've built a cascading selection the wait it is done in this tutorial https://www.youtube.com/watch?v=yWn--YQsoT4 All works perfectly,…

two-way communication with external app?

I was wondering if it were possible to fill out a form (e.g. in Google Forms) that talks with Ninox in a two-way-communication. In Ninox a have different projects with a yes/ no field indicating…

How to Calculate Cumulative Sum

I have this info on my Table COST_W, I have the Week, the Cost by Week, but I need a Formula for calculate the Cumulative Sum. On the Table EV_Management is where I charge the Cost by Activitie and…

• Answered

Image size in fx field

IMAGES SIZE: I have a table, containing images, to be used as headers in other places of my database I have made the images to fit the size of the header space - a fx field : (select HEADERS).…

• Answered

Group Sum Cost by Week

@Fred Need to sum cost for the group of week on the EV_Management table I try this formula but don't work let Wk := Week; sum((select EV_Management)[Week = Wk].…

• Answered

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.…