You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

On this page

Use case

This calculated field returns the Google map location for a given address. The address is stored in another custom field Address (Text Field (single line)).

Configuration

Create a new Calculated Text Field (by JWT) custom field and name it properly.

Providing a description will help you to identify what the custom field does but this step is optional

Parsing mode

Select Advanced as parsing mode.

Parser expression

Add the following expression:

Text to be parsed for Calculated Text Field:
%{10407} != null ? "<iframe width=\"100%\" height=\"500\" id=\"gmap_canvas\" src=\"https:\/\/maps.google.com\/maps?q=" + replaceAll(toLowerCase(%{10407})," ","%20") + "&t=&z=13&ie=UTF8&iwloc=&output=embed\" frameborder=\"0\" scrolling=\"no\" marginheight=\"0\" marginwidth=\"0\"><\/iframe>" : null

%{10407} is the field code for Address.

Add the field to the relevant view screens.

Remember: All calculated fields are read-only and cannot be manually updated on a create or edit screen.

Once configured and added to an issue screen, the result will look like this:


If you still have questions, feel free to refer to our support team.