[Version: 2021 - Summer]
[Build: 21222]
You can now add iFrame objects (web boxes) to your TARGIT Dashboards (TARGIT 2021 Summer Release).
The iFrame object can display any kind of web based content - e.g. Instruction videos and Help pages that are administrated outside the TARGIT environment.
Basically you can integrate anything that can be reached with a URL.
Note: Some webpages are protected from being used in an iFrame - these will just turn up blank if you try to integrate tem.
How to?
In the TARGIT client you now have a new object that you can add to the canvas - the web box which is placed in the design ribbon.
The Web box offers a very simple properties dialogue where you can put in your URL as shown below.
Note the option to add dynamic content shown with a red square (not used in the example below).
When you click Apply, it's the moment of truth where you find out if the URL is correct (and not prohibiting being used in an iFrame).
Below you see the properties dialogue on the right hand side and the resulting web box on the left hand side.
Errors
Here's another example of trying to put google into a web box.
When you click apply the web box remains empty and you get an error message in TARGIT explaining the either you URL is incorrect, or you are trying to put something in an iFrame that doesn't allow be "iFramed"
Dynamic Content use
The 2 brackets on the right hand side of the properties dialogue represents dynamic content.
Here's a couple of ways you could utilize this:
Full URL as dynamic content
This data source has 2 columns - Video name and URL:
Here we've added a slicer based on the Video column...
and then a web box where we click the double brackets symbol:
Not we use the Members tab - click the URL column and set the range to single:
Single means that the URL will only be shown when you have selected a particular video. It will work like required criteria to the end user.
By clicking ok - you now have a nice web box showing the video that you choose in your slicer:
Dynamic Content as part of URL
Some webpages support receiving parameters as a part of the URL.
An example of this is google maps.
In these data we happen to have the longitude and latitude that can place all our customers on a map:
By doing some googling you can find out how to add a google maps URL that includes longitude and latitude.
https://maps.google.com/maps?&q={LatitudeMembers},{LongitudeMembers}&iwloc=&output=embed
In this example we have put google maps into an iframe and added Latitude and Longitude as dynamic content as a part of the URL where google maps requires these to be passed as parameters:
Similar to the previous example - we can now drill down to a particular customer and through dynamic content pass the longitude and latitude to google maps.
Comments
Notice: I've added an excel file as an attachment to the article - which contains the last 3 years of relevant TARGIT Tutorials - you can just import it into your own data discovery and have these tutorials available in your TARGIT Solution.
At every release of a new version, I will publish a new version of the excel sheet in the same format so you can update the file as we go.
Hi Torben, thanks for the explanation. We would like to embedded office 365 files but exactly that is missing in your article. Please give some advices how its work and how the link format looks like.
Is ist also possible to embedded Excel files from Teams or sharepoint?
BR Jens
Hej Jens
Sorry - I missed this comment.
You need to share your document (and it needs to be shared with everyone who has the link - view rights).
After the share link you need to add some parameters, which could be like these:
&action=embedview&wdbipreview=true&wdHideSheetTabs=True&wdAllowInteractivity=True&AllowTyping=True&ActiveCell=B2&wdHideGridlines=True&wdHideHeaders=True&wdDownloadButton=True
I've done some google research about this, and there are more options out there. The first part:
&action=embedview
is the only part that is absolutely necessary.
An example of a full URL including parameters:
https://mytargit.sharepoint.com/:x:/g/EY20ek4xM3ZNk7Jhx0upcmEBOxZf5hi9_TeQGxRTK0MXbw?e=NLVgZl&action=embedview&wdbipreview=true&wdHideSheetTabs=True&wdAllowInteractivity=True&AllowTyping=True&ActiveCell=B2&wdHideGridlines=True&wdHideHeaders=True&wdDownloadButton=True
Note: This is a Microsoft article explaining about the parameters in detail: https://support.microsoft.com/en-us/office/embed-your-excel-workbook-on-your-web-page-or-blog-from-sharepoint-or-onedrive-for-business-7af74ce6-e8a0-48ac-ba3b-a1dd627b7773
Hi, How can I make sure that the web box is not displayed if certain criteria is not met as it does not have the option of 'mandatory criteria'?
I only want to display the google maps page when 1 customer is selected.
Hi Femke
You could go with the "single" setting of the range dynamic content, which ensures that data will only be passed, when exactly one is selected.
Hi Niels,
Is there a way to select more than 1 customer at a time and have Google Maps show both customers on the map? Within the dynamic context selected in my link I have the "Range" option selected for both Latitude and Longitude. It works when I select one customer, but when I select more than 1 the map does not zoom and shows the entire world. This is a really cool feature and I would love it to work for more than 1 customer at a time, thank you!
Meagan
Please sign in to leave a comment.