-
Problem in Calc_Dynamic
Hi I have two problems with this models. The Weeks field is Multiple Choice Dynamics can I groups by weeks ? In the example I have two hours on the same week 2.…
- Answered
-
Copy text field to reference field
Hi Brain Trust, Is this possible? I would like to trigger after update a text field (copy a text field) to a reference field. They are both in the same table.…
- Answered
-
need help with the replace function!!
I get an error on the replace line output2 := ""; let cr := "<br>"; let lr := " "; let myText := myRichText; output := myText; let cText := myText; let cText := replace(myText, cr, lr); let cText :…
- Answered
-
Search by Suppier from a Choice field
Here again Hi I import a large excel file with 23.652 Items. I try to search by Suppier from a Choice field but I haven't had any luck. Some help On the Search Tab do that with let search :…
- Answered
-
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
-
Auto enter current date when a field is updated?
Hello, I am wondering if there's a way to have a date field self populate with the current date whenever I make changes in a field. I have a database with a 'Notes' section,…
- 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
-
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
-
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
-
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
-
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
-
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
-
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
-
Hide Multiple fields at once
Hi, I know we can hide individual fields by going to Display field only, if & entering "null". I have say 10 fields that I want to hide. For that to happen,…
- 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
Answer questions and share your knowledge