-
Loop not clear
Hi there, Although loops are explained in your manual, it is not yet clear how you would, for example, in a table called "contacts" with only "firstname" and "lastname" but where some firstnames are…
- 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
-
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
-
Formula don't work but no errors
I have this Formula but don't work, the HITOS is a Multiple choice Dynamics with 5 Options. I Try with HITOS = number(5) but not work if FechaF5 <= DataDate and FechaF4 !…
- Answered
-
Trigger after update record not triggered when linking/adding records to sub-table
I don't know if this is a bug or a feature, but the Trigger after update is only triggered when editing data in normal fields. Any change in a sub-table does not trigger the script.…
- Answered
-
Are there Trigger limitations?
I have a DCF (DMCF?) where a "Trigger after update" has the code: 'V.Välj Region' := ""; 'V.Välj Distrikt' := ""; 'V.Land' := text('V.Välj Land') it does't work BUT if I have the code: 'V.…
- Answered
-
Design Table for WBS
Hi One consultan, I have a Database with some tables, ones of them are correspond with the structure of the project WBS Work Breakdown Structure I have four level.…
- Answered
-
How to associate multiple records in one table with a record in another table
Hello. Due to changes in workflow I have a new table (B) that I need to associate with a table (A). Is there a way to associate multiple entries in A with a particular entry in B? That is,…
- Answered
-
Paste Excel cell intor RTF field with simple HTML
Ninox does a beautiful work when pasting a cell range into an RTF field: it is stored as HTML tables for free! That's great for our purposes but... the HTML tables stored do have some rich…
- Answered
-
Pie chart for a single record
I want to display a pie chart within a form, that visualises info contained in numeric fields within a single record of a single table. But it seems no matter how I try to construct the forumla for…
- Answered
-
Help with Scripting
Hi, I am trying to add logic to a function that I created that will flip the item status from listed to sold, donated, returned, etc. I would like to put in a safety piece that will prevent this…
- Answered
-
How to auto-fill the relationship field choice?
How to auto fill this relationship field when I create new record, instead of click into the field and choose what record. I want it auto fill because the date is just the latest date,…
- Answered
-
How to select different options in bulk?
I have a table, and I want to select 'Star' as 1 for all 'old code' less than 100, and as 2 for all 'old code' greater than 100. How should I write the code in the button? Thank you for your response.…
- Answered
-
Regarding the issue of non-administrative accounts not displaying the field.
I have confirmed that the read permissions for this field have been set to allow everyone to read, but it still cannot be displayed for non-administrative accounts.…
- Answered
-
Thoroughly delete image elements with code
I have image elements in a table. I found that using the code "Images:=null" does not completely delete the images. How can I use code to completely delete them?
- Answered
-
Payment of several unpaid invoices
Hello everyone, I have something difficult (for me at least), but I'm not afraid of you, I trust you :-) I have built a database of my finances. All good so far,…
- Answered
-
Need to link each expense from this week to a record and then link it to the main table
Hello! I have in this issue, three tables: 1st Table: Management (for each week there is a record. 2nd Table: Fixe Ausgaben (every record is one expense, which is recurring monthly on a specific date.…
- Answered
-
Find special Codes
I have to kind of Code 'AUxxx' and 'AUxxx_x1' There are way to find all codes finish on _x1, on a select 'Audits Plan' where 'Audit Code' ???
- Answered
-
trying to add 6 months to a date
Hi I have trying to add 6 months (ideally less 1 day) to a date. The formula I am using is date(year(date('Format date')), month(date('Format date')) + 6, day(date('Format date'))),…
- Answered
-
How to count number of lines and contents
Hi. Your help is greatly appriciated. I am going to be surveying fire doors. for my report I have a question (Is the door compliant) 1st - I would like to be able to have a formula to count the total…
- Answered
-
Automatically link record from one table to open record in another table using a button
In Audits Plan I have the field 'Audit Code' and need to open on 'Non Conformity' field the same 'Audit Code' on the 'Non Conformity' table the 'Audio Code' is a N1.
- Answered
-
This code works erratically sometimes it works and other times it doesn't
This code works erratically sometimes it works and other times it doesn't. delete (select 'Evaluation table'); let myY := year('Evaluation Date'); let myYM := yearmonth('Evaluation Date');…
- Answered
-
Formula returning specific values depending on multiple choice selection
Hi all, I have a multiple choice field with around 40 options and I would like to set up a formula that returns a certain text depending on the options selected.…
- Answered
-
Type error: i.updateUI is not a function. (In '.updateUI()', 'i.updateUI' is undefined)
Hey, When I add an image (PDF, JPEG or JPG) to the Ninox database I get this message: Type error: i.updateUI is not a function. (In '.updateUI()', 'i.updateUI' is undefined).…
- Answered
Answer questions and share your knowledge