Forum Discussion
MarkShnier__You
Qrew Legend
6 years agoJennifer,
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
------------------------------
JenniferPeterso
6 years agoQrew Member
I keep getting an "Expecting text and found textlist" error when trying to convert it back to the User.
------------------------------
Jennifer Peterson
------------------------------
------------------------------
Jennifer Peterson
------------------------------
- LaurenJeppson5 years agoQrew MemberWas a solution to this issue ever found? I'm trying to do the same thing, but getting the same error message.
------------------------------
Lauren Jeppson
------------------------------- MarkShnier__You5 years ago
Qrew Legend
maybe 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
------------------------------