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


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


modifiedby
Output: Email address of the person who last modified the item
Field Type: Text
Example: lucius.fox @wayneenterprise.co


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


department.departmenthead
Output: Email of the Department Head of the Initiator
Field Type: Text
Example: lucius.fox @wayneenterprise.co


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


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


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


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

Did this answer your question?