Deep Dive: User level formula

Stevie LaFortuneStevie LaFortune Expensify Team Posts: 122 Expensify Team
edited February 26 in Deep Dives
If you have User level information, it might be important to include in your export.

Use the formulas listed here to help create an export you can depend on!

Custom Field 1 and Custom Field 2  are within the people table in the policy settings and can be used to store anything related to the users invited to your policy.  Typically admins use this field for User or Payroll ID.  

  • {report:submit:from:customfield1} would output the custom field 1 entry associated with the user who submitted the report. If John Smith’s Custom Field 1 contains 100, then this formula would output 100.
  • {report:submit:from:customfield2} would output the custom field 2 entry associated with the user who submitted the report. If John Smith’s Custom Field 2 contains 1234, then this formula would output 1234. 


Have a question or want to know more? Start a discussion here!

Tagged:
Sign In or Register to comment.