Can we automate hierarchy based on form responses? Can the parent/child relationship flow to report?
First Question: I have a form to collect the division and unit from end-users on tasks. I would like the unit to be captured as a child to division in the sheet automatically. Though I understand that one form response results in one row, what is the workaround for the associated child row to appear under the parent row? How can this work with more than 1 person using the form throughout their workday?
Second Question: Can the hierarchy as it appears in a sheet flow to a report so that the end-user can distinguish parent from child?