-
Organize Reports
Hi all One question about organize reports on DB. I organize a Table Reports ( no informaton here) with for now 3 reports one for each subtable (Disciplines,…
- Answered
-
I need to build a string for each "checked" multiple choice
Hi, Hope someone can help! I have a multiple choice field which has 5 options (at the moment, this may change). I have another field which is a numerical value,…
- Answered
-
Problem with radio Botton on Web version
@Fred Hi Fred please can you check something.? On Table Documents the WBS on new Web version 3.6 Lost the radio button , no problem on previous version, on Android version is ok work perfect.…
- Answered
-
Using if statements and date calculations to display yes or no based on variable.
I'm new to this program so forgive me, I'm trying to implement an idea rapidly without understanding how complex...or not complex I am going with my attempt at functions... and failing.…
- Answered
-
Formula needed
Hi guys. I need a Formula the sum Earned_V / sum Budget * 100 (2.309 / 20915) * 100 The Code_RQ is the Requisition Code no change. The ODC Code can be diferent. One RQ may have different ODC Thanks
- Answered
-
Button to create new record for sub-table and with reference
Hello. Apologize for my lack of knowledge in coding. I have a button (Update_Storage) which is supposed to create a new record for a sub-table (History) and copy information in from another table…
- Answered
-
sum results of this year
Hi guys I seem to be stuck and cannot find the solution to my problem on the Ninox YouTube channel. Here is what I would like to achieve: sum up the results of a formula field in another table where…
- Answered
-
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
-
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
-
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
-
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
-
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
-
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
-
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
Answer questions and share your knowledge