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"]
    
    <label>Price:
    [calculation result precision:2 "price * qty"]</label>