User Field from Child Record to Parent
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 th...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendJennifer,
Recently, we have new capability in Summary field types in that we can summarize text information. 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 of
usertoemail([my userid field])
then use the combined text summary field type to float that text up to the parent. 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 field
ToUser([my combined text summary of the user email in text format])
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Recently, we have new capability in Summary field types in that we can summarize text information. 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 of
usertoemail([my userid field])
then use the combined text summary field type to float that text up to the parent. 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 field
ToUser([my combined text summary of the user email in text format])
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
I keep getting an "Expecting text and found textlist" error when trying to convert it back to the User.
------------------------------
Jennifer Peterson
------------------------------
------------------------------
Jennifer Peterson
------------------------------
- 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__Youmaybe try
ToUser(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 Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
