Sean

1763
80
0

Joined: Tue Jul 31 23:45:13 UTC 2018

Coding Dart/Flutter in my spare time

My Posts

Latest Posts

Re: Help with multiline text field inside an html() function
You can use this formula to do that - html(replacex(MultilineField, "\n", "g", "<br>"))
- Sean
- 1 yr ago
- 2
- Get help
- Reported - view
Re: There must be a better way...
@Alain Fontaine , @Fred Thanks for posting your example databases.
- Sean
- 1 yr ago
- Get help
- Reported - view
Re: There must be a better way...
@Alain Fontaine I am very interested in this. Would you mind posting your test db?
- Sean
- 1 yr ago
- Get help
- Reported - view
Re: There must be a better way...
I didn't know you could create a multidimensional array in Ninox. I can't assign [[2847,2848],[2880,2882],[2898,2900]] to a variable so I can't run any operations on it.…
- Sean
- 1 yr ago
- Get help
- Reported - view
Re: v3.10.8 fixes
@Fred said: Implementation of server side logic to store customisable colour palette, favourite icons and styles. I don’t have the cloud version. Does this allow users to change the color scheme of…
- Sean
- 1 yr ago
- Learn and share
- Reported - view
Re: Formula/Script behaves differently when in Full Screen View
The attached db works. Pasting code on the forum has changed and really messes up the formatting.
Attachment
- Sean
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Formula/Script behaves differently when in Full Screen View
I don't know if it is a bug or a design decision, but it doesn't look like you can modify the fullscreen DOM with javascript. Script appears to work though as the attached database demonstrates.…
Attachment
- Sean
- 1 yr ago
- Get help
- Reported - view
Re: onclick = ui.openRecord
@RoSoft_Steven Or maybe I created a problem when I made it a one-liner. Glad it’s working for you.
- Sean
- 1 yr ago
- Get help
- Reported - view
Re: onclick = ui.openRecord
@Rafael Here is an example database.
Attachment
- Sean
- 1 yr ago
- Get help
- Reported - view
Re: onclick = ui.openRecord
Yes, it can. This is a simple example. let list := (select Table1).Text; html(" <button onclick=""customOpenRecord()"">Open Record</button> <script> function customOpenRecord() { ui.…
- Sean
- 1 yr ago
- Get help
- Reported - view
Re: Copy to Clibboard button
@Sotirios Zormpas Thank you for sharing and I'm glad you found it useful.
- Sean
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Why can't I move these formula fields?
@Rafael Yeah, it removes those elements from the document flow. No worries
- Sean
- 1 yr ago
- Get help
- Reported - view
Re: Why can't I move these formula fields?
I forgot to mention that you will need to change the nth-of-type numbers to match the field's position on your form. I had to add a line break as well. I have attached an updated example.
Attachment
- Sean
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Why can't I move these formula fields?
@Rafael I found an ugly solution, but it might work for you. You will need to fiddle with the top and left values in the CSS formula to make it work for your layout. I attached a simple database.
Attachment
- Sean
- 1 yr ago
- Get help
- Reported - view
Re: Why can't I move these formula fields?
@Rafael They are all Formula fields with html, correct? I am unable to stack Formula fields with HTML vertically next to another Formula field with HTML similar to your screenshot by modifying CSS on…
- Sean
- 1 yr ago
- Get help
- Reported - view
Re: Why can't I move these formula fields?
@Rafael It's not looking good. I'll have to spend more time checking other options. This only partially works. html(" <style> .form .editor-html {float: left;…
- Sean
- 1 yr ago
- Get help
- Reported - view
Re: Why can't I move these formula fields?
@Rafael I won’t be able to look at it until this evening
- Sean
- 1 yr ago
- Get help
- Reported - view
Re: DB Size Problem
Ninox file format and Database size spiraling out of control are old threads, but as far as I know Ninox hasn't changed how data that is deleted in the database file is handled.…
- Sean
- 1 yr ago
- Get help
- Reported - view
Re: Limit Input to Rational Numbers in a Text Field
@我是我的我 I'm glad you found it useful. There is one small change to line 9 that one could add if negative numbers are used. TasN := replacex(TasN, "[^0-9.…
- Sean
- 1 yr ago
- Learn and share
- Reported - view
Re: Limit Input to Rational Numbers in a Text Field
I hadn't looked at this code in years, but I noticed that if you entered text and numbers it would return null. If you add line 9 it will remove anything that is not a number or single period so it…
- Sean
- 1 yr ago
- 1
- Learn and share
- Reported - view
Re: Please teach me how to use this global function :-)
@Alan Cooke You're going to kick yourself end; html(html) end
- Sean
- 1 yr ago
- Get help
- Reported - view
Re: How to display image in original quality?
Filip Serica said: I'm willing to go the HTML way if there is no other, but I have yet to figure out how to display an image that is uploaded to Ninox, with HTML.…
- Sean
- 1 yr ago
- Get help
- Reported - view
Re: Not Exit from a loop
@francesco.stefanello You might be able to skip the first 2 lines by using this... let coverimageLink := item(response.result, 0).resource_url It's similar to this thread.
- Sean
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Not Exit from a loop
If you only need the first item in the array you should just use the item() function. item(images, 0).resource_url The only for-loop style you can break out of is this one and you do it by changing…
- Sean
- 1 yr ago
- Get help
- Reported - view
Re: Search by Artist ? HTML
@Rafael Try single quotes with the Search by Artist field. You used double quotes. I know, my example used double quotes.
- Sean
- 1 yr ago
- Get help
- Reported - view

1 2 3 4 5 71

Welcome to the Ninox community

Sean

My Posts

Re: Help with multiline text field inside an html() function

Re: There must be a better way...

Re: There must be a better way...

Re: There must be a better way...

Re: v3.10.8 fixes

Re: Formula/Script behaves differently when in Full Screen View

Re: Formula/Script behaves differently when in Full Screen View

Re: onclick = ui.openRecord

Re: onclick = ui.openRecord

Re: onclick = ui.openRecord

Re: Copy to Clibboard button

Re: Why can't I move these formula fields?

Re: Why can't I move these formula fields?

Re: Why can't I move these formula fields?

Re: Why can't I move these formula fields?

Re: Why can't I move these formula fields?

Re: Why can't I move these formula fields?

Re: DB Size Problem

Re: Limit Input to Rational Numbers in a Text Field

Re: Limit Input to Rational Numbers in a Text Field

Re: Please teach me how to use this global function :-)

Re: How to display image in original quality?

Re: Not Exit from a loop

Re: Not Exit from a loop

Re: Search by Artist ? HTML

Overview