Skip to main content
Question

usertoemail from user lookup

  • July 26, 2017
  • 0 replies
  • 30 views
Hrere's the formula that I have for a Forumla-Email Address field:

UserToEmail([Staff Member - Supervisor])

I'm getting this error:

orclose
Formula error -- Bad or missing arguments in function call

The types of the arguments or the number of arguments supplied do not meet the requirements of the function UserToEmail.

The function is defined to be UserToEmail (User x).

You may need to do one of the following to fix the problem:
  • Choose the right number and type of arguments.
  • Use a type conversion function to convert the arguments you are using to the correct type.
  • Choose a different function.
Help!
      This topic has been closed for replies.

      • GauravSharma3
      • Quickbase Alumni
      • July 26, 2017
      Hi Jay,

      Try this:

      ToUser([Staff Member - Supervisor])

      Thanks,
      Gaurav
      • JayDDS
      • Author
      • Quickbase Alumni
      • July 26, 2017
      Nope....no luck.
      • JayDDS
      • Author
      • Quickbase Alumni
      • July 26, 2017
      I guess I should also say what I'm trying to get.  I'm trying to return the user's email address, from a user field in a related table.
      What is the be field type of that field you are trying to convert. Maybe it's just a text field.
      • JayDDS
      • Author
      • Quickbase Alumni
      • July 26, 2017
      It's List-User.  Staff-Supervisor is actually another lookup field from the Supervisor field in the Supervisor table.  Could that be it?
      is this what you are after?

      UserListToEmails ()  Function?
      https://login.quickbase.com/db/6ewwzuuj?a=dr&r=fz&rl=daq
      Terms & ConditionsAccessibility statement