Price calculator with external spreadsheet

This calculator demonstrates how you can look up values from a spreadsheet uploaded somewhere else on the Internet. You can match text to numbers or create drop-down menus based on data from the spreadsheet. Google Sheets, Microsoft Excel and CSV formats are supported.

Google Sheet: https://docs.google.com/spreadsheets/d/1_NMTrvDTdCSreeKDZ8fwIGI0GCTXSqSjf48ez1Nd4MA/edit?usp=sharing

Source code for this form:

<label>Product
[spreadsheet_dropdown product sheet:1 cells:A2-A23 include_blank "https://docs.google.com/spreadsheets/d/1_NMTrvDTdCSreeKDZ8fwIGI0GCTXSqSjf48ez1Nd4MA/edit#gid=0"]</label>

<label>Quantity
[number* qty "1"]</label>

<!-- Hidden field that matches product to price -->
[spreadsheet_reference price field:product sheet:1 cells:A2-B23 cf7-hide "https://docs.google.com/spreadsheets/d/1_NMTrvDTdCSreeKDZ8fwIGI0GCTXSqSjf48ez1Nd4MA/edit#gid=0"]

[calculate_button calculate_button-1 "Calculate"]

<label>Price:
[calculation result precision:2 "price * qty"]</label>