Exporting Form Module Data to .CSV

Exporting Form Module Data to .CSV

All submitted Form data can easily be exported into a .csv file for creating awesome Excel reports. If you are an Excel guru, you should be able to capture all data with scheduling forms, and then export the data as .csv to have pivot tables, charts, graphs and more in Excel.

This is useful for tracking training hours, etc. for employees year-end.

An example would be to create a 'Training Roster' form. Have form fields:

Employee
Date
Total hours
Training Category

Then, every time a training is completed - fill out and submit the form with all data entered. All of this will be captured and available for a .csv export. At the end of the year, or whenever you'd want, you could export this data into a .csv file.

Open that file in Excel, and build awesome Graphs, Pivot Tables, Charts, etc. In a quick glance, you could see how many hours each employee has for each category. The possibilities are endless!

Note: If you are a real 'code-monkey', you can access all of this data via our RESTful API as well. https://developer.crewsense.com/


    • Related Articles

    • Forms Module

      The scheduling system has a powerful integrated forms system that allows your organization to create, share and host forms within the platform. Things like apparatus check sheets, inventory, exposure control and more can be hosted within the platform ...

    • Customizing .CSV Export Layout & Options

      You can customize the layout and ordering of the CSV payroll report. This is useful for generating CSV exports to then import into third party systems. By customizing the column ordering and data, you can get the scheduling CSV export to match the ...

    • Creating Templates for Payroll Data

      Within the reports module, you have the ability to export Target Solutions Scheduling data in various formats, for payroll purposes. With payroll report templates, you can create and save general parameters of a report, making it easy to run the same ...

    • Payroll Exports

      CrewScheduler roster data can quickly and easily be exported for advanced payroll imports or other employee reporting needs. The data includes all regularly scheduled assignments, time off's, overtime hours, partial hours and miscellaneous hours. ...

    • CertTracker Module

      Target Solutions Scheduling has a built-in certification tracking module for tracking employee certifications. This is excellent for attaching user certifications and getting a quick glance into their current status. The system will automatically ...