MZ

red_kite

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

My Posts

Latest Posts

Re: Color field to change the text color and the backround for the formula field.
You can use this, with two colorfields an one numberfield. styled(text(numberfield), colorfield1, colorfield2, "")
- red_kite
- 1 yr ago
- 1
- Get help
- Reported - view
Ordered, filtered list of attachments and images of a metadata table

Order by -size and filter is size > 100kB - can canged. Table name must be changed. Is from my post from the German forum. Maybe someone here can use it.…
- red_kite
- 1 yr ago
- 39
- 1
- Learn and share
Re: Help with code to create non-repeating set of 10 numbers
@John Halls The concentrate from the knowledge of everyone here and my joy in optimizations
- red_kite
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Help with code to create non-repeating set of 10 numbers
Or an other way let r := range(0, 10); for i in range(10) do let result := item(r, random() * cnt(r)); r := r[!= result]; result end
- red_kite
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Populate a field with values from a list
Other two possibilitys. Repeating items let basicString := "ABCDEFGHIJ"; join(for i in range(10) do item(basicString, floor(random() * 10)) end, "") Nonrepeating let basicString := "ABCDEFGHIJ";…
- red_kite
- 1 yr ago
- 2
- Get help
- Reported - view
Re: How to use code to remove extra information?
for leading and trailing spaces replacex(replacex(myText, "^\n+|\n+$", ""), "\n+", " ")
- red_kite
- 1 yr ago
- Get help
- Reported - view
Re: How to use code to remove extra information?
@我是我的我 You're right, improved here, but not so nice replacex(replacex(myText, "^\n+", ""), "\n+", " ")
- red_kite
- 1 yr ago
- Get help
- Reported - view
Re: How to use code to remove extra information?
replacex('Text 2', "\n+", " ")
- red_kite
- 1 yr ago
- Get help
- Reported - view
Re: Email multiple BCC receivers.
Hi Steven. Try to put all mail-adress in an array. let bcc := ["receiver2@mail.com", "receiver3@mail.com"];
- red_kite
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Is there another way to display the filtered data?
@FredHi, Fred. Is possible, that is not the right one db (fred-v1.ninox) above? Download this again here and try it. ;-)
- red_kite
- 1 yr ago
- Get help
- Reported - view
Re: Is there another way to display the filtered data?
@我是我的我 Look.
- red_kite
- 1 yr ago
- Get help
- Reported - view
Re: Is there another way to display the filtered data?
Mistake
Attachment
- red_kite
- 1 yr ago
- Get help
- Reported - view
Re: Is there another way to display the filtered data?
For the normal table view, you can use a sorting column with my rather confusing, ugly code for grouping.
Attachment
- red_kite
- 1 yr ago
- Get help
- Reported - view
Evaluating display of larger amounts of data

Actually, I just wanted to fix an old script of mine, because Ninox apparently changed something with the eval() function and it didn't work for me anymore.…
- red_kite
- 1 yr ago
- 42
- 3
- Learn and share
Re: Interesting HTML formatting
@Fred now it's optimized. Thanks.
- red_kite
- 1 yr ago
- Learn and share
- Reported - view
Re: Interesting HTML formatting
@Fred edit: i use it in line 63 for the calculation of the total price.
- red_kite
- 1 yr ago
- 1
- Learn and share
- Reported - view
Re: Interesting HTML formatting
@我是我的我 It is the german version, you must translate "Nr" in "Id" in ui.popupRecord.
- red_kite
- 1 yr ago
- Learn and share
- Reported - view
Re: Interesting HTML formatting
@Fred Hi Fred. Here is my own autodidactic example für html-tables. Scrollable, fixed tablehead and -foot and interactiv für open the records. It's my pattern that I use myself. Mirko
Attachment
- red_kite
- 1 yr ago
- 1
- Learn and share
- Reported - view
Re: Distribute dates between two others days.
@Rafael I don't understand what you want. At the top you wrote that plan 2-4 should fit in between plan 1 and 5. It's too abstract and contradictory, as another date is now being added.…
- red_kite
- 1 yr ago
- Get help
- Reported - view
Re: How do I write the code within the formula?
And what ist the result for Warehouse A, B, C? Ok. Try this. Mirko let result := unique(sort(Inventory.text(Warehouse))); let A := item(result, 0); let B := item(result, 1); let C := item(result, 2);…
- red_kite
- 1 yr ago
- Get help
- Reported - view
Re: Distribute dates between two others days.
Yes. holidays contains an array of dates, or selfemade select HolidaysTable.date. If 'Plan 2' an so on are fx-fields then split the last line of script.…
- red_kite
- 1 yr ago
- Get help
- Reported - view
Re: Distribute dates between two others days.
Hi Raphael, try this script. I also didn't quite understand why it starts at 10%. In line 3 you have to add an array for holidays, or a reference to a holiday table.…
- red_kite
- 1 yr ago
- 1
- Get help
- Reported - view
Re: LIVE clock script.
My suggestion for multilingual ad. In "const language", select the array element with number. Database must be restarted for the change. let css := " <style> .box{ text-align:center; font: 1.…
- red_kite
- 1 yr ago
- Learn and share
- Reported - view
Re: Real time clock within a form view
@Sam I don't know. I think, Javascript is more of a hack for Ninox and doesn't always work safely. Sometimes it works, sometimes it doesn't. The watch is just for fun for me.…
- red_kite
- 1 yr ago
- Get help
- Reported - view
Re: Real time clock within a form view
@Sam like this?
Attachment
- red_kite
- 1 yr ago
- Get help
- Reported - view

1 2 3

Welcome to the Ninox community

MZ

My Posts

Re: Color field to change the text color and the backround for the formula field.

Re: Help with code to create non-repeating set of 10 numbers

Re: Help with code to create non-repeating set of 10 numbers

Re: Populate a field with values from a list

Re: How to use code to remove extra information?

Re: How to use code to remove extra information?

Re: How to use code to remove extra information?

Re: Email multiple BCC receivers.

Re: Is there another way to display the filtered data?

Re: Is there another way to display the filtered data?

Re: Is there another way to display the filtered data?

Re: Is there another way to display the filtered data?

Re: Interesting HTML formatting

Re: Interesting HTML formatting

Re: Interesting HTML formatting

Re: Interesting HTML formatting

Re: Distribute dates between two others days.

Re: How do I write the code within the formula?

Re: Distribute dates between two others days.

Re: Distribute dates between two others days.

Re: LIVE clock script.

Re: Real time clock within a form view

Re: Real time clock within a form view

Overview