-
Change Status on Multichoice Dynamic
I am trying to get the 'Status MC' change to 90% when I update the date in 'Real 4' but if I delete the date it goes back to 70% 'Status MC'. I try this but don't work.…
- Answered
-
Need help to complete this script.
let me := this; let myA := first(select Artists where 'Artist Name' like me.'New Artist'); if myA = null then if dialog("Waiting answer ", "Artist not found.…
- Answered
-
Get the hours from an appointment as an Array
Hello again. Sorry for all the questions all. I am trying something, that I'm sure MUST work, I am just not sure how to do it. Is there a way to stip the individual hours out of an appointment?…
- Answered
-
Trigger on open database
if i put this script into a button on a table form it works. do as server for a in select JobDockets where 'Job Bag' <= 13980 do a.(SupplierQuote := null); a.(SupplierConfirmation := null); a.…
- Answered
-
Compile multiple documents into a single pdf
Hi, Is it possible to compile multiple pdfs into one? I have an invoice which is created then saved in my database then, I also have an appendix which is also saved when I generate my invoice.…
- Answered
-
Dynamic coloring of a number field
Hi folks, On a number field, I would like to highlight if the number exists already by coloring it red. I tried different approaches with functions and conditional coloring.…
- Answered
-
Reference field trigger error
Hello Ninox Brain Trust, I have an error occurring after a trigger for a reference field. Attached will be found a sample database that shows the error in the ‘INVOICE TEMPLATE’ reference field of…
- Answered
-
How to Update in Batch?need your Help.
I want to batch update the "man" data in table1 to "woman" associated with it, without affecting the data not associated with it. How do I do it? Thank you. File uploaded
- Answered
-
How to get passed time in months from two dates?
Hi there, I hope you can help me out. I have two date modules: 1. Date: 01.01.2020 2. Date: 01.01.2021 How to create a formula which tells me how many months have passed? (12 months?…
- Answered
-
attachments: Add from another table
I have a child table in which I have an email button. This is the script: sendEmail({ from: "alan@blah blah", to: EMAIL, cc: " ", bcc: userEmail(), subject: "A new Task has been added for:…
- Answered
-
BOMs Management
Hello everyone. I started in Bills of Materials Management (BOM). To do this, I therefore created a sub-table allowing me to link content (Lists of constituent Products) to an article (Parent…
- Answered
-
Breakdown chart by city with filters
Hello ! I currently use a graph allowing me to know where my customers are located. For the Chassieu city, I only have one client and it is not sufficiently representative to display it in the graph.…
- Answered
-
Formula Need by Areas 1:N Documents
Need a Formulas by Budget by the Areas, like the Plan Value & Earned Value The Areas has a 1:N to Documents sum((select Documents).Budget) this give all value but need by Areas
- Answered
-
I have two questions about HTML code.
This is the starting code. <style> th { height: 30px; background-color: #4970FF; color: white; font-size: 28px; } td { background-color: #FE4A49; color: #FAFAFA; font-size: 22px; vertical-align:…
- Answered
-
openTable() with sort order.
Hi, using openTable() is it possible to open a table specifying sort order? In other words: openTable() - in descending order on the record ID field -. Idea being to open a form view starting with…
- Answered
-
Sum Based on Choice
Trying to add up all totals from multiple records based on a choice. Data Base is called Receipt Details. When I choose a month, for example OCT under Statement Month,…
- 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
-
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
-
Import into Dynamic Multiple Choice from matched records using IDs - not quite working
I'm pretty sure I'm close. I've done a lot of reading and hours messing around with this. I am importing some CSV data from another system export into my database here.…
- Answered
-
Display value from unlinked table
Hello. I have a global Value (Exchange Rates) which I want to use in various other tables. So far I have a table called "Exchange Rates). There is a subtable for USD-THB exchange rate which will be…
- Answered
-
Include field content in Formula acting as a button.
A typical example would be a formula acting as a button when adding contacts where the persons name is added so that a formula/button would be: Add John Doe as a new contact.…
- Answered
-
Display associated content with conditional constraints.
In table HOME, there is a record with "nb" as 1. I want it to display the associated content with table copy, but without showing duplicate names, similar to what is shown in "show" (but excluding…
- Answered
-
This is a beginner but I haven't been able to figure it out.
This is a beginner but I haven't been able to figure it out. This work for copy one record to another table, but need to copy all from Documents table to Control table.…
- 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
-
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