I have an account hierarchy, that is dependant on the account type(not record type).

enter image description here

'Role' on the image is a picklist, that is actually 'Type'. I need to limit the list of accounts for the parent account field, so that if the account has a role 'Site', the parent account list should be limited only to the accounts with the role 'Sold to' and so on. Is it possible without coding an APEX class?

1 Answer 1


Hopefully this helps..

  1. Create a new text field on Account called RoleFormula
  2. Create a new Before-Save flow (Fast Field Updates) on Account which will populated the RoleFormula field based on your logic. If the current record's Role is 'Site', RoleFormula is set to 'Sold to'
  3. Create a Lookup filter on Parent Account field where the criteria would be Parent Account: Role EQUALS Account: RoleFormula

We are using a regular text field instead of a formula is because the lookup filters do not accept formulas on the Right hand side criteria.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .