-
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
-
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
-
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
-
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
-
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
-
function between two numbers
hi everyone i have the following issue... I need to show a message following numeric rules. for example.. if number < 5 then "Result 1" if number > 10 then "result 3" but now,…
- Answered
-
Help with wedding base
I am starting this new chat as the other one got long and i now have made a sample database and have a lot of info to better understand what i am trying to do. Here is the info.…
- Answered
-
all databases disappeard
I'm using Ninox Mac, with my databases in cloud. when I open Ninox, I get a complete empty window. when I look in mobile documents, databases are still there A suggestion? I'm a little bit desperate.…
- Answered
-
Can i hide empty fields in the customer view?
After starting this new DB in the middle of the year i have many customer items that do not have the full information in them so when looking at them it shows all blank fields when doing a ascending…
- Answered
-
Jump
There are any way to jum from LT_Actividades to Disciplinas associated. When click the LT_Actividades Display all Activities link with all Disciplines, can I choose only the Display on DISCIPLINAS.…
- Answered
-
Complex Select statement for View
Summary of what I need to do: I have a table called Actions within which I am trying to create a view of all actions which are compatible with the current action.…
- Answered
-
Why would a dashboard disappear after saving a dup DB?
I am to the point that i want to start loading in data into a clean working DB set up for my use. So did a dup of a working DB and gave it a new name. I now see the Dashboard is blank nothing is in…
- Answered
-
Take Date from another Table
I need to take a Date (FechaP1) in the ACTIVIDADES Table, from the DOCUMENTOS Table belonging to DISCIPLINAS. The Orange Date, I try with these formula but take always the same dates first((select…
- Answered
-
Weird issue with DB
Hi all - I'm still on v3.5.14 of the MacOS app. I'm waiting awhile before updating to 3.6. Can you duplicate the following issue? After opening the attached table, click on Invoices.…
- Answered
-
Single user, multiple Macs
I'm interested in the standalone Mac version from the App Store for 35 euros, and store my data in iCloud to access from multiple Macs. I'm a single user,…
- Answered
-
How to Duplicate a table also with a subtable
Just quickly created Table 1 and Copy Table 1 for example, I'm wondering duplicate Table 1(Table 1-1) to Copy Table 1(Copy Table 1-1), but only able to duplicate the main table's field,…
- Answered
-
2 questions about views
Hi, I was playing around with views and started wondering about a couple silly things: 1. When creating a nee table, the default table view is created.…
- Answered
-
Read only table
I would like to make a table accept data, but once entered it can't be altered, Any ideas?
- Answered
-
Ninox for Mac vs Ninox Cloud
Hi, Do I need to subscribe if I only want to use Ninox on my mac?
- Answered
-
How do i track payments and update the new balance due?
We sell each customer one item and most of them make payments on it till it is paid off. We take in a CSV for each job that gives the DB the full total.…
- Answered
-
How do i get my numbers $ to format right?
I can not get my imported in number - totals to format to show right. I have changed the formatting to every setting in their and none work to fix it. This is how they come in from my CSV files.…
- Answered
-
Neither of the two formulas work
I try these two formulas but not work some ideas. select 'DOCUMENTOS' let xFld1 := 'Avance Plan'; let xFld2 := 'Avance Real'; let i := (create AVANCES_PROY); i.('Avance Plan' := xFld1); i.…
- Answered
-
Fx Field to Display Date or Text Depending on If Statement
Hi, In the standard view (all) for record entries, I would like a column that displays either a date that was recorded as a field or text if that date field was not completed. So far I have..…
- Answered
-
Filter on hidden columns
Hi, How do I get a view which is a subset of the main table which does not show the field to which the filter is applied. I have a table which lists photographic films which has a text field for…
- Answered
Answer questions and share your knowledge