Skip to main content
Solved

User to Name

  • May 22, 2025 4:29 PM UTC
  • 0 replies
  • 139 views
Forum|alt.badge.img+12

I'm trying to use"UserToName([Current PR Assigned], "LF"))", however if there is no user in the field, it comes back with invalid.  How do I get it to just be blank if there is no user?

I have tried this and it says expecting user but found text for the UserToName part.

If([Current PR Assigned Is null]="yes",[Blank User],UserToName([Current PR Assigned], "LF"))

Any ideas?

Best answer by MarkShnierYou

not tested but try this

IF(not IsNull([Current PR Assigned]),

UserToName([Current PR Assigned], "LF"))

View original

MarkShnierYou
Forum|alt.badge.img+24
  • MarkShnierYou
  • Qrew Champion
  • Answer
  • May 22, 2025 4:40 PM UTC

not tested but try this

IF(not IsNull([Current PR Assigned]),

UserToName([Current PR Assigned], "LF"))

Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement