Insert these formulas into the correct field type in the Design Form stage of the App Wizard to get the output you want.


businessstepname
Output: Name of the current task
Field Type: Text
Example: Manager Approval


createdat
Output: Date when the item was initiated
Field Type: Date
Example: 2/15/2017


createdby
Output: Email address of the Initiator
Field Type: Text
Example: bruce.wayne @wayneenterpise.co


createdby.fullname
Output: Full name of the Initiator
Field Type: Text
Example: Bruce Wayne


createdby.manager
Output: Email address of the Manager of the Initiator
Field Type: Text
Example: [email protected]wayneenterprise.co
Note
: To display the full name of the Manager:
Create a text field called Manager Email, and use the formula
createdby.manager
 

Then, create another text field called Manager Name, and enter this formula:

DLOOKUP(User.FullName,User.SheetId=Manager_Email)



department.departmenthead
Output: Email of the Department Head of the Initiator
Field Type: Text
Example: [email protected]wayneenterprise.co


department.departmentname
Output: Name of the Initiator's department
Field Type: Text
Example: Research and Development


location.locationhead

Output: Email of the Location Head of the Initiator
Field Type: Text
Example: miranda.tate @wayneenterprise.co


location.locationname
Output: Name of the Initiator's location
Field Type: Text
Example: Gotham City


modifiedat
Output: Date when the item was last modified
Field Type: Date
Example: 2/15/2017


modifiedby
Output: Email address of the person who last modified the item
Field Type: Text
Example: [email protected]

 

sheetid
Output: The unique ID of any request, often needed for third party integrations
Field Type: Text
Example: Shc5195128_6521_11e8_8859_93eb7cac4718


Did this answer your question?