How can I create a multi column multi value filtered lookup?

  • Profile Image
    Asked on March 30, 2014 at 01:35 PM

    I would like to create four related fields that filter results based on the entry of a prior field. In field 1 there would be four entries and based on the selection, filed 2 would filter the results of the first fields value, and so on. I also want to visually relate the fields together using a title to describe all the fields i.e. "Account Information" where the first value is Region, the second field is District, the third is manager and the fourth is rep. A box around all fields with a title would work.

  • Profile Image
    Answered on March 30, 2014 at 06:21 PM

    I think you scenario can be used using conditional logics. So that a Drop Down Menu - Selection would generate different results

    Please check the guide below and let us know if you need further assistance in accomplishing your scenario

    How to Insert Text or Mathematical Caculation into a field using a Condition