List of Rows in Google Sheet — Template Commands

This page uses a Hashtag List to show all rows in a Google Sheet.   The Table is styled using Bootstrap 3 default theme classes.   A New Total is calculated for each row, applying a 5% tax rate, and flat $8.95 shipping fee.  
Customer Name Total New Total Action
Testla Testopolis $ 29.95 $ 40.40 Edit Apply Delete
Testla Testopolis $ 29.95 $ 40.40 Edit Apply Delete
Dureutige $ 30.00 $ 40.45 Edit Apply Delete
Testla Testopolis $ 29.95 $ 40.40 Edit Apply Delete
Testla Testopolis $ 29.95 $ 40.40 Edit Apply Delete
Testla Testopolis $ 29.95 $ 40.40 Edit Apply Delete
Testla Testopolis $ 29.95 $ 40.40 Edit Apply Delete


Processed this Hashtag Markup:
<# start list for google sheet "Test Spreadsheet"; 
	show 7 rows per page;
#>

<# start header #>
<table class="table table-striped table-hover">
	<thead>
	<tr>
		<th>Customer Name</th>
		<th>Total</th>
		<th>New Total</th>
		<th>Action</th>
	</tr>
	</thead>
<# end header #>

<# start row #>
	<# 
		// apply a tax rate of 5 percent, and add a flat $ 8.95 shipping fee
		set <# new_total #> to (<# row.total as number #> * 1.05) + 8.95;
	#>
	<tr>
		<td><# Customer Name as html #></td>
		<td><# Total as dollars #></td>
		<td><# new_total as dollars #></td>
		<td><a href="form?edit=<# row id as html #>" class="label label-primary">Edit</a>
			<a href="apply?id=<# row id as html #>" class="label label-primary">Apply</a>
			<a href="delete?id=<# row id as html #>" class="label label-primary"
				onclick="return(confirm('Delete Row?'))">Delete</a>
		</td>
	</tr>
<# end row #>

<# start footer #>
</table>
<# end footer #>

<# no results #>
<h4 class="alert alert-warning text-center">No Rows Found</h4>
<# end no results #>

<# end list #>

The Hashtag Markup Language provides many methods to interact with Google Sheets.

Hashtag Forms and Lists can use Google Sheets for storing data.   Each row in the Google Sheet is treated as a record.