Google Spreadsheets

Creating Test Scripts

 

You can now either use an existing script from Excel and paste the actions and results in the Google spreadsheet, modifying items as needed, or you can create a script from scratch. In order for it to be a usable deep regression script, every page, link, button, text box, etc., needs to be checked. Any interaction between users needs to be checked, and different roles need to be checked.

Make sure when you have completed the spreadsheet, that you select Share and allow anyone with the link to edit. Then add the link to the spreadsheet to the tool list.

Tips

  • To create multiple lines in a Google spreadsheet cell, push Ctrl & Enter at the same time inside the cell
  • To make headings available at all times, click View -> Freeze rows and select the number of rows to freeze
  • To make certain columns available at all times, click View -> Freeze columns and select the number of columns to freeze
  • To create links, paste the following in a cell, replacing 'URL_goes_here' with the actual URL and 'Text goes here' with the actual text to display:
    =hyperlink("URL_goes_here", "Text goes here")