US flag signifying that this is a United States Federal Government website An official website of the United States Government

Travel Form and Email Request Automation

Ended on 02/26/2016
Winning bid (Dan Siddoway): $400.00


Google Apps Script

18F travel requests must be authorized by supervisors, which is currently done via email. Certain information is required for the supervisor in order to approve or deny the request and the email is currently templated, but entered manually by the requester. This issue seeks the creation of a web form to collect the information required in the web form and generates an email to send to the supervisor. An email must be generated in order to confirm travel dates.

Auction rules

Registered users on may bid to deliver the requirements in this auction. The lowest bidder at the time the auction closes shall receive the award. The awarded bidder shall have five business days after notice of award to deliver the requirements. Upon successful completion of the requirements, 18F shall pay the winning bidder.

Also see our policies and guidelines page.

Acceptance criteria

Given an 18F employee needs to send a travel request,

When they log on to the webform pages,

Then they will see the following fields, all of which will be required:

  • Requestor Name [Text]
  • Requestor Email [Email]
  • Billability [Dropdown] --Two Options: --BILLABLE --NONBILLABLE
  • Tock Project Name [Text] [Help text: - Exact Name of the Tock Project]
  • Tock Project ID. [Text] [Help Text: - Please lookup tock project here:]
  • Client Email [Email] [Help Text: Or supervisor if nonbillable]
  • Home Location [Text] [Help Text: - Where you are usually located]
  • Work Location [Text] [Help Text: Where you will be travelling to]
  • Work to be done [Text] [Help Text: What you will be working on ]
  • Departure Date [Date]
  • Return Date [Date]
  • First Day of Travel Work Date [Date]
  • When a user submits the information
  • Then the web form will validate the entries to ensure they are of appropriate length and do not contain illegal characters.

Given that the entered form information meets the validation criteria

When the form is submitted Then an email is sent to the Client Email

And a reply-to field including the “Requestor Email” and “

And contains a subject in the Following Format using the information from the form inputs:

"{Billability} - {Tock Project Name} - #{Tock Project ID} -- {Departure_Date} - {Return Date}"

Subsequently, the body of the email will be generated using the information from the form inputs:



I request approval to travel from {Home Location} to {Work Location}. The dates of travel are {Departure Date} - {Return Date}. I will depart the {Departure Date}, to arrive in time for {Work to be done} scheduled for {First Day of Travel Work Date}. I will return to {Home Location} on {Return Date}.

Please reply with your approval, or with any subsequent clarifications you may have.

Many thanks,

{Requestor Name}


A single pull request submitted to with clear, descriptive commits that satisfy all of the above acceptance criteria.

Bidder DUNS Amount Date (EST)
Dan Siddoway 080014807 $400.00 * February 26, 2016 12:59:06 PM EST
Evan Rose 07-944-1444 $449.00 February 26, 2016 12:55:22 PM EST
Joe Hand 080126095 $450.00 February 26, 2016 10:50:31 AM EST
Justin Duke 080039148 $475.00 February 26, 2016 01:21:31 AM EST
Thought Object 08-003-3961 $500.00 February 24, 2016 01:11:16 PM EST

* - winning bid

Bidding closed

Bidding for this auction closed on February 26, 2016 01:00:00 PM EST.

Auction started at

February 24, 2016 01:00:00 PM EST

Auction ended at

February 26, 2016 01:00:00 PM EST

Delivery deadline

March 04, 2016 01:00:00 PM EST

Eligible vendors only

Auction type:

Reverse (rules)

Paid at:

March 16, 2016 03:20:15 PM EDT

Accepted at:

March 04, 2016 01:00:00 PM EST

View on GitHub