Banging my head against the wall trying to do a simple filter. I have 3 tables (things? ) Shops name address Product name Inventory shop qty product I am trying to display a repeating group of the 10 closest Shops within 100 miles of my current location and have that filtered by only shop…

Hi @jim1 , I would advise you to connect your Shops table with your Inventory tables resulting in the following changed table structure for Shops: Shops name address Inventory This way you can fairly easy perform a filter operation (the familiar “where” db call) on all shops you have in your rep…

Hi @jim1 :slight_smile: It may be faster to do a search for “Inventory”, with the constraints: Product = Dropdown product’s value Qty is greater than 0 If you don’t have that many Products being searched through, you could add an Advanced filter such as “Advanced: This Inventory’s Shop’s locatio…

Thanks for the advice. I did in fact start with inventory as you suggested and pulled the distance on the fly from the store table. The main issue I ran into there was I could not figure out how to sort the results by distance from the user. The idea of adding address to the inventory table does fe…

[image] jim1: Thanks for the advice. I did in fact start with inventory as you suggested and pulled the distance on the fly from the store table. The main issue I ran into there was I could not figure out how to sort the results by distance from the user. No problem at all! :slight_smile: Tha…

Ohh, got it! Is that happening when you upload the Stores? I agree with Neerja’s suggestion to store the address as a text first and then run an API workflow on that list to convert them to geographic addresses. Alternatively, you could manually use a searchbox element (set to type: geographic place…

If you start with the many-to-many (in this case the inventory) then you will sooner or later hit the hard bit … how to pick the “10 nearest” by sorting on distance from current user.

[image] NigelG: how to pick the “10 nearest” by sorting on distance from current user This is the bit I am working on right now. Searching the forum for any posts on the topic to generate some ideas. I have a R.G. of stores with geographic addresses. I then have an input on page for a user to…

@boston85719 did you find a solution to this? I am trying to do the same thing today in my app.

For my current use-case what you have mentioned here in this thread worked fine: [image] What happened to sort by distance from? Question I had thought that there would be an ability to do this using the :sorted by dynamic field , based on what the reference says [Screen…

Filtering lists

Need help Database

jim1 August 15, 2019, 1:23am 6

I am uploading via csv but ran into this issue Csv import timing out

Topic		Replies	Views
Geographic distance in more than one location and filter by closest to a location APIs	3	1324	July 11, 2022
Filtering a search by related thing's distance Need help	8	1896	April 21, 2025
Help with filtering distance of a user in a repeating group already searching a datatype (not the user datatype) Database	1	406	January 27, 2022
Advanced filter based on other table Need help	16	5067	August 23, 2017
Advanced search question Need help	37	7913	October 25, 2017

Filtering lists

Related topics