This customer RTO business involves student information input to Salesforce and then export-related Salesforce data for AVETMISS and HEIMS reporting. Subject information like a subject field of education or student information like language should give the correct code as defined by Australia Bureau of Statistics and TGA rules for compliance purpose. Take some examples below:

  • Language: English
  • Code: 1201
  • Subject Field of Education: Electrical Engineering
  • Code: 031301
  • Subject Field of Education: Microbiology
  • Code: 010911



Provided customer auto-complete feature so that when user key in Language/Subject Field of Education, their code will be auto-populated in their id field. This method will overcome Salesforce picklist limit as well. Javascript is used to create autocomplete feature.


Related Objects Contact, custom objects
Components Javascript
Complexity Hard