Skip to main content
Solved

User to Name

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

not tested but try this

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

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

Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement