Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 25, 2023 02:14 AM
I have 10 fields with star ratings, is it possible for me to list the top 3 star rated fields in different field?
1 Reply 1
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 25, 2023 10:51 PM
Yeah, you would need to:
1. Create a new table called "Summary" or some such that had a single record
2. Create a new record in it with the primary field value of "Rollup" or something
3. Link all your existing records from your original table to that one record
4. Create rollup fields in your "Summary" field to sum up the star value of each field
5. Create a formula field that will output the name of the top 3 fields
