Hello, We are a company looking to streamline our internal tool selection process. We've set up a system using Formidable Forms, but we're encountering an issue with displaying ratings. Here's our setup: 1. "New Tool Submission" form: Users submit new tools with relevant information.
2. View 1: Displays a list of all submitted tools with basic information. Each tool name links to a details page.
3. Details Page: Shows all submitted information about the tool and includes a "Rating Form" at the bottom.
4. "Rating Form": Allows company users to rate the tool using a scale field. We've successfully linked the ratings to their respective tools using a hidden field that captures the tool's entry ID. The challenge we're facing is with our new view, "Rated Tools-Overview". This view should display all tools again, but with an additional column for the average rating. This average should reflect all user ratings for each tool, allowing us to rank tools based on their ratings. Despite numerous attempts with various shortcodes, we can't get the ratings to display in this new column. We've tried embedding the "Rating Form" within the main tool submission form and using different shortcode combinations, but nothing seems to work. Our current setup:
- Main form ("Tools", ID: 2): Contains tool information
- Rating form ("Rating Form", ID: 4): Contains the scale field for ratings (Field ID: 37)
- We've embedded the rating form into the main form (Embedded Form Field ID: 63) We've attempted shortcodes like:
```
[frm-field-value field_id=37 parent_form_id=2]
[frm-field-value field_id=63 entry_id=[id] form_id=2]
[frm-stats id=4 field_id=37 linked_field_id=63 entry_id=[id]]
``` But none of these display the ratings correctly in our view. We would greatly appreciate any guidance on how to properly display and calculate the average ratings for each tool in our "Rated Tools Overview" view. This is crucial for our decision-making process in selecting the most highly-rated tools for our company. Thank you in advance for your help!