Forum Discussion

DanteTognoli's avatar
DanteTognoli
Qrew Captain
5 years ago

UserToName invalid

I am trying to have a form fill out the name field with the user name automatically. I have the following in a Formula-Text field, "UserToName([Record Owner], "LF")" and it returns Invalid on the form...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
The Record owner will only exist after the record is saved.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    You can have a field called [Current User Name] with a formula of 

    UserToName(User(), "LF")

    then you can have a form rule

    When name is blank, change name to the value in the field [Current User Name]

     you might need to put that formula field on the form in a hidden section to get the form rule to see that calculation.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • DanteTognoli's avatar
      DanteTognoli
      Qrew Captain
      5 years ago
      Perfect, Thanks!

      ------------------------------
      Dante Tognoli
      ------------------------------