#framework BAT

List of Rows in Google Sheet

This page uses a Hashtag List to show all rows in a Google Sheet. The Table is styled using Bootstrap 3 default theme classes.

No Rows in Google Sheet

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>Method</th>
		<th>Rush?</th>
		<th>Action</th>
	</tr>
	</thead>
<# end header #>

<# start row #>
	<tr>
		<td><# Customer Name as html #></td>
		<td><# Total as html #></td>
		<td><# Payment Method as html #></td>
		<td><# Rush as html #></td>
		<td><a href="form?edit=<# row id as html #>" class="label label-primary">Edit</a>
			<a href="unset-rush?id=<# row id as html #>" class="label label-primary">Unset Rush</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 #>

<# start no results #>
<h4 class="alert alert-warning text-center">No Rows in Google Sheet</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.