Draw a line between a few points (iow draw a printable chart)

Hi all! As you can see in the picture there are a few line charts, with lines that connect some points. Those "points" (x) are generated via an if-then algorithm (if score = 19 then "x" else "-" end…

Mirror tables in different databases

Hi, Is there a system to have a copy of one database table in another database and have it so that when I add or change something in one table it automatically updates the other table? Thanks

Reset line id to 1 with new invoice

2 Tabels: INVOICE and LINE ITEMS. Goal: Each row in LINE ITEMS to have an serial number that starts at 1 with each new INVOICE

Print Dashboard

Hello! I created this dashboard and I love it but I can't find a way to print it. I own a bakery and this is for the delivery orders. The tables below are views.…

Wrong result of multiplication

What could be the reason if I am trying to make a simple multiplication 415 * 1.305 the result is 541.5749999999999 instead of 541,575? What's wrong with the math?

Sum service amounts from three tables based on dates

Hello. I pay my employees weekly based on how much they bring in for services, products and off-site events (three separate tables) throughout the week. I am using a date field.…

• Answered

3.10 BUG feed back please.

When I try to select an option here, I get nothing offered. Can anyone confirm before I report to Support

Run a fórmula under two conditions

Is there a way that once I select Milestone1 Multiple Choice (dynamics) and the Real1 have a date, this formula will be executed (first((select Milestones where Id = 1).…

Information only appearing on refresh after new Ninox release

My team has been complaining that information that should be in a form is missing until they either refresh or log-out/log-in. Has anyone else experienced this since the new release?…

Files on google drive

In looking for other topics on this I have not quite found what i want on the forum. So at the moment I am storing images of files (customer Order Acknowledgement/ Delivery Note etc) within 6 set…

Trigger on open database

if i put this script into a button on a table form it works. do as server for a in select JobDockets where 'Job Bag' <= 13980 do a.(SupplierQuote := null); a.(SupplierConfirmation := null); a.…

• Answered

Admin Column Filters overriding individual user filters. Can I prevent this?

If I filter a column in a view by date for example, that filter overrides anyone else's date filters. Is there any way to avoid this? I am the only admin and it seems to be true regardless of whether…

Is it possible to force a FX Script field to the same hight for every Records?

It seems like when lining up FX fields side by side with other fields, it's higt is individual for each Record (as pr. adjustet to fit). Espessialy when using "Show only if" ....…

Remind me where my data is stored

I have Ninox on my Mac (v 3.9.3) as well as my iPad and iPhone. I may have paid for the Ninox app from the Apple App Store but I'm not on any subscription scheme.…

All I want for Christmas!

Ninox Support (When you are monitoring this forum - Please pay attention to this Santa Wish List thread. This is what your user base are listing here because we need a few (err probably more that…

• Answered

Copy to clipboard: Multi-line referenced table

Hi Folks, Here's a doozy (well, hopefully not). I'd like to add a 'Copy' button below a referenced table "Project Details". Within that table, I'd like to copy a couple of fields:…

Convert total time not in days but only in hours

Is it possible to have the total time only in hours and not in days?

Sum Based on Choice

Trying to add up all totals from multiple records based on a choice. Data Base is called Receipt Details. When I choose a month, for example OCT under Statement Month,…

• Answered

Script problem.

do as server let me := this; for i in select 'Task templates' do let new := (create Tasks); new.( void; Status := 1; 'N1 Main Table' := me; 'Assigned Date' := date(year(me.'Start date'), month(me.…

• Answered

Not Exit from a loop

Hi to all! i have got this loop on a formula: let images := response.result.images; let coverimageLink := ""; let foundImage := false; for i in images do if (i.type = "primary" or i.…

• Answered

3.10 public bug

Picked this up for 3.10 public version - have emailed support. Can anyone replicate? Couple of bugs. It seems that a formula that refers to an image field loses its ability to have a colour…

Beginner scripting resources?

I’m trying to teach myself about scripting commands. But I’m having trouble finding full, complete answers. For example, the Switch Statement. In the Ninox Intermediate Tutorial #3, Switch Statement,…

• Answered