Skip to main content

Ninox-Documentation

Sotirios Zormpas

szormpas

Greece

381
144
1

Joined: Sun Nov 07 22:33:30 UTC 2021

My Posts

Latest Posts

Re: Display extensive datasets via a custom HTML table.
@Rafael Sure, you will find a tiny portion of the dataset attached, including only the first 150 records. Let me know whether you can upload the DB now.
Attachment
- szormpas
- 5 mths ago
- Learn & Share
- Reported - view
Re: HTML Pivot Table
@Fred Hi, this is an interesting approach that I haven't been though about, breaking down the ininial dataset into one or more table if feasible. Indeed,…
- szormpas
- 5 mths ago
- Learn & Share
- Reported - view
Display extensive datasets via a custom HTML table.

Hello everyone, Following up on my previous post, I am happy to share the lessons I have learned working with an extended dataset. Although Ninox offers many ways to present data,…
- szormpas
- 5 mths ago
- 4replies
- 250
- 3
- Learn & Share
Re: View of contacts with large number of rows
Hi EriΚ, I've been trying to find a solution to a similar problem that has to do with managing a large amount of data, and I'm trying different approaches.…
- szormpas
- 5 mths ago
- 1
- Get help
- Reported - view
Re: HTML Pivot Table
@Rafael your table is nice and offers new features for integration (e.g Choice Options). It looks like you are also using an HTML table with the same logic (you can call it Pivot or Crosstab).…
- szormpas
- 5 mths ago
- Learn & Share
- Reported - view
Re: HTML Pivot Table
@Fred you are right, I did use the "do as server" and the html() showed nothing!
- szormpas
- 5 mths ago
- Learn & Share
- Reported - view
Re: HTML Pivot Table
I have tried tweaking the code further by using "do as server," "do as transaction," and "cached()," but nothing seems to improve things. Maybe it's time to consider "pagination.…
- szormpas
- 5 mths ago
- Learn & Share
- Reported - view
Re: HTML Pivot Table
@Rafael It's possible that the difference in seconds is also due to the speed of everyone's internet connection.
- szormpas
- 5 mths ago
- Learn & Share
- Reported - view
Re: HTML Pivot Table
@Fred I actually use the public cloud and the secs I mention are for that. What initially attracted me to Ninox was the idea of a centralised database in the cloud,…
- szormpas
- 5 mths ago
- Learn & Share
- Reported - view
Re: HTML Pivot Table
@Fred 9 secs...so far so good!
- szormpas
- 5 mths ago
- Learn & Share
- Reported - view
Re: HTML Pivot Table
Thank you@Fred , I appreciate your insights. While I understand the benefits of creating a new JSON object, in my specific case, the data is already there and requires no further configuration.…
Attachment
- szormpas
- 5 mths ago
- Learn & Share
- Reported - view
Re: HTML Pivot Table
UPDATE: 10X speed improvement! I improved the speed of data display by at least ten times, from about 20 seconds to less than 2 seconds, by removing the nested “for” loop inside the body variable .…
- szormpas
- 5 mths ago
- 1
- Learn & Share
- Reported - view
HTML Pivot Table

Hello everyone, In my application, time series data (screenshot 1) are often needed to be managed and presented in a practical way. Since Ninox does not yet allow us to insert a pivot table view into…
- szormpas
- 5 mths ago
- 20replies
- 484
- Learn & Share
Re: I need to iterate a json object.
@RoSoft_Steven great! I've learned something new today! So, we can loop inside a json object if we declare two labels (variables) one for the "name" and the other for the "value" in the "name/value"…
- szormpas
- 5 mths ago
- 1
- Learn & Share
- Reported - view
Re: I need to iterate a json object.
@CISOFT Sàrl is the code below what are you looking for? let Data := { myObject: [{ paul: "10" }, { jack: "20" }, { bob: "30" }] }; join(for i in Data.myObject do text(Data.myObject.…
- szormpas
- 6 mths ago
- Learn & Share
- Reported - view
Re: I need to iterate a json object.
@CISOFT Sàrl item(myJSON, key) To extract the value of a key-value pair of a given JSON object. The key might be a string or a number. I think you can not iterate a json object using item function…
- szormpas
- 6 mths ago
- Learn & Share
- Reported - view
Re: I need to iterate a json object.
@CISOFT Sàrl Hi, according to the Ninox documentation you can use the item() function with a json object like below: let data := { firstName: "Steve", lastName: "Rogers" }; item(data, "firstName")
- szormpas
- 6 mths ago
- Learn & Share
- Reported - view
Re: 3.12 webinar link
The same for me
- szormpas
- 6 mths ago
- Get help
- Reported - view
Re: Embedded eCharts into Ninox
@M. Daaboul thanks again, your advice has helped us a lot to get familiar with the use of eCharts library. If you have some time could you explain what you mean by "- Ideally,…
- szormpas
- 6 mths ago
- Get help
- Reported - view
Re: Embedded eCharts into Ninox
@Nick Hello Nikos, thank you for helping us improve our understanding of how to present our data.
- szormpas
- 6 mths ago
- Get help
- Reported - view
Re: Need help with my JS/HTML Kanban Board
Hi @MP I realize now that many of the problems I encounter when trying to run javascript snippets inside the html() function are precisely due to delay issues. See in this post how @M.…
- szormpas
- 6 mths ago
- Get help
- Reported - view
Re: Embedded eCharts into Ninox
@M. Daaboul thank you, your code example works nice and your hints are very helpful!
- szormpas
- 6 mths ago
- 1
- Get help
- Reported - view
Embedded eCharts into Ninox

I have tried to embed eCharts into Ninox but have yet to succeed. For example, I put the following code inside a function field, but nothing: var _style := "* { margin: 0; padding: 0;…
- szormpas
- 6 mths ago
- 15replies
- 257
- 1
- Get help
- Answered
- Answered
Re: CSS Framework & Ninox
@Fred Hi, that's great news, I am looking forward to seeing the 3.12 release…the new 3000 icons are wowing me!
- szormpas
- 6 mths ago
- Learn & Share
- Reported - view
Re: CSS Framework & Ninox
@我是我的我 Unfortunately, I don't have a written guide for all the above steps in detail, but I could help you with individual steps if you want to experiment with a CSS framework.…
- szormpas
- 6 mths ago
- Learn & Share
- Reported - view

1 10 11 12 13 14 15 16

Back to top

Ninox-Documentation

Overview

View all topics