Form for Google Sheet — Worksheet
This page uses a Hashtag Form for a Google Sheet, specifying a Worksheet by name.
The Form is styled using Bootstrap 3 default theme classes.
Submitted data will be saved to a row in the named Worksheet of a Google Sheet.
Processed this Hashtag Markup:
<# start form for google sheet "Test Spreadsheet" "My Worksheet" <#[url.edit]#>;
set form.class to "form-horizontal";
when deleting call confirm('Confirm Delete?');
when done redirect to "/google-sheets/worksheet-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 #>