Skip to main content
Forum
Privacy
Contact
How to enable Javascript
Sign Up
Log in
Welcome to the Ninox community
Search all topics or
ask a question
Learn and share
Get help
Service status
Documentation
Solutions
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
Sotirios Zormpas
szormpas
Greece
523
204
2
Joined: Sun Nov 07 22:33:30 UTC 2021
Follow
My Posts
Latest Posts
Re: Trigger - Update Number Field with Formula Value - en masse
@wstarnes Hi, do you think using Trigger after opening your database would work for you?
Sotirios Zormpas
szormpas
1 yr ago
Get help
Reported - view
Re: Dashboard Template
@Kruna Hi, in this setup, there are four public URL links. There's one for each of the red, green and blue icon markers and one for the common shadow icon, as shown below:…
Sotirios Zormpas
szormpas
1 yr ago
1
Learn and share
Reported - view
Re: Dashboard Template
@Kruna you're more than welcome! Just a quick note: the leaflet library pulls the icon from a shared URL link, as you'll see in the code. It's important to create your own shared URL links for the…
Sotirios Zormpas
szormpas
1 yr ago
1
Learn and share
Reported - view
Re: Ninox 3.13 available
@Rafael Hi, we are all waiting for the patch to fix this important issue!
Sotirios Zormpas
szormpas
1 yr ago
Learn and share
Reported - view
Re: Dashboard Template
@Kruna Hi there! I'm so happy you like it! I've prepared a special edition for you, version 7.3 with custom icons instead of circles. I hope this is what you're looking for!
Attachment
Sotirios Zormpas
szormpas
1 yr ago
1
Learn and share
Reported - view
Re: FeatureRequest: Show FunctionDefinition in Editor
@Frank Wiebeler Hi, I'm on the same page. I often don't remember the syntax of a function, so I always have to open a tab in the browser with the Ninox documentation page where I have to search for…
Sotirios Zormpas
szormpas
1 yr ago
2
Learn and share
Reported - view
Re: Separating List into Objects
@Sotirios Zormpas and this is the new array version: let array := ["Red", "Green", "Blue"]; let newArray := for loop in array do if loop = "Orange" then "true" else "false" end end; newArray
Sotirios Zormpas
szormpas
1 yr ago
Get help
Reported - view
Re: Separating List into Objects
@S Moore Hi, you could consider using the contain() function instead of loop like below: let array := ["Red","Green","Blue"]; if contains(array, "Blue") then true else false end Just to check,…
Sotirios Zormpas
szormpas
1 yr ago
Get help
Reported - view
Re: Main Menu
@Angel Del Pino Velez Hi, if there's anything else we can help you with, just let us know.
Sotirios Zormpas
szormpas
1 yr ago
Learn and share
Reported - view
Re: Dashboard Template
Version 7.3 Map improvements: Hi everyone, custom markers are a great way to get creative since any image can be a marker on our map. However, if you want each point to have its unique one,…
Attachment
Sotirios Zormpas
szormpas
1 yr ago
1
Learn and share
Reported - view
Re: Relative record numbers in a table
Hello @brentjl1 , I think we've got to the bottom of the issue. We were both trying to solve the same problem! Your code works perfectly in the case where the record IDs are strictly sequential, i.e.…
Sotirios Zormpas
szormpas
1 yr ago
Get help
Reported - view
Re: Ninox 3.13 available
@Paul Chappell me too! It looks like an old issue has come back again!
Sotirios Zormpas
szormpas
1 yr ago
Learn and share
Reported - view
Re: Main Menu
Hello @Angel Del Pino Velez , Take a look at the link below for a template that might give you some ideas: Dashboard Template
Sotirios Zormpas
szormpas
1 yr ago
1
Learn and share
Reported - view
Re: Relative record numbers in a table
@John Halls Hi, is there any way to avoid the select statement in this particular problem?
Sotirios Zormpas
szormpas
1 yr ago
Get help
Reported - view
Re: Relative record numbers in a table
@brentjl1 As you say, it's a special case and I am not sure if I completely understand your code. I think your post has brought to the surface an interesting problem to solve.…
Sotirios Zormpas
szormpas
1 yr ago
Get help
Reported - view
Re: Relative record numbers in a table
@brentjl1 , Could you please share your code that you use within the formula column? Ninox doesn't display row numbers in view elements by default, so it's useful for all of us to have the best…
Sotirios Zormpas
szormpas
1 yr ago
Get help
Reported - view
Re: Relative record numbers in a table
@Sotirios Zormpas The subset of the table must be the same both in the View and in the above code within a formula column of the View.
Sotirios Zormpas
szormpas
1 yr ago
Get help
Reported - view
Re: Relative record numbers in a table
Hi @brentjl1 If I have understood what you want correctly, one solution I have come up with is the following: let t := this; let arrayIDs := for loop1 in (select Table) order by number(Id) do loop1.…
Sotirios Zormpas
szormpas
1 yr ago
1
Get help
Reported - view
Re: Ninox 3.13 available
@Alan Cooke click on the Ninox logo to open the Workspace settings.
Sotirios Zormpas
szormpas
1 yr ago
Learn and share
Reported - view
Re: Upload file with Ninox API REST
@Jacques TUR Thanks for taking the time to explain this in more detail.
Sotirios Zormpas
szormpas
1 yr ago
Learn and share
Reported - view
Re: Ninox 3.13 available
@Alan Cooke Hi, it looks like the sidebar colour changes automatically when you alter the colour of the top bar!
Sotirios Zormpas
szormpas
1 yr ago
Learn and share
Reported - view
Re: Ninox 3.13 available
@Rafael Hi, I faced the same issue, I've solved it by covert h1 to h2 and h2 to h3. Just reduce the size of headings.
Sotirios Zormpas
szormpas
1 yr ago
Learn and share
Reported - view
Re: Dashboard Template
@我是我的我 To share the file, just open the 'Red Marker' record of the 'Photos' table and click 'Share this file...' from the menu-burger icon. I'll be back soon with something even better!
Sotirios Zormpas
szormpas
1 yr ago
1
Learn and share
Reported - view
Re: Upload file with Ninox API REST
Hi, I just wanted to thank you for sharing the above code with us. It's really beneficial and educational! I hope you don't mind me asking, but I'm a little confused about why we need to convert the…
Sotirios Zormpas
szormpas
1 yr ago
Learn and share
Reported - view
Re: Complex criteria for Select
@Jacques TUR I thought that after the 'where' the condition should be related to the selecting table, but it turns out it can evaluate anything! I can't thank you enough!
Sotirios Zormpas
szormpas
1 yr ago
Get help
Reported - view
1
9
10
11
12
13
21
Ninox-Website
Overview
Learn and share
Get help
Service status
Documentation
Solutions
Ninox E-Invoice
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
Templates
Use cases
Automation
Performance
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Backups and storage
Process monitor
View all topics