-
Global Change (yes / no) field
Hi all There are any way to global change the Field yes / no Example is now is No change all registers to yes or otherwise. I Have a lot of registers and manually is annoying. Thanks
- Answered
-
Body of Email field
Hello, Is it possible to add logic within the body of an email field? For instance I am creating an email body with fields from my view, but some I only want to show if another field is ticked…
- Answered
-
Filter Choice (Dynamic)
@RoSoft_Steven @Fred Hi I have the table with 5 field Choice Dynamic each for one Level of the WBS. All 5 field are Choice Dynamic , each deliverable an Budget is associated with your Level I need…
- Answered
-
Dynamic choice field - showing Id instead of description in print view
Some ideas what happens here. Thanks
- Answered
-
WBS Sum budget elements
@@Fred Hello Fred I'm developing a fairly large WBS with 5 levels, I'm using the cascade method, I have a problem with the formula sum of the Budbet of each element of the WBS.…
- Answered
-
Active or Deactivate specific Budget record
Hi there are some way to active or deactive only the budget on and especific record (example the two red point) Thanks
- Answered
-
drag and drop an image
Although I never had this problem brfore and given the fact the image field can accept (almost?) any format, in one database, I decided to drag and drop a pdf file (OCRised) of 3 pages...…
- Answered
-
How to get a filtered sum() from a table-value, where all have a common category?
I need to get the sum() Formula working that it not only gets me the sum of a specific field of a table, but also a filtered value. Like, all data-entries have a numbervalue and i just want to have…
- Answered
-
Dynamic Choice triggers twice
When trying to use a 'trigger on update' for a Dynamic Choice field, that actually changes the chosen value, the trigger runs twice. I was under the impression that sensibly a trigger is NOT…
- Answered
-
Duplicating a database deletes internal references
I have duplicated a Database in order to start populating it with data from scratch. One of the tables ('Selezioni') exists only to allow the creation of Cascading Dynamic Choice Fields.…
- Answered
-
Values of Multiple Choice shown as list in print report
Hi guys, Normally when you put the values of a Multiple Choice field in a print report, it's shown as all the values separated by a comma and a space. Is it possible to get the values shown as a…
- Answered
-
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
-
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
Answer questions and share your knowledge