{"id":350,"date":"2020-01-21T08:54:13","date_gmt":"2020-01-21T08:54:13","guid":{"rendered":"http:\/\/bossakov.eu\/wpdemo\/?page_id=350"},"modified":"2023-03-30T01:03:51","modified_gmt":"2023-03-30T01:03:51","slug":"currency-converter-example","status":"publish","type":"page","link":"https:\/\/bossakov.eu\/wpdemo\/pvb-cf7-calculator-pro\/currency-converter-example\/","title":{"rendered":"Currency converter example"},"content":{"rendered":"<p>This example illustrates how to use Google Sheets to implement a simple currency converter.<\/p>\n<p><em>Disclaimer: Quotes are not sourced from all markets and may be delayed. Information is provided &#8216;as is&#8217; and solely for informational purposes, not for trading purposes or advice.<\/em><\/p>\n\n<div class=\"wpcf7 no-js\" id=\"wpcf7-f349-o1\" lang=\"en-US\" dir=\"ltr\" data-wpcf7-id=\"349\">\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\/350#wpcf7-f349-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=\"349\" \/><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-f349-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;:349,&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>I want to convert:<br \/>\n[spreadsheet_dropdown buying sheet:1 cells:A1-A12 include_blank \"https:\/\/docs.google.com\/spreadsheets\/d\/1LIXUU7Jc91H4M-hMayAhpbaHjG_NxIltgEkjeR3ZD2w\/edit?usp=sharing\"]<\/label>\n<\/p>\n<p><label>Amount:<br \/>\n<span class=\"wpcf7-form-control-wrap\" data-name=\"qty\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-text wpcf7-validates-as-required\" aria-required=\"true\" aria-invalid=\"false\" value=\"1\" type=\"text\" name=\"qty\" \/><\/span><\/label>\n<\/p>\n<p><input class=\"wpcf7-form-control wpcf7-calculate_button cf7-calculate_button\" type=\"button\" value=\"Calculate\" \/>\n<\/p>\n<p><label>Rate:<br \/>\n[spreadsheet_reference price field:buying sheet:1 cells:A1-B12 \"https:\/\/docs.google.com\/spreadsheets\/d\/1LIXUU7Jc91H4M-hMayAhpbaHjG_NxIltgEkjeR3ZD2w\/edit?usp=sharing\"]<\/label>\n<\/p>\n<p><label>Total:<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<h2>Source code for this form:<\/h2>\n<pre>&lt;label&gt;I want to convert:\n[spreadsheet_dropdown buying sheet:1 cells:A1-A12 include_blank \"https:\/\/docs.google.com\/spreadsheets\/d\/1LIXUU7Jc91H4M-hMayAhpbaHjG_NxIltgEkjeR3ZD2w\/edit?usp=sharing\"]&lt;\/label&gt;\n\n&lt;label&gt;Amount:\n[number* qty \"1\"]&lt;\/label&gt;\n\n[calculate_button calculate_button-1 \"Calculate\"]\n\n&lt;label&gt;Rate:\n[spreadsheet_reference price field:buying sheet:1 cells:A1-B12 \"https:\/\/docs.google.com\/spreadsheets\/d\/1LIXUU7Jc91H4M-hMayAhpbaHjG_NxIltgEkjeR3ZD2w\/edit?usp=sharing\"]&lt;\/label&gt;\n\n&lt;label&gt;Total:\n[calculation result precision:2 \"price * qty\"]&lt;\/label&gt;\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>This example illustrates how to use Google Sheets to implement a simple currency converter. Disclaimer: Quotes are not sourced from all markets and may be delayed. Information is provided &#8216;as is&#8217; and solely for informational purposes, not for trading purposes or advice. Source code for this form: &lt;label&gt;I want to convert: [spreadsheet_dropdown buying sheet:1 cells:A1-A12 [&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-350","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/bossakov.eu\/wpdemo\/wp-json\/wp\/v2\/pages\/350","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=350"}],"version-history":[{"count":5,"href":"https:\/\/bossakov.eu\/wpdemo\/wp-json\/wp\/v2\/pages\/350\/revisions"}],"predecessor-version":[{"id":518,"href":"https:\/\/bossakov.eu\/wpdemo\/wp-json\/wp\/v2\/pages\/350\/revisions\/518"}],"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=350"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}