MZ's Profile | Ninox Community

Badges

Latest Posts

Re: Print from Page NOT Table
@Michael Riley I'm not sure what you mean. The old print engine works with normal field identifiers. The dynamic print layout with JSON. Depending on what you need, this concerns a simple field {d.…
- red_kite
- 12 days ago
- Get help
- Reported - view
Re: Print from Page NOT Table
Sure, that's possible. But for this you have to change the script in the JSON in the print template. Here is an example. I used a dynamic selection field, because the data can extend it.
Attachment
- red_kite
- 2 wk ago
- Get help
- Reported - view
Re: Print from Page NOT Table
Hi Michael, here is a little db with an example. You absolutly need ninox public or private cloud. On the page is the button to run the script to print.…
Attachment
- red_kite
- 2 wk ago
- Get help
- Reported - view
Re: Print from Page NOT Table
Did you mean to print and save values that are created on the page, or to print values of an other table on the page and save them pdf on the page. As far as I know, the first is not possible,…
- red_kite
- 3 wk ago
- Get help
- Reported - view
Re: Seelect where Calculation from 2 entries
Also you can slice the last two directly. let myReg := Registration; let lastTwo := slice((select 'Flt Hrs' where Luftfahrzeuge.Registration = myReg) order by -Datum),0,2).…
- red_kite
- 3 wk ago
- Get help
- Reported - view
Re: Comparing a formula field value with a string from within another formula field
@Vermaji The logic behind, is type conversion. Using styled() creates a new type. If you use the comparison operator "=", then you get a mess if they are not the same types.…
- red_kite
- 1 mth ago
- Get help
- Reported - view
Re: Display data in dynamic choice
let monthValue := number(MonthChoiceField); let yearValue := number(text(YearChoiceField)); if monthValue and yearValue then let result := range(number(date(yearValue, monthValue, 1)),…
- red_kite
- 2 mths ago
- 1
- Get help
- Reported - view
Re: Display data in dynamic choice
Hi Rafael. If you have normal choice fields for month and year, you could use them for the following script for a dynamic multiple choice field or dynamic choice field.…
- red_kite
- 2 mths ago
- 1
- Get help
- Reported - view
Re: Sharing JSON object between two formula fields in the same table
@Vermaji Yes. First write in Field "Bal Left" let pmtData := {balDue: 0, pmtCompleted: "NO", pmtType: "NOT PAID", message: ""}; pmtData or only {balDue: 0, pmtCompleted: "NO", pmtType: "NOT PAID",…
- red_kite
- 2 mths ago
- Get help
- Reported - view
Re: Sharing JSON object between two formula fields in the same table
You have access to the values of a JSON object for example via dot notation. Try pmtData.message Don't use the JSON as formatJSON(). That's just text.
- red_kite
- 2 mths ago
- Get help
- Reported - view
Re: Request to Remove Quotation Marks from Field Return Value
@我是我的我 Well, then we're already two. 😐
- red_kite
- 6 mths ago
- Get help
- Reported - view
Re: Request to Remove Quotation Marks from Field Return Value
another possibility is the following. But why? let salesData := (select tab1).("{name: " + """" + Te + """}"); join(salesData, ", ")
- red_kite
- 6 mths ago
- 1
- Get help
- Reported - view
Re: I can make the table headers sticky on scroll.
Quite abstract, so without exampleDB. Try this. Put a new class in CSS .tableFixHead { overflow-y: auto; height: 100%; } than also in CSS thead { position: sticky; top: -.…
- red_kite
- 9 mths ago
- Get help
- Reported - view
Re: HTML and Ninox
@Fred Hi Fred. Sorry if I should mistranslate some things. The sequence for the table header can also be swapped to a variable. This makes it a little clearer again.…
- red_kite
- 9 mths ago
- Get help
- Reported - view
Re: HTML and Ninox
@Fred In my script is "lastPr" your "League" ;-). I use my template tables in everyday life. Hope it helps you. Mirko
Attachment
- red_kite
- 9 mths ago
- Get help
- Reported - view
Re: HTML and Ninox
Try this, but i do not know if that is this, what you need. Mirko let tbleHead2 := --- <thead> <tr><th>Name</th>{ if lastPr != 2 then "<th>Atm</th><th>AvP</th>" else "<th>R1</th><th>Atm</th>" end…
- red_kite
- 9 mths ago
- Get help
- Reported - view
Re: Ninox public cloud down?
@Fred Hi Fred. A somewhat clearer notation is this one, in which the Ninox code is enclosed in curly brackets. All the quotation marks that confuse me are missing here.…
- red_kite
- 9 mths ago
- 2
- Get help
- Reported - view
Re: Creative Suggestions Needed for styled() within a Formula
An other idea with a dmulti-field. You can hide the dmulti in background. Display is the formulafield. Mirko
Attachment
- red_kite
- 9 mths ago
- 1
- Get help
- Reported - view
Re: Change the color of Number text(field) depending from the value
@George Tanev here in forum
- red_kite
- 1 yr ago
- Get help
- Reported - view
Re: Change the color of Number text(field) depending from the value
@George Tanev is it possible that you share a db in which there is a table with the problem area?
- red_kite
- 1 yr ago
- Get help
- Reported - view
Re: Change the color of Number text(field) depending from the value
@George Tanev I dimly remember a bug in Ninox in an earlier version. Which version are you using? (Mac, iPhone, iPad, Private Cloud, etc.)
- red_kite
- 1 yr ago
- Get help
- Reported - view
Re: Change the color of Number text(field) depending from the value
@George Tanev you must drag on this
- red_kite
- 1 yr ago
- Get help
- Reported - view
Re: Change the color of Number text(field) depending from the value
@George Tanev Hi George. Another form of conditional programming is a bit easier to read, but leads to the same result. An other thing, You need not the function text() if it is text with quotation…
- red_kite
- 1 yr ago
- Get help
- Reported - view
Re: How can I calculate which week of the month a specific day falls into in Ninox?
I don't know if I've translated and understood everything correctly. enclosed is a small DB with a suggestion for one year.
Attachment
- red_kite
- 1 yr ago
- 2
- Get help
- Reported - view
Re: JOIN function combine with checkbox.
Hi. I creat an share a minichecklist, later a midichecklist on this link: https://forum.ninox.de/t/y4ytm4f/minicheckliste It was an experiment, but works. Mirko
- red_kite
- 1 yr ago
- 1
- Get help
- Reported - view

1 2 3

Welcome to the Ninox community

MZ

Re: Print from Page NOT Table

Re: Print from Page NOT Table

Re: Print from Page NOT Table

Re: Print from Page NOT Table

Re: Seelect where Calculation from 2 entries

Re: Comparing a formula field value with a string from within another formula field

Re: Display data in dynamic choice

Re: Display data in dynamic choice

Re: Sharing JSON object between two formula fields in the same table

Re: Sharing JSON object between two formula fields in the same table

Re: Request to Remove Quotation Marks from Field Return Value

Re: Request to Remove Quotation Marks from Field Return Value

Re: I can make the table headers sticky on scroll.

Re: HTML and Ninox

Re: HTML and Ninox

Re: HTML and Ninox

Re: Ninox public cloud down?

Re: Creative Suggestions Needed for styled() within a Formula

Re: Change the color of Number text(field) depending from the value

Re: Change the color of Number text(field) depending from the value

Re: Change the color of Number text(field) depending from the value

Re: Change the color of Number text(field) depending from the value

Re: Change the color of Number text(field) depending from the value

Re: How can I calculate which week of the month a specific day falls into in Ninox?

Re: JOIN function combine with checkbox.

Overview