Discussions

Expand all | Collapse all

Syntax for User lIst Formula

  • 1.  Syntax for User lIst Formula

    Posted 01-15-2020 16:14
    I think this is an easy one, just can't find it online. When using user list formula, what is the correct syntax to show a specific list of users?


    ------------------------------
    Mike Tamoush
    ------------------------------


  • 2.  RE: Syntax for User lIst Formula

    Posted 01-15-2020 16:24
    Like this?
    https://login.quickbase.com/db/6ewwzuuj?a=dr&r=fx&rl=dw4

    ToUserList([Sales Manager], [Business Manager]) takes the values in the Sales Manager field and Business Manager field and returns the combined value into another field.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Syntax for User lIst Formula

    Posted 01-15-2020 16:27
    Not exactly. I am trying to default a user list to specific users. There is no default in user list, so I was hoping I could use a formula user list and somehow just type in the user names in the formula field.

    ------------------------------
    Mike Tamoush
    ------------------------------



  • 4.  RE: Syntax for User lIst Formula

    Posted 01-15-2020 16:30
    OK trey this

    ToUserList(
    ToUser("fflintstone@bedrock.com"),
    ToUser("brubble@bedrock.com")
    .....  etc
    )

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 5.  RE: Syntax for User lIst Formula

    Posted 01-15-2020 16:41
    That's what i needed. Thanks!

    ------------------------------
    Mike Tamoush
    ------------------------------