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: lucius.fox@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: lucius.fox@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