Ben Heron

Very simple excel formula not translating across to Ninox... what am i doing wrong?

Hello All I need to calculate the trade price of an item based on the shop margin. In excel i use the formula: RRP * (100% - shop margin) But i can't seem to replicate this in Ninox.…

• Answered

Formula does not display in subtable column: glitch or error?

Hello I have a formula (see below) that appears to work perfectly, but does not display in the subtable column. Is this a glitch or an error on my part? Either way, does anyone know a way around it?…

Is it possible to turn a multiple choice field into text with values separated by a “|” ?

Hello I am working with a website developer who is trying to integrate my ninox database with woocommerce via zapier... one of the things we need to do for zapier to read ninox is turn multiple…

What is the formula to specify a time range in a calculation?

Is anyone able to help with this? Each record has a date and a value, and I wish to calculate the SUM total of that value within a range of dates (e.g. by month). Many thanks Ben

How to create formula to display sum of expenses for a specific month?

Hello I am doing some end of year accounts; so far I have a table that displays the total spent over the whole year for each budget head - that“s the easy bit.…

How to trigger a change in date?

Hello I posted a similar a few days ago that was unanswered so i'm posting a simplified version of it. I am trying to figure out the code to trigger a change in date by one year.…

How to change multiple dates to one year later?

Hello, I have a table that is essentially a large 'to-do list' with many fixed dates that need to be replicated every year. Ideally what i'd like to be able to do is click a button when the task is…

How to trigger two things at once using 'if, then else'

Hello, i'm hoping this is a simple question to answer. In the trigger formula below you'll see that i am trying to trigger two things at the same time (in bold).…

Is there a way to modify text that follows blue bar in gantt chart?

Hello, I am finding the Gantt chart very useful, but am wondering if there is a way of choosing which text is displayed after the blue timeline bars? At the moment it displays multiple fields without…

Issues re-ordering tables in side-bar

Hello, I would like to re-order the tables in the sidebar, but it doesn't seem to be working properly. Some tables can be moved into the desired location,…

How to manage two-way multiple table references?

Hello, I am new to Ninox, and new to any kind of database building so please excuse me if this is a naive question. I am building a database for farm records that include 'Plots' and 'Inputs'.…