MZ

red_kite

Joined: Mon Mar 07 07:35:12 UTC 2022

My Posts

Latest Posts

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
- 12 days 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
- 4 wk 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
- 4 wk 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
- 1 mth 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
- 1 mth ago
- Get help
- Reported - view
Re: Request to Remove Quotation Marks from Field Return Value
@我是我的我 Well, then we're already two.
- red_kite
- 5 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
- 5 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
- 8 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
- 8 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
- 8 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
- 8 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
- 8 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
- 8 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
- 10 mths 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
- 10 mths 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
- 10 mths 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
- 10 mths 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
- 11 mths 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
- 11 mths 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
- 11 mths ago
- 1
- Get help
- Reported - view
Re: JSON in dynamic fields
@Sotirios Zormpas Hi. For example, through a text field in which the values are separated by commas. Then the code in dchoicefield. let caption := split(Text, ","); let dynamicJSON := [{}][null];…
- red_kite
- 11 mths ago
- 2
- Learn and share
- Reported - view
Re: Styled number field maintaining it numerical?
@Rafael let meNumber := 33; let meStyled := styled(text(meNumber), "firebrick", "white", formatJSON({ weight: 200, filling: 1, icon: "travel_explore", color: "gold" }));…
- red_kite
- 1 yr ago
- Get help
- Reported - view
Re: Styled number field maintaining it numerical?
It is possible. let meNumber := 33; let meStyled := styled(text(meNumber), "firebrick", "white", formatJSON({ weight: 200, filling: 1, icon: "travel_explore", color: "gold" }));…
- red_kite
- 1 yr ago
- 2
- Get help
- Reported - view
print command in html()

Hello. Is it possible to trigger the print command embedded in html() for example by onclick=ui.printRecord('{ me }', 'all')? Greetings Mirko
- red_kite
- 1 yr ago
- 56
- Get help
Re: Hi, new to Ninox, trying to count number of Mondays, Tuesdays, etc each month
@John Halls What a script sugar.
- red_kite
- 1 yr ago
- 1
- Get help
- Reported - view

1 2 3

Welcome to the Ninox community

MZ

My Posts

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.

Re: JSON in dynamic fields

Re: Styled number field maintaining it numerical?

Re: Styled number field maintaining it numerical?

print command in html()

Re: Hi, new to Ninox, trying to count number of Mondays, Tuesdays, etc each month

Overview