Creating a Monthly Hour Report Form in Formidable Forms

By: Luis Martín | Asked: 05/22/2024
ForumsCategory: Paid Help WantedCreating a Monthly Hour Report Form in Formidable Forms
Luis Martín asked 3 weeks ago
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.
1 Answers
Rob LeVineRob LeVine answered 3 weeks ago
I can help you with that. As I mentioned in your previous post, it's a view you want, not a form. Feel free to send me an email at rolevine at Gmail.

Making the Best WordPress Plugin even better - Together

Take on bigger projects with confidence knowing you have access to an entire community of Formidable Experts and Professionals who have your back when the going gets tough. You got this!
Join the community