Can you embed data on the back end of a Form to autofill selections?


I am building a form that will capture clock hours. Those employees clocking the hours are tied to name key, which is tied to a supervisor who is then tied to a budget center which is tied to a budget code.

Is there a way to embed data on the back end to help auto-fill this information?

For example: I select Jane Doe as my supervisor from a dropdown. Because Jane Doe is selected, my budget center selection is auto populated on the form.

We are moving to a smartsheet form from paper time cards to help avoid human error, and fear that manually entering in this data will still allow for human error and additional maintenance.

Thanks for your thoughts and help!