-
Embedded eCharts into Ninox
I have tried to embed eCharts into Ninox but have yet to succeed. For example, I put the following code inside a function field, but nothing: var _style := "* { margin: 0; padding: 0;…
- Answered
-
Sort json?
Hi everyone - I'm trying to create an HTML table but want to be able to sort it, probably by using a choice field that would modify the order. I can't just sort the select because one of the fields…
- Answered
-
Enter the content of another field inside a rich text field
Hello again. I'm just ending the development of a custom application that needs to print and export some rich text fields with lots of text. What I need is some kind of "data merge" inside a rich…
-
Show "1" instead UNDEFINED
Good morning everyone, I am writing because I need "Field1" to show the result "1" when the result of the formula is "undefined". Otherwise it must show the correct number, extracted by the formula.…
- 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
-
Dashboard Help to Compare This Years Data to Last years Data to same date.
So I am in the process of creating an Insights Dashboard. I am needing help in putting together the right syntax to compare this year to present vs last years data to today, but 2023.…
-
Help with Changing Multiple If Statement to a Case Statement
I need help converting this multiple if statement to a case statement. Withdrawn and Graduated fields are yes/no. if Withdrawn = 0 and Graduated = 0 then let t := 'Enrolled Date';…
-
Importing Data into a Dynamic Choice Field
I know this was addressed many years back and at the time it did not appear to be a solution. However, has anyone come up with a way to import data into a dynamic choice field when the text being…
-
Create sequential row numbers in invoice print form
I've modified the Invoice Template to make invoices and "line sheets" for a jewelry company; see screen shots of Invoice tab and the printed form. However, the Record #'s are fixed,…
- Answered
-
Sum service amounts from three tables based on dates
Hello. I pay my employees weekly based on how much they bring in for services, products and off-site events (three separate tables) throughout the week. I am using a date field.…
- Answered
-
Copy to clipboard: Multi-line referenced table
Hi Folks, Here's a doozy (well, hopefully not). I'd like to add a 'Copy' button below a referenced table "Project Details". Within that table, I'd like to copy a couple of fields:…
-
Ninext : Debug Tracer
Hello everyone, For some time, I wanted to offer you a possibility to debug your programs. I am happy to present you a first debugging tool. It's simply a tracer to display the messages coming from…
-
Display a maximum number of data
Hi! I use a formula field to display text data which is itself from another formula field which contacts data. I would like to find a solution to display only the last 5 lines and not all of them as…
- Answered
-
Hiding elements - HUD control
In case this might helps folks here are a couple of helps. Please feel free to add anything to this post that relates to the Title. -------------------------------------------------------------------…
-
Hide button if selection in Multiple Choice
I need to make the button "ESENZIONE BOLLA" appear only if the flag is active on DAF FF 058 PS 2600KG in the dynamic multiple choice field. Otherwise I need to hide it.…
- Answered
-
Styling a portion of a formula
I have tried this without success so far. Is there a way to Style 'Files' only bit in this formula. Files is a formula given the number of attachments for this record.…
-
Get Previous Month
Hi, Hopefully a simple one. Im editing the body of when the email field is clicked. Whats the syntax to get the previous month. I have tried everything with no luck. Thanks
-
List field content using rsort()
I'm trying to print a list of all entries in a given field between two specified dates. With the precious help of other posts in this forum I managed to get the list but it still brings up all the…
-
Button script to select/link record on child table
Using the Invoice Template, I have a the 'Invoice' Table with an embeded 'Invoice Items' table. I add items to 'Invoice Items' by selecting existing records previously input in the 'Article' table.…
- Answered
-
LIVE clock script.
This came about because of a now 'answered' post. I asked ChatGPT to modify the script to add the AM/PM clock and Day/Month/Year. Hope it proves useful.…
-
Please teach me how to use this global function :-)
This code can be used in global functions and I want to make use of it. I know I can call it from a Form/Tab as needed but how? "--- This controls the HUD icons top right ---";…
- Answered
-
Numeric array variable initialization
Hello there. I'm stuck with a somehow simple problem. I can't create a variable type array and initialize it unless I enter a number. Take a look at this code: let myArray := [];…
-
Creative community and javascript
Hello everyone, For more than a year I have been exploring the Ninox code to better understand how it works. Initially driven by the lack of documentation and the frustration of some limitations,…