When attempting to use a
Text field as the
Email Recipient for a
Notification by setting the Text field's
Input Mask to
Email Address, the Text field should be visible for selection below
Email Recipients in the Notification settings (as shown below).
0EMVM000007jXzt.pngHowever, if we set the
Text field (with the
Input Mask configured) to
calculated (by enabling the
Make this a calculated field option in the field properties), the Input Mask configuration will be removed from the Text field and it will not be available for selection under
Email Recipients in the
Notification.
This is functioning as designed.
The workaround to this behavior is to split the Text field into two separate Text fields:
- Text field 1 - This field will be a calculated field that stores the calculation and thus, will hold the field value.
- Text field 2 - This field will be configured with the Input Mask set to Email Address and used as the Email Recipient for the Notification.
Follow the steps below:
1. Configure both Text fields as described above.
2. Configure an
Archer Web Services (Archer to Archer) Data Feed to combine both Text fields where the
source is the
calculated Text field and the
target is the
text field with the
Input Mask configured.
3. In the
source application, run and save a
report with the
calculated Text field. This will generate the source
Report ID needed for the Data Feed.
4. Under the
Data Map tab, map the source calculated Text field to the target Text field (with the Email Address Input Mask).
5. Configure the rest of the Data Feed settings normally and then save and run the Data Feed.
6. Once the Data Feed is complete and the target Text field is populated successfully, the
target Text field (with
Input Mask configured) should be available for selection under
Email Recipients in the
Notification.
Note: You can set a schedule for the
Data Feed according to your needs, or have it run manually as needed.