-
<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
-
Update multiple records
I seem to have lost the ability to update multiple records. Can anyone confirm this for me and if you still can - how?
- Answered
-
How to check if a rich-text field is empty
I need to control the visibility of some fields based on a rich-text field is empty or not. I do it with the visibility formula 'myRichTextField' != "" It works with a new dataset where the…
- Answered
-
Some help with formula
Hi There are any way to change the value of a Choice field depending on another field with the same information. The Choice value have : 10% Start 35% 1er Drawing 65% Issue A 80% Issue B 100% Final…
- Answered
-
I'm doing something wrong with this formula
I have Two Choice File one Status Example ( In Progress, Issue Client, Complete) , and Other Choice with Numbers (10%, 55% 100%) The formula don't work if Status = 2 then Hours * number(Choice = 1)…
- Answered
-
Select an element of choice dynamic in formula
In table TabA I have field 'Year' (field choice dynamic) which takes from table TabB the following data (field number): 2022 2023 2024 2025 2026 2027 2028 2029 In the taba table I have a button that…
- Answered
-
Adding and removing items from a list
Hi From the list myPersona I have to delete names that I find in the list myEsclusi and add names that I find in the list myAggiunti. Can you please help me.
- Answered
-
Sub-Tables - Add existing record
Has something changed with the new version (3.7.6) with regards to sub-tables? When a table has a sub-table linked to it there are now two buttons on the sub-table to "Add existing record" and…
- 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
-
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
-
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
-
How to query a table using a dynamic combo box value?
I have the code below, i want to return the email address where the the full name of the staff is the one assigned to the ticket. let i := 'Assigned To';…
- Answered
-
Conceptual Problem.
Conceptual Doubt about the Disciplines and Activities Tables The Disciplines table has some specialties, example Civil has Foundations etc as a specialty and each specialty has different activities,…
- Answered
-
Can I restrict the share view to specific set of users?
When we activate share view, is there anyway we can restrict view to specific set of users and not make it public ? Also charts view is not seen as chart, it is seen in form of tables.
- Answered
-
Syntax stupid question
Hi, for sure will be a stupid thing but I can't figure out where I'm wrong in the syntax of this formula. Can anyone help me please? Thanks
- Answered
-
Formula
if FechaR4 <= DataDate and FechaR4 != 0 then 'Hito 4' end I have a numeric field with that formula, that need take the info in Hito4 but don't work Some body help, aprecciate
- Answered
-
Need Script for transfer Dates
Hi Fred again with problems, I feel like I'm. going backwards. On the Documents I have Two Buttons ADD Documents One by One and the other ADD ALL Documents and Works excelent.…
- Answered
Answer questions and share your knowledge