Disconnected from database

I became disconnected from my Ninox database. All I have are old archives. How do I reconnect to my databases whether they're stored locally or on iCloud?…

CONSTRAINT

@Fred Hi I need the Constraint for Activities_ Line to Product_Line. I can't find how, I need select only the Line for select it Activities_ Line and no View all.…

• Answered

Import an Image from a Filename

Greetings - New to Ninox scripting, so please forgive the basic question: I have a picture container called "Image" and a text container called "Filename" which contains path to an image that I want…

How can i add more info into the Calendar title

Right now i have a job type showing but i would like to also have the job price and time showing so i can quick see what kind of job it is based on price and see the job time?…

Wrapping text in tables

The tables seem to default to non-wrap. It would be really useful in a view to wrap text in text fields so that the whole content could be read from the table without calling up the record form.…

Automatic email notification for 1 year of Birthday

Hello everyone, I've created a Ninox data base witch manage commercial contracts. All contracts have a start date and I would like contract managers to receive an automatic email notification one…

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