Hello and thanks in advance for your help. We use Formidable Forms to keep track of all our employees' daily worked hours. They use a form that calculates the total hours worked and sends it to Google Sheets. Even though we can easily achieve this by working directly with Google Sheets, we wonder if it would be feasible and what the best approach would be to create another form (which could be called 'Create Monthly Hour Report') that:

• Gets the data from the original form (name, date, total hours).
• Sums all the total hours in a specific date range.

For example: Entry 1:

• Name: Mike
• Hours: 8H
• Date: 24/04/2024

Entry 2:

• Name: Joe
• Hours: 6H
• Date: 24/04/2024

Entry 3:

• Name: Mike
• Hours: 5H
• Date: 25/04/2024

Entry 4:

• Name: Joe
• Hours: 11H
• Date: 25/04/2024

Is it feasible (whether using a new form or a view) to get the sum of the hours value for each employee during a specific date range? For example: Mike's April total: 13H.