8

Dashboard Template

Hello everyone!

After the    post, I decided to start a new one. This will make it easier to follow the changes.

New features have been added:

  • Sticky buttons. Thanks to   CSS hacks, I was able to make the buttons component sticky. Now the buttons always remain visible to the top of the page as we scroll down.
  • Scroll into View. By clicking a button the page automatically scrolls into the correspoding section. In the attached database press the first button "Accounts" to see it in action.

The combination of the above two features has the potential to transform the way we design our Dashboards. Like the one-page websites, we can present our content in sections on one long Dashboard.

In Safari works but I haven't check it in other browsers. Let me know if you find any bug.

What other functionalities would you like to see?

Leave here your suggestions, ideas or improvements!

Enjoy!

198 replies

null
    • szormpas
    • 3 mths ago
    • Reported - view

    Version 6.0

    New feature:

    Real-time weather data right to your home section by calling the tomorrow.io API. I've set the location to New York just to show you what it looks like! You can easily change the location 'Value' field inside the 'Settings' subtable. It accepts the following formats:

    • Latitude and Longitude (Decimal degree) location=42.3478, -71.0466
    • City name location=new york
    • US zip location=10001 US (2-letter code based on ISO-3166)
    • UK postcode location=SW1  

    I'm happy to leave my API Key so that everyone has a chance to test out the service. Just a quick heads-up, though, there are limits on requests (3/sec, 25/hour, 500/day). But there is a free account tier, so just create one and paste your API Key inside the 'Settings' subtable.

    This company seems promising but I am not sure how accurate the results we get are. If you know of a better weather API, I'd love to hear about it! 

    Improvements: 

    • Responsive layout for both the 'Home' CSS flexbox and 'Dog Stats' CSS grid. I used @media CSS queries to make it all work together seamlessly. On smaller devices, the layouts switch to a single column, which is great for viewing the charts one after the other.
    • No dependencies on external sources.  I've downloaded and saved the eCharts js library, the Phosphor icons stylesheet, and the weather codes into the 'Sources' subtable for you.

    All the best! πŸ™‚

      • gold_cat
      • 2 mths ago
      • Reported - view

       thanks!

    • szormpas
    • 3 mths ago
    • Reported - view

    Version 7.0

    Maps:

    Hello everyone,

    I'm really happy to share the latest version of Dashboard with you because I've incorporated a feature that I'm so excited about and I hope you'll love it too! The ability to display dynamic maps within Ninox is something many of us have been asking for and I'm so pleased to present the leaflet.

    The Leaflet is a well-known, mature, super lightweight JavaScript mapping library with an active community. It's open-source and it gives us the power to do amazing things like add markers, popups, overlay lines, and shapes, use multiple layers, zoom, pan, and so much more. You can find plenty of examples in this free online book. As you can see in the screenshot, the map automatically shows markers for each address in the 'Accounts' table (on click, a nice popup appears that displays the Name).

    Leaflet doesn't provide maps, but don't worry! It's provider-agnostic, which means you can easily call a map tiles API to get the map you need. Of course, you can use the OpenStreetMap API, which is completely free and open-source. Their maps are raw (precision but not neat), but they're great!

    I've been looking into this a bit, and I've found two companies that might be worth checking out: Stadia Maps and MapTiler. I'm going with the Alidade Smooth-style map from Stadia Maps. I just love its muted color scheme and fewer points of interest, which makes it ideal for data presentation. If you want to use any of their maps, create a free account and copy their API call URL (including your API key) inside the 'Settings' subtable. I'll leave my API key for now, so you can see how it works.

      I was wondering if you think it might be worth trying to download the library and make it work from the Ninox backend. I gave it a go myself, but I couldn't get it to work. Maybe the issue has to do with some icons that are used by the library, but I'm not sure how to modify the code to access them from a Ninox shared link. I've noticed that the Leaflet map hides the option wrench of the parent Ninox element, which we could probably fix by downloading the library and modifying the z-index values. Either way, it's not a big deal, but I'd love to hear your thoughts!

     I've already centred the map on Madrid for you, so you can easily test it! Let me know if there's anything else I can help with.

      could this particular implementation meet your needs in China as well?

     I saw your earlier post about using Google Maps with multiple markers. I was just wondering if you think Leaflet could be a cheaper alternative that's also functional and powerful. I'd love to hear your thoughts!

    Enjoy! πŸ™‚

      • gold_cat
      • 3 mths ago
      • Reported - view

       
       

      This is an amazing piece of work! Thank you to  for all your contributions. Here are a few issues I've encountered, and I hope addressing them will make things even better.

      1. In a previous map case, I considered whether clicking on a marker on the map could pop up the corresponding entry in the table, which would be more intuitive. However, I haven't been able to achieve this yet.
      2. I noticed that there are images of marker icons in the Photos table. Does this mean I can customize the color of the marker icons displayed on the map? I couldn't find the relevant code, so I'm wondering if multi-colored marker icons can be implemented.
      3. After entering the database, I occasionally encounter the following prompt (shown in the image). What could be the cause of this issue?

      Thank you again.

      • szormpas
      • 3 mths ago
      • Reported - view

        Hi,

      Regarding your 3rd point, It looks like Ninox is getting an error response when it calls the weather API. There are rate limits, so just a friendly reminder to get your own API key and replace mine within the 'Settings' subtable if you haven't already done it.

      I think the first two points are doable with the leaflet, at least I'll give it a go!

      • gold_cat
      • 3 mths ago
      • Reported - view

       Thank you for your reminder, and thank you for your dedication.

    • szormpas
    • 3 mths ago
    • Reported - view

    Version 7.1

    Map improvements:

    • On mouse hover, the marker displays a tooltip with the first and last name of the corresponding 'Account' record.

    • On mouse click, the corresponding 'Account' record popups.

    Have fun!πŸ™‚

    • szormpas
    • 3 mths ago
    • Reported - view

    Version 7.2

    Map improvements:

    Hey there! You can now add some gorgeous custom icons to your map! Have fun finding or making your favorite icon and save it inside the Dashboard Photos subtable. Then, create a sharing URL and paste it into the respective code field.

    Enjoy!πŸ™‚

      • gold_cat
      • 3 mths ago
      • Reported - view

       

      I accidentally refreshed and found another update! Sotirios Zormpas resolves issues faster than I can raise them. Sorry, I’m back with another question.

      I noticed that the location within the China region seems to have some offset in the actual positioning (as shown in the video). How can this be addressed, my friend? So far, this issue has only been observed on the iPhone.

      • gold_cat
      • 3 mths ago
      • Reported - view

       

      • szormpas
      • 3 mths ago
      • Reported - view

         Hi, I am experiencing the same issue when opening the Dashboard using the Ninox app on my iPhone.

      Interestingly, when I use the web app on my iPhone via Safari or Chrome, everything works perfectly.

      It seems that the problem is related to the native Ninox app. I'd like to know if you can check if the same behavior also occurs on Android phones (I don't have one).

      The good news is that we can access the Dashboard on the iPhone via the web app, which, I can say, for my taste, looks better than the native app.

      • Rafael Sanchis
      • Rafael_Sanchis
      • 3 mths ago
      • Reported - view

       

      hi Sotirios in which version do you have the problem ? And what is the problem ? I have Android phone and tablets,on tablets all work perfect

      • gold_cat
      • 3 mths ago
      • Reported - view

       
      Hi, I think I might have identified the issue. My iPhone is using a map service from a Chinese provider, which calculates latitude and longitude differently than Google or other map services, resulting in coordinate discrepancies. If Ninox on the iPhone were to use Apple Maps directly, there might not be any problem.

      • szormpas
      • 3 mths ago
      • Reported - view

        Hi, could you please download the latest version 7.2, and check if the map markers work as they should on your Android phone and table?

      • Rafael Sanchis
      • Rafael_Sanchis
      • 3 mths ago
      • Reported - view

       

      yes I place my address and perfect

      • szormpas
      • 3 mths ago
      • Reported - view

       That's great, thank you for testing!

    • gold_cat
    • 3 mths ago
    • Reported - view
     said:
    Then, create a sharing URL and paste it into the respective code field.

     How to create shared links?

      • szormpas
      • 3 mths ago
      • Reported - view

        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!

    • szormpas
    • 3 mths ago
    • Reported - view

    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, it can become a bit time-consuming since you must introduce a new PNG file for each. In this version, I've added a few cool features to make the map more functional.

    • Circle markers: The component lets you draw circles with a radius you specify in pixels (so the size in meters changes with zoom). You can use it to set the radius, width, colour, fill colour, opacity, and so on.
    • GeoJSON: This is a special type of JSON object that's used to represent vector geometries, with or without non-spatial attributes. GeoJSON is a really popular format for mapping data, and Leaflet is great at handling it. Since Ninox scripting makes it so easy to construct JSON objects, we can present any data from our database on the map in whatever way we want. On top of that, we can also import external GeoJSONs. If you want to create your own, there's a really easy way to do it with geojson.io.
    • Multiple maps: You can load a few different base maps, so the user can choose one that suits them best.
    • Filtering and grouping: The library can filter the data based on geojson properties, which means we can create groups and show them on the map in a selective way.

    In my example, you'll find a layer control panel in the top right corner where you can choose a base map and filter the markers based on the status field of the Accounts table.

    Enjoy!πŸ™‚

      • gold_cat
      • 3 mths ago
      • Reported - view

       this is so cool~~

      • Kruna
      • 3 mths ago
      • Reported - view

       this is so awesome!! πŸ‘ thank you very much for sharing your dashboard version - I like it a lot especially the map. I took a look at the v7.2 where icons are used ( somehow I didnt get it adapted), but I like v7.3 much better and it worked for me. 

      I have a question about the map - I wonder if its possible to use different icons instead of the circles?

      thanks a lotπŸ™‚

      Kruna

      • Rafael Sanchis
      • Rafael_Sanchis
      • 3 mths ago
      • Reported - view

       

      Welcome Kruna. Yes the Map is excelent.

      • szormpas
      • 3 mths ago
      • Reported - view

        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!

      • Kruna
      • 3 mths ago
      • Reported - view

       omg, this is absolutely amazing! I am impressed and overhelmed, incredible.

      This is exactly what I was looking for, thank you so much for taking the time to recreate the database. I've never been in a forum where people are so kind and ready to help at any time.

      Χίλια Ξ΅Ο…Ο‡Ξ±ΟΞΉΟƒΟ„ΟŽ  β˜ΊοΈ 

      Kruna

      • szormpas
      • 3 mths ago
      • Reported - view

        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 icon markers you'll use in your database.

      • Kruna
      • 3 mths ago
      • Reported - view

       πŸ‘

      About your quick note - did you read my mind? 😊 I was about to ask about the shared URL link, but then it worked somehow.

      But still I would like to understand the use of shared link as I thought its only one link to share, but it is not like that right?

      Your link shows the icons and when I entered my link the icons also showed up and when I click 'Share this file...' from the menu-burger icon its always a different shared link. So once I use a shared link I shouldnt 'generate' another one - is that right too?

      Another question comes up into my mind - is it possible to share this map with clients even though they dont have ninox? I guess its surely required, but maybe there is another way.

      Thanks for your help.

      Cheers Kruna

Content aside

  • 8 Likes
  • 4 days agoLast active
  • 198Replies
  • 2239Views
  • 15 Following