Autofill fields in table based on a dropdown

Hi Ramya -- 

With the assumption that you have many clients (more than say...10), the most scalable way of doing this is having a separate Client table which houses the name, email and phone number of your clients. You would then have a relationship where Clients have many Jobs, and your users can select the Client Name from the reference field on Jobs, and then display lookup fields to that client's email and phone. If you wished, you could give your users the ability to create new Client records in case the Client does not currently exist.

Other solution(s) would require you to hard-code email/phone values based on selection in the Client drop down (I'm currently assuming it's a multiple-choice field), which is not scalable or advisable.

------------------------------
Bree Mackey
Solutions Architect
Quick Base, Inc.
------------------------------