How to Create a Ticket System With Google Docs
If you run a service-based business or a website, you might have the need to create a support ticket system where users can submit issues to you for customer support. Many support ticket systems have subscription fees, however, so those on a tight budget might want to look at free options. One such option is Google Docs. You can use Google Docs to create a Web-based form to collect support inquiries from your customers in a spreadsheet.
Visit the Google Docs website at docs.google.com, and sign in with your Google username and password.
Click the "Create new" button on the left side of the screen, then click "Form."
Enter a name for your form in the "Untitled form" field. This title will be visible to those contacting you for support. An appropriate name might be, "Create a support ticket."
Create your support ticket fields. The first field is already created for you. In the "Question Title" field, enter the a description for the field so that the user knows what to type in. For example, a good title for the first field might be "Name." Add additional fields by clicking the "Add item" button at the top of the screen, then clicking the field type you want to add.
Pick a theme for your support ticket form by clicking the "Theme" button at the top of the page. Several themes will be displayed. Click on a theme to apply it to your support form.
Click the link at the bottom of the screen. This opens your support ticket form in a new tab. Copy the link from the address bar and point users to this address for support inquiries.
View your support requests by visiting docs.google.com and opening the support form you just created. Instead of showing the form design page you used to create the form, you will instead be shown a spreadsheet. Any support tickets created using the form will be collected and placed inside the spreadsheet.