Hi Caleb @Sherbet4916,
I am not sure what is “best color lure”, but as I understood, your task can be split into 3 parts:
- Getting and storing data about a particular location.
- Calculating the overall rating for this location.
- Displaying the rating for this location.
Part 1: you need to get the values for each “data point” for a particular location. As an option, you can get this from a user. For example, on some screen you put several inputs: Weather, Wind, Tides, and ask a user to put a value 1-5 into each input. So you will store each value in a numeric format.
In order to store the values, you can use a separate collection. The structure could look like: Location_Ratings, which has 1:M relationship to Users (so one user can submit many ratings, but each rating belongs only to one user) and 1:M relationship to Locations (so one Location can have many ratings, but each rating belongs only to one location).
And in this “Location_Ratings” collection you’ll have properties for Weather, Wind, Tides, etc. So when a user enters the data, you create a new “Location_Rating” record with these numeric values.
So you have “Submit” button, which creates a new Location_Rating with all these values in the collection.
Part 2: you will need to calculate the overall rating for the location. This, in my opinion, is the most cumbersome part as you will need to implement the correct logic (and I can’t give any detailed advice here as I have no idea how best color lure is calculated).
If you imagine something like a hotel rating, the simplest way to calculate the overall result is to sum up values from all individual properties (Weather + Wind + Tides) and divide them by number of properties (3) to have an average. Of course, you will need to have a similar rating ranges for each property (each rated 1-5), or you will need to “normalise” the numbers before.
Such calculation can be easily implemented using Custom Formulas in Adalo and it can be stored in a separate “Final Rating” property.
So in your “Rate Location” screen, on the “Submit” button you add another action to update New Location_Rating (second action after Create Location_Rating), and you store the final rating using formula.
Part 3: And the final part is to display the rating. After you create and update Location_Rating, you can link a user to another screen. And on that screen you can use Star Rating component to display value from “Final Rating”.
P.S. This is a brief explanation how ratings could be implemented and I haven’t mentioned a lot of details. E.g. you can use dropdowns or star ratings instead of inputs to get initial data, formula calculations could be more complicated, etc.etc.etc.
Hope this helps.
Best,
Victor.