UserToName invalid

Question

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 itself.

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

markshnier__you · Answer

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 · Answer

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 · Answer

Perfect, Thanks!------------------------------Dante Tognoli------------------------------

Forum Discussion

UserToName invalid

Related Content

Sandbox - "Invalid Change(s) Detected"

Error - Invalid record data provided when executing form rules

Quickly Identify Invalid Choices

Validation error: Invalid literal for Decimal: u'TEST9-NewAccount'

Pipeline issue: "invalid literal for Decimal" ???