-
Formula diferent result
@Fred Hi the Cantidad Doc in the Formula is not the same on Table and Form if Clase = "Actividad" then cnt(select DOCUMENTOS where 'LT_Tipo Documentos'.…
- Answered
-
How to select a row from a composition table to display in a superform
I am new to Ninox and am struggling a little with programmatically searching records - the equivalent of SQL-world Select statements) . I have many years of relational database experience in…
- 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
-
extractx problem
no experience with regex Need to use extractx If anyone can help, would be greatly appreciated! text field = textA - textB would like to put textA into one field and textB into another field…
- Answered
-
use yesterday's information in the table
Hello I need some information from yesterday to automatically pass to the next day. I have a formula that does it all, but there is a problem, it changes all previous days, that is,…
- Answered
-
3.12 webinar link
Does anyone have the link to the webinar in 30 minutes. Have tried registering numerous times but do not get a reply invite.
- Answered
-
globale Änderung eines Tabellennamens
Hallo zusammen! Habe folgende Herausforderung: ich greife bei verschiedenen Tabellen auf die Tabelle X zu. Diese Tabelle X möchte ich nun durch die Tabelle A (neu) ersetzen.…
- Answered
-
How to modify multiple if statements (I'm not sure if that's the right way to express it).
In the database below I have two key buttons, I will temporarily call the code in "Key1" "if1". Now I need to run the "if2" code after meeting the "if1" condition "avg(test) = 1",…
- Answered
-
Select only the Phases to Audit by the Area Audit: Multiple Choice Dyn
@Fed In the table AUDIT I define the Audit #, Date Audit, etc... and the Area to Audit (Multiple Choice dynamic) then click on ADD to Audit and then update the Table Audit Plan,…
- Answered
-
Why is there no response?
I want to display the corresponding data after clicking the button, but 1 and 2 did not work. I verified with code 3 and it is correct. Where is the problem? Thank you for your reply.
- Answered
-
How to use code to calculate the number of days in this year or next year?
Thank you for reply.
- Answered
-
Retrieve the data from a button variable
Hello! I have a database in which I have a table "Dashboard" which is the page that displays when I open Ninox and another table "Accounts" containing all the contact details of my customers.…
- Answered
-
About the copy problem
I tried to copy the content of "copy" to "copy here", but they are not complete copies. Where is the problem with my code? Thank you for your reply!
- Answered
-
Update fields from another table.
In this Table 'Enter Data', when enter the 'Last Name' need Update all fields os Clients table in the 'Enter Data' Table
- Answered
-
Questions about printing invoices
In the database table "Orders", there is a "New document" button. I created a new "test" table and set a "pdf" button. I have an idea that clicking the "pdf" button will generate a "pdf" of the…
- Answered
-
Verify working time
@Fred Is there a way to verify that a Staff working on two o more Documents does not Spend more than 40 hours. ?
- Answered
-
Problem with dynamic report
Hello to the community, Hello everyone, I have a problem with dynamic reports. I created a word document with the tags but my mac application crashes every time I try to test printing.…
- Answered
-
<span onclick> , Is it possible in a Formula (html) with for from to do loop ?
Hi, I have seen resent posts where span onclick is discussed. I wonder if it is possible to implement this in my example. I intedent do upload this as a DB,…
- Answered
-
How do you create a Google map with multiple locations?
Hi, I want to integrate into my Ninox database a Google map to display multiple locations. Has anyone been able to come up with a functional solution that could be shared here or at least give me…
- Answered
-
Work out annual leave days.
Good morning. I hope you brilliant peeps would be able to help me out again please. I am working on the tables in my database for staff. I am trying to work out annual leave. I have 3 tables.…
- Answered
-
Beginner scripting resources?
I’m trying to teach myself about scripting commands. But I’m having trouble finding full, complete answers. For example, the Switch Statement. In the Ninox Intermediate Tutorial #3, Switch Statement,…
- Answered
-
Problem with this formula
sum((select Expenses).'Amount Spent' where Categories = "Gas") sum((select Expenses).'Amount Spent' where text(Categories) = 8) Where Categories is a Choice field.
- Answered
-
Send mail with attachments from different tables
Hi ! I would like to know how can I send by email, as an attachment, the documents for lines 29, 40 and 51? The "Documents" table is not linked in N:1 --- Générer les textes ---; let nomFacture :…
- Answered
-
Incorrectly calculated Week
@Fred On Choice (Dynamic ) I use the formula let l := '1N_Control Issues'; l[let t := Week; first(l[Week = t]) = this] order by Week Copy And on the View I use the formula let s :…
- Answered
Answer questions and share your knowledge