Dynamic filtering in detailed view and Form not working

Ask for Help
1

I am trying to create a input Form which enables onboarding a Coordinator for Colleges. since they may be based in different places, Here are the fields in the order of priority.

  1. State -
  2. District
  3. College Name - list of colleges that are within in this district
  4. University Name - Colleges associated with the universities

1 to 4 - I am using Sheet "District_College_info

  1. Name
  2. Email
  3. Mobile
  4. Interested in coordination?

5 to 8 : These fields are in Coordinator_onboarding Sheet, and I am not able get this source as User Table is used for the detailed list to create the Customer fields

  1. Detailed list - In the detailed list, by capturing Use Choice through a Custom Filed (User Table), I am able to create a filter and show the associated District, College and University

But, I am not able to figure out how to append other fields Name, Mobile, Email etc and save in Coordinator_Onboarding Sheet

  1. Form Approach - Not able to create the dynamic filtering as User choices are not shown in the Custom fields

Any help will be highly appreciated.

Santosh