Creating a Monthly Hour Report Form in Formidable Forms

By: Luis Martín | Asked: 05/21/2024
ForumsCategory: How-toCreating a Monthly Hour Report Form in Formidable Forms
Luis Martín asked 6 months 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 (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.
It seems complicated, but Formidable Forms has surprised us many times :)
3 Answers
Rob LeVineRob LeVine answered 6 months ago
Do you want a form or a view, i.e., is this data going to be viewed or edited? A view would easily accomplish displaying the data.
Luis Martín answered 6 months ago
Thanks for your response, Rob. We don't need to edit the data, as all the data comes from the original form. We can work with a view, is there any tutorial that we can check to achieve this?
Rob LeVineRob LeVine replied 6 months ago

I suggest starting with: https://formidableforms.com/knowledgebase/create-a-view/ and working your way to https://formidableforms.com/knowledgebase/advanced-view-concepts/ if needed. The key is setting up filters to limit your data to what you want to see and then inside the view you can put any HTML you want to display the data, including using some of the stock layouts, e.g., grid.

Luis Martín answered 6 months ago
Thanks for your help, Rob! However, I will take my question to the paid services category, as the tutorials don't explain how to sum values from a specific data range and display the result in a view.

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
crossarrow-right