As we are doing rapid app development on Bubble.IO during Christmas break and skipped the video tutorial as usual :), we found a couple of challenges on how to do things as we are getting used to with code and SQL query in general.
Here is some finding that we found and we would like to share them as we move along.
Design: Browser Viewing Size
With the pages that have a wide data table, the 1080 width size is too small to fit the data columns. Based on this article - Recommended Screen Resolution for Web Design (thewhitelabelagency.com), we increased to 1366 x 768 at least cover 72+% of the users.
Query: Not including the last entry date
This query is to get the all record excluding the last entry date:
We have a relationship between two Data Types which are Round and Hole. Hole. Each hole associated with a single Round while each round will have many holes. I deleted the Round record which has many Hole records and it's common behavior. However, the Hole will NOT get deleted and the Hole records will become orphan records.
Advanced option under :filtered
We have a Data Type called Hole and it has two fields called HoleScore and HolePar and I want to know the score gain in golf (birdies or better) per found and to do this I need to filter the records where (HoleScore - HolePar) < 0 and then count the filtered records.
Something like this in SQL perhaps:
SELECT Count(HoleScore) FROM Holes WHERE (HoleScore - HolePar) < 0
After googling and end up posting to the Bubble.IO forum, apparently, there is an option called Advanced under the :filtered and constraint. You can achieve quite easily to construct that query above.
Here's the image to illustrate the query:
Dashboard UI Kit + Landing - https://bubble.io/template/dashboard-ui-kit-+landing-1551439399417x807603185105764400
Zeroqode Templates, Plugins, Blocks, Backends and Native - https://zeroqode.com/
Hope you find this post very useful.
Please leave us a comment below.
3,370 total views, 49 views today