Forum Discussion

JenniferPeterso's avatar
JenniferPeterso
Qrew Member
6 years ago

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...
Formulas and functions
Relationships
JenniferPeterso's avatar
JenniferPeterso
Qrew Member
6 years ago
I keep getting an "Expecting text and found textlist" error when trying to convert it back to the User.



------------------------------
Jennifer Peterson
------------------------------
LaurenJeppson's avatar
LaurenJeppson
Qrew Member
5 years ago
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's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    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
    ------------------------------