Skip to main content

Forum

Welcome to the Ninox community

Search all topics or ask a question

Latest Posts

Re: If a text field has > 30 '#' then show alert
"e.g i can use the concat() function to extract the full address from a location field, but is it possible to then extract only the street name and number?" 🤔
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Images not displaying in html() function - Ninox ver 3.2.7
Still broken in version 3.2.9
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Help with sorting on 4 columns
😎 I'll keep that in mind the next time I do a 16+ column sort.
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: loop failure
Phillip, You never increment "counter" so it looks like you have an infinite loop.
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Copy to Clibboard button
Max, I don't know which version you are using, but this one worked for me... html("<button onclick='copyToClipboard(""" + 'Formula Field' + """)'>Copy to clipboard</button><script>function…
- Sean
- 4 yrs ago
- Get help
- Accepted
- Reported - view
Re: If a text field has > 30 '#' then show alert
As far as I can tell there isn't any difference between text(Location) and concat(Location) and if you test for equality you'll get true. I'm not super happy with these solutions,…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Help with sorting on 4 columns
The problem with using the format() function is the same as with the text() or concat() functions. Sorting will be based on the numbers' ASCII values and not their numeric values.
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Help with sorting on 4 columns
When you concatenate numbers, they are converted to text and sorted as text. I would multiply each value by an appropriate weight and then sum the values.
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Bugs waring current version 3.2.6 or 3.2.7 MacOS application
netSME_Sylvain Moesching, Thank you.
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Bugs waring current version 3.2.6 or 3.2.7 MacOS application
netSME_Sylvain Moesching, Would you mind listing the bugs you encountered.
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Bugs waring current version 3.2.6 or 3.2.7 MacOS application
Images still don't display in the html() function using version 3.2.8
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Photo field alignment
Bump... because of spam
- Sean
- 4 yrs ago
- Learn and share
- Reported - view
Re: Images not displaying in html() function - Ninox ver 3.2.7
Bump... because of spam
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Photo field alignment
Blued, I updated to the latest version of Ninox and now I get the same result you have gotten. Hopefully, they will get this bug resolved soon.
- Sean
- 4 yrs ago
- Learn and share
- Reported - view
Images not displaying in html() function - Ninox ver 3.2.7

I didn't update to the latest version because of the complaints, but then I started seeing positive comments about the latest version. I downloaded version 3.2.…
- Sean
- 4 yrs ago
- 4replies
- 504
- Get help
Re: Photo field alignment
Yes, that is how Ninox organizes and stores attachments. The letter is the table and the number is the record id. See if you can find a number folder with a file in it and try that image.
- Sean
- 4 yrs ago
- Learn and share
- Reported - view
Re: Photo field alignment
You don't need to upload an image for this... Please copy and paste the result of the formula without the html() function. Then, follow the file path in Finder all the way to the image file in that…
- Sean
- 4 yrs ago
- Learn and share
- Reported - view
Re: Photo field alignment
Blued, That should be ok. As long as you aren't trying to display it in one of the table views, Table, Sub Table, View layout element, but it doesn't sound like that's what you're doing.…
- Sean
- 4 yrs ago
- Learn and share
- Reported - view
Re: Photo field alignment
Here it is without the "style" part... html("<img src=""/Users/YourUserName/Library/Containers/de.ninoxdb.ninox-mac.Ninox/Data/Documents/data/YourDatabaseName/files/" +…
- Sean
- 4 yrs ago
- Learn and share
- Reported - view
Re: Photo field alignment
Blued, As long as you are doing this in a Form view and not a View layout element, it should work. The problem might be using the "this" keyword. I was able to display more than one image this way...…
- Sean
- 4 yrs ago
- Learn and share
- Reported - view
Re: Image Field Position
Mel, It's not too surprising that the designers told you it's designed to work like that 😁. If you don't want to wait, the workaround is there. Happy New Year to you too.
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Inconsitancy by data aggregation
Hi Alain, Do you have an example number or calculation that demonstrates that they are using BFP. I tested the numbers that are in the other threads and can't duplicate the problem as it existed then.…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Photo field alignment
If you know that there is only one image attached per record you can use this formula and you only need to enter your Mac user name and the Ninox database name.…
- Sean
- 4 yrs ago
- Learn and share
- Reported - view
Re: Photo field alignment
Hi Blued, From the outside to the inside... The html() function lets you run HTML, CSS and some JavaScript in a Formula field. <img src=...> is just an HTML image tag.…
- Sean
- 4 yrs ago
- Learn and share
- Reported - view
Re: Image Field Position
You can do it using a Formula field and the html() function. This is how you can do it using the Mac app and a local database... html("<img src=""/Users/YourUserName/Library/Containers/de.ninoxdb.…
- Sean
- 4 yrs ago
- Get help
- Reported - view

1 21 22 23 24 25 71

Back to top

Overview

View all topics