Determining the Overseas Postage charge:
The overseas postage rates from Australia are broken down into five Zones. So it is necessary to select the correct Zone for the given Country and the correct Charge for the Zone. This is achieved using two Spreadsheet to Form Widgets: "Enter Country" and "Enter Zone". They in turn fill the two Short Text controls "Zone" and "Postage"
Country to Zone: A two column CSV file is loaded once (or whenever the zones are changed) into the "Enter Country" question. The column headings in this file are "Country" and "Zone". When loaded into the widget, "Country" is selected as the "Access code column". When activated, it fills the Short Text "Zone", matching the name of the second column.
The cost obtained from this process is for one magazine. Subsequent calculations adjust for the number of copies.
Zone to Postage: A two column CSV file is loaded once (and updated whenever the overseas postage charges are changed) into the "Enter Zone" question. The column headings in this file are "Zone" and "Postage". When loaded into the widget, "Zone" is selected as the "Access code column". When activated, it fills the Short Text "Postage", matching the name of the second column.
Australia is not in one of Australia Post's five zones. To accomodate Australians
the "Enter Country" CSV contains a record for Country="Australia" with Zone =-1 AND
the "Enter Zone" CSV contains a record for Zone=-1 with Postage=0.
[Widget does not work if Zone is zero]
These two S2F questions must not be hidden, although they are not displayed. The Widgets are set "Autofill By Condition"=ON and "Run in the background"=ON. Questions "Zone" and "Postage" are hidden. The "Country" dropdown triggers "Enter Country" which fills "Zone". "Zone" triggers "Enter Zone" which fills "Postage". This represents the postage cost for one magazine. It is picked up by in the form calculation "Postage Cost (AUD)" where it is multiplied by the number of issues in the subscription.