Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Trying to add a telephone number hyperlink like "tel:###" to an RTF template for BI email bursting

I'm trying to add a clickable telephone number hyperlink like "tel:###" to an RTF template used for BI-Publisher email bursting.
According to this, it should be possible:
https://answers.microsoft.com/en-us/msoffice/forum/all/clickable-phone-numbers-in-word-documents/3ed057a0-789a-47c3-bdbc-f6592e848c4e
But when I try this, the link is mutes to:
\u01\APPLTOP\instance\domains\fa.oracleoutsourcing.com\FADomain\tel:####
instead.
The phone number in the email should become clickable, so the phone number is dialed when clicked.
How can I create a tel:### link in RTF where "###" is the phone number?
I tried entering "tel://########/" into the hyperlink
Answers
-
Hi, You can try below XSL_FO element in RTF form field-
<fo:basic-link external-destination="tel:{/DATA_DS/G_1/MOBILE_NUMBER}">call <?/DATA_DS/G_1/MOBILE_NUMBER?></fo:basic-link>
XML:
<DATA_DS><G_1><MOBILE_NUMBER>+13011234567</MOBILE_NUMBER></G_1></DATA_DS>
Reference:
1 -
I've tried your approach Sandeep, but BI Pub still adds to the beginning…in my case (x's and n's replacing real values):
file://u01/app/oracle/product/xxx-xxx-3/ps_cfg_home/appserv/XXXXX/tel:nnnn
Any other ideas?
0 -
Windows adds the file reference to a hyperlink.
Do not use a hyperlink, put the code from Sandeep above into form fields.
Rgds,
Kevin
0 -
Hello Kevin and Tania,
I added the recommended to the RTF form field - if I understand correctly:This will create a link looking like standard text (no underline or different color like with other links).
Creating RTF test documents from within Word using data.xml will result in a link like:file:///C:\Users\
..xxxx\local path..
\tel:+861#######
When it is sent per email through bursting, the link changes in my case (HCM cloud) to:
file:///\\u01\APPLTOP\instance\domains\fa.oracleoutsourcing.com\FADomain\tel:91###
Neither result in the desired bare link like "tel:1234.." - just the same like what the Microsoft hint did above.
Regards,JBgood.
0