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:

    Source code for this form:

    [spreadsheet_dropdown product sheet:1 cells:A2-A23 include_blank ""]</label>
    [number* qty "1"]</label>
    <!-- Hidden field that matches product to price -->
    [spreadsheet_reference price field:product sheet:1 cells:A2-B23 cf7-hide ""]
    [calculate_button "Calculate"]
    [calculation result precision:2 "price * qty"]</label>