-
Issue with the 'select ... where...' function
Good morning ! I create a personalized address book in Ninox. For each company, there are several contacts and I need to display the names of the company's managers only.…
- Answered
-
Clean field when i duplicate table
There is a table 1 and a button to make it a duplicate for a new day with formula let x := dialog("NEW DAY TEMPLATE", "Do you want create template for a next day?", ["No", "Yes"]);…
- Answered
-
Number as written text?
Hello, Is there a way to format a number into text e.g. 1 - one, 2 - two etc. THNX Kruna
- Answered
-
Bug button
Can someone tell me what is wrong with my button? I would like my button to generate a pdf file and then send the pdf by email as an attachment. When I create 2 buttons,…
- Answered
-
Need transfer only the Approved.
I am using this table for the documents that will be incorporated into the main Documents table as scope changes, will not be included in the main table until the scope change is approved by the…
- Answered
-
Transfer all info on table to another table (script don't work)
let me := this; let myA := first(select 'wbs by Documents' where 'Name Document' like me.'Name Document'); if myA = null then if dialog(" Waiting Answer", " Document NOT found.…
- Answered
-
OPENAPI
I'm trying to write the openapi-api code to import company data from the VAT number. I can't figure out how to tell which value to put in which field. I don't understand anything about API but I'm…
- Answered
-
count lines of text
Formula to count the lines of text in a text field? e.g. April is the cruellest month, breeding Lilacs out of the dead land, mixing Memory and desire, stirring Dull roots with spring rain. to yield 4
- Answered
-
Formula to Count item per Week
Hi I Need a Formula to count the amount of 'Rev A' per Week Example Week 15 - 3 Week 16 - 1
- 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
-
Remove comma from dmc-print layout
I have a dmc-field which filters the 'Name' field from the 'Employees' table. By inserting the dmc-field in the print layout, each "Name" field is divided by a comma.…
- Answered
-
Sum of values of a field of a specific date
I'm looking (and can't find) a solution to calculate the grand total of a field of a given date... No problem illustrating this with a view, but that's no use to me since I need it as a value in a…
- Answered
-
Multiply a number to get a status
Hi ! How would it be possible to modify a loyalty status (which corresponds to a number) according to the sums spent. Example: the threshold for changing loyalty level is every €600 - Case 1:…
- Answered
-
Variable in a text field
Is it possible to add a variable in a text field (multiline) then, to resume this text in a field of formula and that the variables are replaced by data of other fields? For example,…
- 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
-
Force trigger after update with mass update
I have a table called "Bancos" where I import a CSV file with the bank statement. As I wasn't sure on how to, once imported all records, create a new entry on a different table "Entradas/Salidas"…
- Answered
-
Adapt fórmula to new Structure.
let check := dialog(" Warning ", " ¿Confirm the Update Transmittal ? ", ["Yes", "No"]); if check = "Yes" then for loop2 in (select 'wbs by Documents')['Name Document'] do let F3 := if loop2.…
- Answered
-
Clear select field
Hi ! I have a selection field named "Abonnement ou pack prépayé" which is a mandatory field and which is only displayed if another yes/no field named "Prestation vendue en forfait" has a true value.…
- Answered
-
Split Records
Hi Guys, I have attached a sample database called CONDOS. It has a subtable called JOB with a parent SERVICE. The Condos have multiple owners. Each owner has a percentage given in the OWNER table.…
- Answered
-
eval(uating)
I'm trying to make a selection from a known table, filtered and ordered by fields whose names are stored in other fields (or variables). I can make it work with [eval(…)] as the filter,…
- Answered
-
delete records in dmcf with a button
Hello Ninox Community, As stated already in the title I would like to delete records chosen in a dynamic multiple choice field. I know that I can deselect them too,…
- Answered
-
script syntax
Hi everybody, I watched on youtube the official NINOX tutorial “Dashboards 1 | Intermediate #10 | Ninox Tutorials » I wanted to put into practice what you show "filter by year" in my database,…
- Answered
-
Can you exit from script based on IF condition
If I want to end a script is there an "exit" or Goto statement that would allow me to bypass all remaining lines?
- Answered
-
For each record
Hey, Really new to this - so bear with me.
I have table full of OrderNo. (Salesheader) Once a month - I need to fetch the related invoicing costs from a HTTP request.…- Answered
Answer questions and share your knowledge