You are viewing limited content. For full access, please sign in.

Question

Forms Time Entry Table Reporting; Weekly Delta of Hours

Forms

Updated August 1, 2018

asked on July 25, 2018

Hello,

I am wondering about forms native reporting capabilities and if this is feasible without customization below is a simplified model of what I am looking for:

Forms Process with a user time entry tracker table; Date and Hours Spent each time work is completed user enters date and hours for each project.
The Managerial aspect is to report on time natively with forms on a weekly view of how many hours were spent the current week on any given projects filtering out row entries that the date is outside of the week being reported on.

Let me know if elaboration is required.

0 0

Replies

replied on August 1, 2018

Hi Armando,

If I think it is possible but you might have an easier time using this method:

User fills out the Form for Project time and date
Workflow updates a SQL table:

Instance ID (this will be your primary key), Name, Date, Hours spent, (optional: Project type)

When the manager is ready (or on schedule), he/she can fill out a form that has these fields: Name and Date range - the form can do a lookup against your SQL table and retrieve all rows OR do it via Workflow and get the report emailed to the manager

Question

Question

Forms Time Entry Table Reporting; Weekly Delta of Hours

Replies

Sign in to reply to this post.