{"id":81,"date":"2018-07-28T10:51:16","date_gmt":"2018-07-28T10:51:16","guid":{"rendered":"http:\/\/bossakov.eu\/wpdemo\/?page_id=81"},"modified":"2023-03-30T09:06:45","modified_gmt":"2023-03-30T09:06:45","slug":"price-calculator-with-external-spreadsheet","status":"publish","type":"page","link":"https:\/\/bossakov.eu\/wpdemo\/pvb-cf7-calculator-pro\/price-calculator-with-external-spreadsheet\/","title":{"rendered":"Price calculator with external spreadsheet"},"content":{"rendered":"<p>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.<\/p>\n\n<div class=\"wpcf7 no-js\" id=\"wpcf7-f80-o1\" lang=\"en-US\" dir=\"ltr\" data-wpcf7-id=\"80\">\n<div class=\"screen-reader-response\"><p role=\"status\" aria-live=\"polite\" aria-atomic=\"true\"><\/p> <ul><\/ul><\/div>\n<form action=\"\/wpdemo\/wp-json\/wp\/v2\/pages\/81#wpcf7-f80-o1\" method=\"post\" class=\"wpcf7-form init\" aria-label=\"Contact form\" novalidate=\"novalidate\" data-status=\"init\">\n<fieldset class=\"hidden-fields-container\"><input type=\"hidden\" name=\"_wpcf7\" value=\"80\" \/><input type=\"hidden\" name=\"_wpcf7_version\" value=\"6.1.7\" \/><input type=\"hidden\" name=\"_wpcf7_locale\" value=\"en_US\" \/><input type=\"hidden\" name=\"_wpcf7_unit_tag\" value=\"wpcf7-f80-o1\" \/><input type=\"hidden\" name=\"_wpcf7_container_post\" value=\"0\" \/><input type=\"hidden\" name=\"_wpcf7_posted_data_hash\" value=\"\" \/><input type=\"hidden\" name=\"_wpcf7cf_hidden_group_fields\" value=\"[]\" \/><input type=\"hidden\" name=\"_wpcf7cf_hidden_groups\" value=\"[]\" \/><input type=\"hidden\" name=\"_wpcf7cf_visible_groups\" value=\"[]\" \/><input type=\"hidden\" name=\"_wpcf7cf_repeaters\" value=\"[]\" \/><input type=\"hidden\" name=\"_wpcf7cf_steps\" value=\"{}\" \/><input type=\"hidden\" name=\"_wpcf7cf_options\" value=\"{&quot;form_id&quot;:80,&quot;conditions&quot;:[],&quot;settings&quot;:{&quot;animation&quot;:&quot;yes&quot;,&quot;animation_intime&quot;:200,&quot;animation_outtime&quot;:200,&quot;conditions_ui&quot;:&quot;normal&quot;,&quot;notice_dismissed&quot;:true,&quot;repeater_remove_button&quot;:&quot;bottom&quot;,&quot;wpcf7cf_settings_saved&quot;:1}}\" \/>\n<\/fieldset>\n<p><label>Product<br \/>\n[spreadsheet_dropdown product sheet:1 cells:A2-A23 include_blank \"https:\/\/docs.google.com\/spreadsheets\/d\/1_NMTrvDTdCSreeKDZ8fwIGI0GCTXSqSjf48ez1Nd4MA\/edit#gid=0\"]<\/label>\n<\/p>\n<p><label>Quantity<br \/>\n<span class=\"wpcf7-form-control-wrap\" data-name=\"qty\"><input class=\"wpcf7-form-control wpcf7-number wpcf7-validates-as-required wpcf7-validates-as-number\" aria-required=\"true\" aria-invalid=\"false\" value=\"1\" type=\"number\" name=\"qty\" \/><\/span><\/label>\n<\/p>\n\n<!-- Hidden field that matches product to price -->\n<p>[spreadsheet_reference price field:product sheet:1 cells:A2-B23 cf7-hide \"https:\/\/docs.google.com\/spreadsheets\/d\/1_NMTrvDTdCSreeKDZ8fwIGI0GCTXSqSjf48ez1Nd4MA\/edit#gid=0\"]\n<\/p>\n<p><input class=\"wpcf7-form-control wpcf7-calculate_button cf7-calculate_button\" type=\"button\" value=\"Calculate\" \/>\n<\/p>\n<p><label>Price:<br \/>\n<span class=\"wpcf7-form-control-wrap result\"><input size=\"40\" class=\"wpcf7-form-control wpcf7-calculation cf7-calculation\" readonly=\"readonly\" aria-invalid=\"false\" value=\"0\" type=\"text\" name=\"result\" \/><\/span><\/label>\n<\/p><input type=\"hidden\" name=\"_pvb_ajax_calc_nonce\" value=\"5a80c6b9a0\"><div class=\"wpcf7-response-output\" aria-hidden=\"true\"><\/div>\n<\/form>\n<\/div>\n\n<p>Google Sheet: <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1_NMTrvDTdCSreeKDZ8fwIGI0GCTXSqSjf48ez1Nd4MA\/edit?usp=sharing\">https:\/\/docs.google.com\/spreadsheets\/d\/1_NMTrvDTdCSreeKDZ8fwIGI0GCTXSqSjf48ez1Nd4MA\/edit?usp=sharing<\/a><\/p>\n<h2>Source code for this form:<\/h2>\n<pre>&lt;label&gt;Product\n[spreadsheet_dropdown product sheet:1 cells:A2-A23 include_blank \"https:\/\/docs.google.com\/spreadsheets\/d\/1_NMTrvDTdCSreeKDZ8fwIGI0GCTXSqSjf48ez1Nd4MA\/edit#gid=0\"]&lt;\/label&gt;\n\n&lt;label&gt;Quantity\n[number* qty \"1\"]&lt;\/label&gt;\n\n&lt;!-- Hidden field that matches product to price --&gt;\n[spreadsheet_reference price field:product sheet:1 cells:A2-B23 cf7-hide \"https:\/\/docs.google.com\/spreadsheets\/d\/1_NMTrvDTdCSreeKDZ8fwIGI0GCTXSqSjf48ez1Nd4MA\/edit#gid=0\"]\n\n[calculate_button calculate_button-1 \"Calculate\"]\n\n&lt;label&gt;Price:\n[calculation result precision:2 \"price * qty\"]&lt;\/label&gt;\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>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: &lt;label&gt;Product [spreadsheet_dropdown product sheet:1 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":2,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-81","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/bossakov.eu\/wpdemo\/wp-json\/wp\/v2\/pages\/81","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bossakov.eu\/wpdemo\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/bossakov.eu\/wpdemo\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/bossakov.eu\/wpdemo\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bossakov.eu\/wpdemo\/wp-json\/wp\/v2\/comments?post=81"}],"version-history":[{"count":4,"href":"https:\/\/bossakov.eu\/wpdemo\/wp-json\/wp\/v2\/pages\/81\/revisions"}],"predecessor-version":[{"id":527,"href":"https:\/\/bossakov.eu\/wpdemo\/wp-json\/wp\/v2\/pages\/81\/revisions\/527"}],"up":[{"embeddable":true,"href":"https:\/\/bossakov.eu\/wpdemo\/wp-json\/wp\/v2\/pages\/2"}],"wp:attachment":[{"href":"https:\/\/bossakov.eu\/wpdemo\/wp-json\/wp\/v2\/media?parent=81"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}