How to Customize the Sample Timesheet

How to Customize the Sample Timesheet

Customize the Form Template

1. Download the Sample Timesheet Form Template from the Admin Portal (Admin > Form Templates).  The eForm file is also attached to this test article for your convenience.



2. Open the Sample Timesheet eForm in Forms Designer.

3. Rename the form by opening Form Properties and changing the Form Name to your desired timesheet name.



4. Click on Export to export the page background as an image. Edit the background using any image editing software to insert your logo. Save your updated background image.



5. Click on Replace then choose "Use Image File"  to replace the form background with your updated image.



6. Save your updated timesheet eForm then upload it to the Admin Portal (Admin > Form Templates) to replace the Sample Timesheet with your customized Timesheet.


For more details on how to use Forms Designer, see our Forms Designer Quick Start Guide.


Update the Drop-Down Values

1. Download the F2B Sample Timesheet Data File.xlsx Form Data File from the Admin Portal (Admin > Form Data Files). The form data file is also attached to this article for your convenience.




2. Open the file in Excel to edit the drop down values available in the timesheet. 
Warning: You cannot change the sheet name or the header names (highlighted in yellow). The drop-downs in your forms will no longer pull the data.      


The following table contains all of the drop-down regions in the form and which sheet/column they are pulling data from.

Region Name
Sheet Name
Column
Page1@JobNumber
Worksite
ID
Page1@WorksiteLocation
Worksite
Worksite
Page1@Supervisor
Supervisors
Name
Page1@SupervisorID
Supervisors
ID
Page1@EmployeeName1 - 15
Employees
Name
Page1@EmpID1 - 15
Employees
ID
Page2@EquipmentName1 - 13
Equipment
Equipment
Page2EquipmentID1 - 13
Equipment
Equipment ID

3. Save your updated Form Data File with the exact same file name (F2B Sample Timesheet Data File.xlsx) and upload your updated file to the Admin Portal (Admin > Form Data Files) to replace the sample data with your company's data.


For more information on how to manage Form Data Files, see our article on Form Data Files.



    • Popular Articles

    • Forms Designer Quick Start Guide

      Overview Field2Base Forms Designer is the proprietary software application that allows your existing paper forms to be quickly converted to a smart E-form available to your end users via our mobile and web-based Mobile Forms applications. This ...

    • Portal 11.28.2023 Release Notes

      Overview Our release notes offer brief descriptions of product enhancements and bug fixes. We include links to the current articles for any affected features. Those articles will be updated shortly after the Portal release to include new ...

    • Integration Service Configuration Guide

      How To Configure Integration Services To Allow Read/Write Access on a Network Path All of our Integration Products, including the DIM, DUU, and EDM have respective Windows Services responsible for communicating with our server. Occassionally, ...

    • Data Integration Module (DIM) Migration Guide

      Overview This article provides the information necessary to migrate the Field2Base Data Integration Module (DIM) over from one server to another. Please refer to the DIM Install Guide for the initial installation of the Field2Base DIM. Once that's ...

    • How to Check the Version of Integration Products Running on a Windows 10 Machine

      Right-click on the Start menu button. Click on Apps & Features. In the Apps & Features search bar type in the Integration Product you are looking for, eg. F2B Data Integration Module, F2B Data Upload, or F2B Enterprise Dispatch Module. Click to ...