Answers.Body: <p>This service would be one option: <a href="https://mapit.mysociety.org/" rel="nofollow noreferrer">https://mapit.mysociety.org/</a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-07-19T11:10:45.537Z
Answers.LastActivityDate: 2017-07-19T11:10:45.537Z
Answers.UserDisplayName: Christian Wach
Answers.Body: <p>For interest's sake in the end I went with a solution that sat outside civicrm (for now). I used PHP to look up and return the MP name from a sql table which I created by uploading data from <a href="http://www.list-logic.co.uk/lists/parliamentary-constituencies/list-of-uk-constituencies.html" rel="nofollow noreferrer">http://www.list-logic.co.uk/lists/parliamentary-constituencies/list-of-uk-constituencies.html</a></p>
  
  <p>The list of people who submitted the form are being manually uploaded into civicrm daily.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-08-24T14:21:55.457Z
Answers.LastActivityDate: 2017-08-24T14:21:55.457Z
Answers.UserDisplayName: Caroline B
Body: <p>Hello I would like to have the ability to lookup the parliamentary constituency of a person when they put in the postcode. The data should return into a custom field. The data source would need to be an external database (probably sql) I am aware that there is regional lookup extension (does it work on 4.7?) and there is county lookup (can that be tweaked to lookup a different field). Does anyone have any views on this? Are there other extensions I'm not aware of?</p>
  
  <p>Thank you!</p>
  
Tags: <extension>
Title: Lookup field for parliamentary constituency
ThreadText: # Lookup field for parliamentary constituency
  
  (Asked by: username_0 on 2017-07-19)
  
  Hello I would like to have the ability to lookup the parliamentary constituency of a person when they put in the postcode. The data should return into a custom field. The data source would need to be an external database (probably sql) I am aware that there is regional lookup extension (does it work on 4.7?) and there is county lookup (can that be tweaked to lookup a different field). Does anyone have any views on this? Are there other extensions I'm not aware of?
  
  Thank you!
  
  **Tags:** extension
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2017-07-19. Score: 0 | Accepted answer
  
  This service would be one option: <https://mapit.mysociety.org/>
  
  
  ---
  
  ### Answer by username_0 on 2017-08-24. Score: 1
  
  For interest's sake in the end I went with a solution that sat outside civicrm (for now). I used PHP to look up and return the MP name from a sql table which I created by uploading data from <http://www.list-logic.co.uk/lists/parliamentary-constituencies/list-of-uk-constituencies.html>
  
  The list of people who submitted the form are being manually uploaded into civicrm daily.
  
  
  ---
  
  