I am wanting to use the multi drop function to automatically assign numerical values to my clients profile line once I choose their desired choice.
For example, the client is borrowing money and they choose to have 5% interest rate and 3 points on the loan. Or if they choose 4% and 4 points, I would want the drop down to fill the other two pre made fields with the data instead of having to go and put it in there myself. I have looked a most videos and cannot see the steps to make this happen if possible. Thanks again wonderful community!
I am sorry, my thoughts were jumbled when trying to ask.
Is there a way to assign each option, in a multiple select field, a specific value. So that when I click the option it will prefill a different field I have created. This way I can create a formula that will use that data entered into the filled cell. This should allow me skip multiple entries as I already chose it from the multiple selection options.
Thanks so much for your time!