Calculations using proximity and lowest value

Need help Database
1

Hello!
First let me explain:
Two types of users

  1. Users who want their dog to be walked
  2. Users who are willing to walk dogs

I want multiple different users to input data (price per hour/location) for dog walking to be done.
I then want another user to be able to receive an output that takes into account the price offered by the dog walkers, the proximity, and the ratings. I want only the best to be output (given a weight assigned by the user: “I prefer if they were close more than rating”).

Is this possible? Specifically, the weighting and calculations on the backend database?

2

Yes I believe it’s possible.

Use ‘distance from’ to assign a weight
Assign a weight to the price
Assign a weight to the review

Add or average your weights to your personal ‘flavor’. You can use custom state and or programed workflows, repeating lists, conditionals… so forth

Rick
Freelance