Widget to display time
Hi,
We have a requirement where we have to display the local timezone of the country that is being selected from the dashboard filter. The dashboard filter on country has values like Italy, France,...
Forum Discussion
Hello R1 ,
One solution is to add a Text widget to dashboard and add below dashboard script. In the script, update the variable 'filterName' with name of Country filter, 'textWidgetID' with ID of Text widget and 'countryTimeZoneMapping' with area-time zone name mapping
dashboard.on('filterschanged', function(se, ev){
displayTime(se)
})
dashboard.on('widgetready', function(se, ev){
displayTime(se)
})
function displayTime(se){
let filterName = 'Country' //update the name of country filter
let textWidgetID = '6380c6426bc7f50039bf366b' //update widget-id of text widget
let selectedCountry = ''
//update area-timezone mapping
let countryTimeZoneMapping = {
'Brazil':'America/Sao_Paul',
'France':'Europe/Paris',
'Canada':'America/New_York',
'India':'Asia/Calcutta'
}
let filterObject = se.filters.$$items.find(el=>el.jaql.title == filterName)
if(filterObject && filterObject.jaql.filter && filterObject.jaql.filter.members)
selectedCountry = filterObject.jaql.filter.members[0]
let dateString = new Date().toLocaleString('en-US', { timeZone: countryTimeZoneMapping[selectedCountry]});
$(`widget[widgetid="${textWidgetID}"] richtexteditor .wd`).text(dateString)
}
Please let me know if have any questions
Always here to help,
Harry from QBeeQ
[email protected]
QBeeQ - Gold Implementation and Development Partner
www.qbeeq.pl
Hi Harry,
Thank you so much. That helps. Could you kindly let me know how do i find the widget ID of the text widget in question?
Regards,
R
Hi Harry,
Thank you so much. That helps. Could you kindly let me know how do i find the widget ID of the text widget in question? I tried finding out the widget ID of the text widget from the Console by giving "prism.activeDashboard.widgets.toArray()" and got the ID. But, the time doesn't get displayed while selecting the filter. Attaching the screenshot of the dashboard too.
One simple method to fins widget id is, open Script Editor window of the Text Widget and copy widget id from URL.
In below screenshot, widget ID is highlighted in yellow color
Please let me know if have any questions
Always here to help,
Harry from QBeeQ
[email protected]
QBeeQ - Gold Implementation and Development Partner
www.qbeeq.plThank you Harry. I was able to find the ID of the text widget. However, date doesn't get displayed dynamically according to the filter value. My dashboard filter name is "marketname". Attaching the dashboard script and dashboard for reference. Is there something that i'm missing here?
