User Field from Child Record to Parent

Question

I am used to using a cycle of relationship fields to get milestone dates from the Child Record "Tasks" to the Parent Record "Reports." I use a Date Summary on the Tasks table, and a Lookup Field on the Reports table to get the date of a specific Task milestone to show up on the Reports table. I'm not having any luck using this same process to get the User who completed the specific Task to show up on the Reports record. Any suggestions?

------------------------------
Jennifer Peterson
------------------------------

markshnier__you · Answer

Jennifer,Recently, we have new capability in Summary field types in that we can summarize text information. &nbsp;But that does not apply to user field types.but no problem.we can just make a field called [userid in text format]with a formula ofusertoemail([my userid field])then use the combined text summary field type to float that text up to the parent. &nbsp;You will, I assume have a filter in that field for say a date to limit the summary field to the particular user you are looking for.Then if you need to get that text field back to being a user field up in the parent, you can make a new formula user fieldToUser([my combined text summary of the user email in text format])------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

jenniferpeterso · Answer

I keep getting an "Expecting text and found textlist" error when trying to convert it back to the User.

------------------------------Jennifer Peterson------------------------------

laurenjeppson · Answer

Was a solution to this issue ever found? I'm trying to do the same thing, but getting the same error message.------------------------------Lauren Jeppson------------------------------

markshnier__you · Answer

maybe tryToUser(ToText([My combined text summary field]))Note this this will only work if the data has only 1 user.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

User Field from Child Record to Parent

Related Content

Totaling Child Records Live on Parent Form

Add child record through parent form and redirect back to parent form in edit mode

Pipeline to add Parent record from child import

Show unique parent records for current user

Using Grid Edit to Edit Multiple Records at Once