I'd like to propose a new custom field type that would be very helpful. A field that can be derived or mapped between another field. Think of it like custom field > sub custom field. These dependencies would allow users to better manage tasks/forms as well as speed up data entry, reducing double entries, and allow for better reporting.
For example, I currently have a custom field called "Deliver to" which contains a list of stakeholders certain tasks are beholden to. Let's say the list contains the names, "Mark, Mary, Steve, and Josie"
I want to create a field called "Department" which tells me which Department any of the "Deliver to" names map to. For example:
- Mark belongs to the Sales Dept
- Mary belongs to Tax Dept
- Steve belongs to HR
- Josie belongs to Sales Dept.
When I select Deliver To: Mary on my task or form, I want the "Department" field to automatically know that she belongs to "Tax Dept" and populate that field based on mapping that would be setup at the time of creation.
Currently there isn't a way for me to roll up my data to see how many tasks are pending each dept since they're all at the "Deliver to" level. Adding standard new field called "Department" and just punching in the values every time is going to cause a lot of bloat on entry when it could easily be derived.
