• Using Google Sheets
• Form

Form for Google Sheet

• List of rows in Google Sheet — Test Spreadsheet
• Create Record — Add a new row to Google Sheet — Test Spreadsheet

<# start form for google sheet "Test Spreadsheet" <#[url.edit]#>;
	set form.class to "form-horizontal";
	when deleting call confirm('Confirm Delete?');
	when done redirect to "/google-sheets/list?index=<# form.id #>";
#>

<div class="form-group">
	<label for="time" class="col-sm-3 control-label">Time</label>
	<div class="col-sm-6">
		<input type="text" <# Time #> class="form-control" 
			value="<#[system.date_time_short]#>" id="time">
	</div>
</div>
<div class="form-group">
	<label for="type" class="col-sm-3 control-label">Type</label>
	<div class="col-sm-6">
		<select <# Type #> class="form-control" id="type">
			<option>Web Order</option>
			<option>Purchase Order</option>
		</select>
	</div>
</div>
<div class="form-group">
	<label for="customer-name" class="col-sm-3 control-label">Customer Name</label>
	<div class="col-sm-6">
		<input type="text" <# Customer Name #> class="form-control" 
			value="Tester O'Testingham" id="customer-name">
	</div>
</div>
<div class="form-group">
	<label for="total" class="col-sm-3 control-label">Total</label>
	<div class="col-sm-6">
		<input type="text" <# Total #> class="form-control" value="$30.00" id="total">
	</div>
</div>
<div class="form-group">
	<label for="payment-method" class="col-sm-3 control-label">Payment Method</label>
	<div class="col-sm-6">
		<div class="radio">
			<label><input type="radio" <# Payment Method #> value="Credit" checked="checked">
				Credit
			</label>
		</div>
		<div class="radio">
			<label><input type="radio" <# Payment Method #> value="Debit">
				Debit
			</label>
		</div>
		<div class="radio">
			<label><input type="radio" <# Payment Method #> value="Cash">
				Cash
			</label>
		</div>
	</div>
</div>
<div class="form-group">
	<label for="notes" class="col-sm-3 control-label">Notes</label>
	<div class="col-sm-6">
		<textarea rows="4" <# Notes #> class="form-control" id="notes"></textarea>
	</div>
</div>
<div class="form-group">
	<label for="rush" class="col-sm-3 control-label">Rush?</label>
	<div class="col-sm-6">
		<div class="checkbox">
			<label><input type="checkbox" <# Rush #> value="Rush!" id="rush">
				Rush!
			</label>
		</div>
	</div>
</div>
<div class="form-group">
	<div class="col-sm-offset-3 col-sm-6">
		<input type="submit" <# Create Button #> class="btn btn-primary" value="Add Row">
		<input type="submit" <# Update Button #> class="btn btn-primary" value="Update Row">
		<input type="submit" <# Delete Button #> class="btn btn-primary" value="Delete Row">
	</div>
</div>

<# end form #>

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.  

• Form Templates