Formula Function Reference

Our Formula Function Reference

Formula Function Reference

  • This function takes 2 or more list-user field types as arguments and returns true if  the contents of all the the arguments together, except for the first, are included in the contents of first argument; false otherwise.

    June 14th, 2011 - 9:06 AM
    Tags:
  • Returns a semi-colon separated list of the users' full names, first name first.

    June 14th, 2011 - 9:06 AM
    Tags:
  • Returns a semi-colon separated list of users' full names. Specify text format by including "FF" to return the full names with the first name first. Or, include "LF" to return the full names with the last name first.

    June 14th, 2011 - 9:06 AM
    Tags:
  • Returns a semi-colon separated list of email addresses for all the users selected on the User List field.

    This function won't work for users who have hidden their e-mail address.

    June 14th, 2011 - 9:06 AM
    Tags:
  • Concatenates  contents of one or more list-user field types into the returning field. A "user" is an individual with whom you've shared your application. You'd translate something like an e-mail address into a user value so that QuickBase recognizes the user. When you do so, you can take advantage of user fields to design permissions and/or views. For example, show a user only those tasks that have been assigned to her.

    Note: This field is of type List-User and therefore exercises the limit of 10 entries. If the resulting value of this field in a record exceeds the maximum entries allowed the resulting value will be set to blank.

    June 14th, 2011 - 9:06 AM
    Tags:
  • Concatenates the contents of one or more user type fields into a user list field type. A "user" is an individual with whom you've shared your application. You'd translate something like an e-mail address into a user value so that QuickBase recognizes the user. When you do so, you can take advantage of user fields to design permissions and/or views. For example, show a user only those tasks that have been assigned to her.

    Note: This field is of type List-User and therefore exercises the limit of 10 entries. If the resulting value of this field in a record exceeds the maximum entries allowed the resulting value will be set to blank.

    June 14th, 2011 - 9:06 AM
    Tags:
  • Returns the year number of the Date d.
    October 14th, 2009 - 4:10 PM
    Tags:
  • Returns the year number of the Date d.
    October 14th, 2009 - 4:10 PM
    Tags:
  • Returns the user's e-mail address. This function won't work for users who have hidden their e-mail address.
    October 14th, 2009 - 4:10 PM
    Tags:
  • Returns a given user's full name. Specify text format by including "FF" to return the full name with the first name first. Or, include "LF" to return the full name with the last name first.
    October 14th, 2009 - 4:10 PM
    Tags:

© 1997-2014 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit