Glad I could help! What are you building?

@@WizedWarlock Building a website that needs some ability to filter database results based on location. Kinda like real estate "search for results in this area features.". Maybe adding a map in the future, and show results within that map view, but keeping it simple to start with. I'll add you on linked in. Keen to see what other stuff you're doing.✌

@@loicleray Awesome man! Mapbox has an API that will calculate distances & create boundary boxes which can help filtering, even if you don't have a map to use. Feel free to reach out if you need any help!

@@WizedWarlock thanks man, figuring out how to have it work with postgis at the moment. Looks like you do backend stuff as well as the low-code platforms for freelance clients?

Glad I could help!

@@abdlsuheel4674 Sure, contact me here: [email protected]

Hey! You are right this video doesn't cover all the details inside of Wized, it's more of a focus for the server-side (Xano). As for "contains" it's a search operator for a table, searching for fields that Contain your input! If you have any more questions, or are struggling, feel free to send me an email and I'll help out where I can :)

@@WizedWarlock Hey thanks for reply, I manage to make my search work after few tries and errors but how can I display the entire list of items before search? So basically when I access my page first time it wouldnt be empty. Thanks again

webflow.com/@wizedwarlock here mate

Thanks! I recorded it in Screen Studio and edited it in DaVinci Resolve :)

Glad It helped!

😅 Too soon!

@@WizedWarlock 😅

Glad I could help! Just replied too :)

Great question! Having dynamic filters stored in the table is a good idea, although depending on the number of filters. It could be a better idea to create a separate table. Let's call it “filters”. You can reference the “listings” table using an ID and have as many columns as you’d like for filtering, you could even introduce other table references (category, bookings etc). Then creating an Addon for the “filters” table to extend your “listings” API endpoint would allow you to return all the filter fields you want. For the “listings” API endpoint you’d still need a very broad number of inputs, or at least one input for every column in the “filter” table. I would have all the filter options built in webflow as dropdown menus, set to hidden. Then I’d only show the ones that didn’t return as null inside the response (in case you have some filters that don’t apply) This is a good idea for a video, I’ll put it on my list. Hope this helps!

​@@WizedWarlock Thanks for taking the time to outline the solution-this helps a lot and comes just at the right time! 🙏 Keep up the good work with the WWX stack content-we're so early! 🔥

Thank you kindly!

Thank you for your feedback! It means so much!

Hey Carlo. Rendering 600 items on the map won't be much of an issue as far as the length of time it takes to render the map and it's properties. However it would be worth considering the UI issues of having that many icons on a map (depending how close together they are). I would take one of three approaches: 1: Cluster my data so that they display as icons showing their count for a specific area. They can then disperse on zoom. Difficulty - Easy. More about that here: docs.mapbox.com/mapbox-gl-js/example/cluster/ 2: Have either a server-side/client-side filter for the data that is set when the map loads I.E You have 300 rental properties and 300 for sale properties, but you choose either one to display on load, then your user can change the filter from there. Difficulty - Intermediate. 3: Build a function that finds the edges of the map viewport and then only displays a set amount of icons inside of that viewport. Whilst allowing it to recalculate the edges every time you zoom, giving the effect of it “refreshing” the map as you zoom in and out. Difficulty - Hard. I will be doing more videos on mapbox in the future so if you’d like to see something in particular, feel free to request it. Hope this helps!

@WizedWarlock I was considering going down the cluster route, to be honest. Was just checking in to see if you think it could have some loading issues in wized. May I ask why you chose to use the address for markers as opposed to the xano's built-in geo_point field?

​ @carloking2163 I don't think you'll run into any issues with it loading in wized. The reason I didn’t use geopoints in this case is simply because Xano doesn’t have an inbuilt function or API that can convert addresses to lat/lng. It’s mainly manual work inside the database. You’ll still need to have a external API to get the lat and lng dynamically when new data was posted to your database. If the dataset is small, I’ll just use the mapbox api to translate it on the client-side. However in your case with 600 items. I would opt to store that lat and lng in my database and void the client side request, as to not use up my geocoding api calls on my mapbox account, (I think it’s 10,000 items a month). If you need any help in the future with this, feel free to contact me!

@WizedWarlock sent a request through your site mate 😁 Maybe it's a newer feature but when we were adding in the geo_point fields. We just typed in the name of the place and it was able to load the lat/lng directly inside the table which is pretty nice.

@@carloking2163 Awesome! I am familiar with the address search for the table. However I'm not sure if you can formulate a post request to that table/column that will convert your address input into lat and lng natively. It works manually but to set that up dynamically I think it might require an external API....However I will do some more research on that 😄

Glad it was helpful!

Thank you! ♡

Just finished watching one of your videos and saw this pop up. Love your work!

@@WizedWarlock 🙏💛

Hey Jet! Sorry for the late reply. I got this Geojson from mapbox. They have a data source thats free to use. docs.mapbox.com/mapbox-gl-js/assets/us_states.geojson. This however only goes over US states. You can directly style/create your own in mapbox studio by creating a dataset (a lot of clicking and mapping) or use the mapbox boundaries tileset (paid). Let me know if this helps!