AnsweredAssumed Answered

Multiple shipping costs controlled via 2 fields

Question asked by hunterkilla on Jan 12, 2016
Latest reply on Jan 12, 2016 by albi2103

I am trying to solve an issue.   I have our booking system setup and we have 3 different shipping costs dependant on a field with postcode dropdowns and a field with 3 options on the delivery. 

 

So first someone enters the first part of the postcode  say AL1 (field  "Postcode".)    Then on another dropdown field ("deliveryoption") they can choose from 1 of 3 options   Dry Hire, 2 Man cost or 1 Man cost.   then dependent on which options they have chosen it fills in the delivery cost into field "postcode" 

 

I have attached an excel spreadsheet to show you how it shows you the different costs and we are trying to keep it in this layout in excel so when we update our prices I can do an import into filemaker to overwrite the new costs

 

Any help would be appreciated.

 

Steve

Attachments

Outcomes