I don’t think this was for this thread as it will be a bulk action not a scheduled api workflow and I’m simply trying to filter out the Things within 250 miles that are already in the database and preserve, essentially, the Things that are between 250 miles and 500 miles from the Thing’s fixed address.
Don’t mean to add to confusion here so last point Bulk actions run an API workflow on the database entries in the current view. So if you have a large List A that contains a small List B where List B already had the bulk action run on it, if there is a database field that shows the action was run, you can either modify the database view with a constraint on that field or update the endpoint workflow action itself for that field.
i think what you are looking for is that when you do the search for within 250km you trigger a workflow: makes changes to thing, set a list of search results (a datafield that is a list of eg locations)
then when you do the 500km search, makes changes to thing and use the merge or remove list functions
maybe you can also use states to save the results