There are seven sample Quick Tile custom template configurations provided below. Follow the instructions below to implement within your North52 system.
- Create a new ClientSide Calculation Formula for the Table you would like the Quick Tile to be display on
- Select Commands > Toggle Editor from the menu options above the Decision Table sheet
- Copy and paste the Formula logic from the example below
- Click Save
- Refresh the browser page and the Decision Table should render with the relevant columns set
- Edit the Conditions and Labels to match your requirements
- Create a new xCache record with the relevant template details shown below
- Place the Quick Tile on your Form - see Step 3 on the Quick Tile Custom Template Configuration article
Progress Steps
Formula logic
MultipleDecisionTable(
DecisionTable(
IfTrue( 'Complete' = 'Complete' ,
CreateUIProperty('StepName-1', 'Step One Complete'),
CreateUIProperty('StepStatus-1', 'is-complete'),
SetVar('CreateControl-1', CreateUIControl(GetVar('StepName-1'),GetVar('StepStatus-1')))) ,
IfTrue( 'Complete' = 'Active' ,
CreateUIProperty('StepName-1', 'Step One Active'),
CreateUIProperty('StepStatus-1', 'is-active'),
SetVar('CreateControl-1', CreateUIControl(GetVar('StepName-1'),GetVar('StepStatus-1')))) ,
IfTrue(true,
CreateUIProperty('StepName-1', 'Step One'),
CreateUIProperty('StepStatus-1', ''),
SetVar('CreateControl-1', CreateUIControl(GetVar('StepName-1'),GetVar('StepStatus-1'))))
, IfTrue(true, GetVar('CreateControl-1', 'NoOp') )
,
'true|false|update|Step 1') ,
DecisionTable(
IfTrue( 'Active' = 'Complete' ,
CreateUIProperty('StepName-2', 'Step Two Complete'),
CreateUIProperty('StepStatus-2', 'is-complete'),
SetVar('CreateControl-2', CreateUIControl(GetVar('StepName-2'),GetVar('StepStatus-2')))) ,
IfTrue( 'Active' = 'Active' ,
CreateUIProperty('StepName-2', 'Step Two Active'),
CreateUIProperty('StepStatus-2', 'is-active'),
SetVar('CreateControl-2', CreateUIControl(GetVar('StepName-2'),GetVar('StepStatus-2')))) ,
IfTrue(true,
CreateUIProperty('StepName-2', 'Step Two'),
CreateUIProperty('StepStatus-2', ''),
SetVar('CreateControl-2', CreateUIControl(GetVar('StepName-2'),GetVar('StepStatus-2'))))
, IfTrue(true, GetVar('CreateControl-2', 'NoOp') )
,
'true|false|update|Step 2') ,
DecisionTable(
IfTrue( '' = 'Complete' ,
CreateUIProperty('StepName-3', 'Step Three Complete'),
CreateUIProperty('StepStatus-3', 'is-complete'),
SetVar('CreateControl-3', CreateUIControl(GetVar('StepName-3'),GetVar('StepStatus-3')))) ,
IfTrue( '' = 'Active' ,
CreateUIProperty('StepName-3', 'Step Three Active'),
CreateUIProperty('StepStatus-3', 'is-active'),
SetVar('CreateControl-3', CreateUIControl(GetVar('StepName-3'),GetVar('StepStatus-3')))) ,
IfTrue(true,
CreateUIProperty('StepName-3', 'Step Three'),
CreateUIProperty('StepStatus-3', ''),
SetVar('CreateControl-3', CreateUIControl(GetVar('StepName-3'),GetVar('StepStatus-3'))))
, IfTrue(true, GetVar('CreateControl-3', 'NoOp') )
,
'true|false|update|Step 3') ,
DecisionTable(
IfTrue( '' = 'Complete' ,
CreateUIProperty('StepName-4', 'Step Four Complete'),
CreateUIProperty('StepStatus-4', 'is-complete'),
SetVar('CreateControl-4', CreateUIControl(GetVar('StepName-4'),GetVar('StepStatus-4')))) ,
IfTrue( '' = 'Active' ,
CreateUIProperty('StepName-4', 'Step Four Active'),
CreateUIProperty('StepStatus-4', 'is-active'),
SetVar('CreateControl-4', CreateUIControl(GetVar('StepName-4'),GetVar('StepStatus-4')))) ,
IfTrue(true,
CreateUIProperty('StepName-4', 'Step Four'),
CreateUIProperty('StepStatus-4', ''),
SetVar('CreateControl-4', CreateUIControl(GetVar('StepName-4'),GetVar('StepStatus-4'))))
, IfTrue(true, GetVar('CreateControl-4', 'NoOp') )
,
'true|false|update|Step 4') ,
DecisionTable(
IfTrue(true,
SetVar('FinalOutput', CreateUIControlCollection(CreateUIProperty('xcachetemplate',xCacheGetGlobal('QuickTileTemplate_ProgressSteps')),GetVar('CreateControl-1'),GetVar('CreateControl-2'),GetVar('CreateControl-3'),GetVar('CreateControl-4'))))
,
'true|false|clientside|Render Tiles')
)
/*{"version":"8.40.20151.5","activeSheetIndex":4,"sheetCount":8,"newTabVisible":false,"allowDragDrop":false,"sheets":{"Step 1":{"name":"Step 1","columns":[{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":319,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":false,"dirty":null}],"rowCount":50,"columnCount":4,"data":{"dataTable":{"0":{"0":{"value":"Condition","style":{"backColor":"#ffdf80","foreColor":"Black","font":"italic 12px arial"}},"1":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"2":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"3":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}}},"1":{"0":{"value":"Step Status","style":{"backColor":"#ffdf80","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"StepName-1","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"StepStatus-1","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateControl-1","style":{"backColor":"#F4B084","font":"700 13.3333px arial","wordWrap":true}}},"2":{"0":{"value":"'Complete'","style":{"backColor":"#ffdf80","autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"ui","style":{"backColor":"#DDA0DD"}},"2":{"value":"ui","style":{"backColor":"#DDA0DD"}},"3":{"value":"==","style":{"backColor":"#F4B084"}}},"3":{"0":{"value":"'Complete'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"'Step One Complete'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"'is-complete'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateUIControl({StepName-1},{StepStatus-1})","style":{"autoFormatter":{"customerCultureName":"en-US"}}}},"4":{"0":{"value":"'Active'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"'Step One Active'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"'is-active'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateUIControl({StepName-1},{StepStatus-1})","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"5":{"1":{"value":"'Step One'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"''","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateUIControl({StepName-1},{StepStatus-1})","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}}},"columnDataArray":[{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}}]},"tag":"true|false|update","index":0},"Step 2":{"name":"Step 2","columns":[{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":319,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":false,"dirty":null}],"rowCount":50,"columnCount":4,"data":{"dataTable":{"0":{"0":{"value":"Condition","style":{"backColor":"#ffdf80","foreColor":"Black","font":"italic 12px arial"}},"1":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"2":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"3":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}}},"1":{"0":{"value":"Step Status","style":{"backColor":"#ffdf80","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"StepName-2","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"StepStatus-2","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateControl-2","style":{"backColor":"#F4B084","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}}},"2":{"0":{"value":"'Active'","style":{"backColor":"#ffdf80","hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"ui","style":{"backColor":"#DDA0DD"}},"2":{"value":"ui","style":{"backColor":"#DDA0DD"}},"3":{"value":"==","style":{"backColor":"#F4B084"}}},"3":{"0":{"value":"'Complete'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"'Step Two Complete'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"'is-complete'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateUIControl({StepName-2},{StepStatus-2})","style":{"autoFormatter":{"customerCultureName":"en-US"}}}},"4":{"0":{"value":"'Active'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"'Step Two Active'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"'is-active'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateUIControl({StepName-2},{StepStatus-2})","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"5":{"1":{"value":"'Step Two'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"''","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateUIControl({StepName-2},{StepStatus-2})","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}}},"columnDataArray":[{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}}]},"tag":"true|false|update","index":1},"Step 3":{"name":"Step 3","columns":[{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":319,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":false,"dirty":null}],"rowCount":50,"columnCount":4,"data":{"dataTable":{"0":{"0":{"value":"Condition","style":{"backColor":"#ffdf80","foreColor":"Black","font":"italic 12px arial"}},"1":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"2":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"3":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}}},"1":{"0":{"value":"Step Status","style":{"backColor":"#ffdf80","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"StepName-3","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"StepStatus-3","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateControl-3","style":{"backColor":"#F4B084","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}}},"2":{"0":{"value":"''","style":{"backColor":"#ffdf80","hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"ui","style":{"backColor":"#DDA0DD"}},"2":{"value":"ui","style":{"backColor":"#DDA0DD"}},"3":{"value":"==","style":{"backColor":"#F4B084"}}},"3":{"0":{"value":"'Complete'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"'Step Three Complete'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"'is-complete'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateUIControl({StepName-3},{StepStatus-3})","style":{"autoFormatter":{"customerCultureName":"en-US"}}}},"4":{"0":{"value":"'Active'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"'Step Three Active'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"'is-active'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateUIControl({StepName-3},{StepStatus-3})","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"5":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1}},"1":{"value":"'Step Three'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"''","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateUIControl({StepName-3},{StepStatus-3})","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}}},"columnDataArray":[{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}}]},"tag":"true|false|update","index":2},"Step 4":{"name":"Step 4","columns":[{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":319,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":false,"dirty":null}],"rowCount":50,"columnCount":4,"data":{"dataTable":{"0":{"0":{"value":"Condition","style":{"backColor":"#ffdf80","foreColor":"Black","font":"italic 12px arial"}},"1":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"2":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"3":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}}},"1":{"0":{"value":"Step Status","style":{"backColor":"#ffdf80","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"StepName-4","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"StepStatus-4","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateControl-4","style":{"backColor":"#F4B084","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}}},"2":{"0":{"value":"''","style":{"backColor":"#ffdf80","hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"ui","style":{"backColor":"#DDA0DD"}},"2":{"value":"ui","style":{"backColor":"#DDA0DD"}},"3":{"value":"==","style":{"backColor":"#F4B084"}}},"3":{"0":{"value":"'Complete'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"'Step Four Complete'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"'is-complete'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateUIControl({StepName-4},{StepStatus-4})","style":{"autoFormatter":{"customerCultureName":"en-US"}}}},"4":{"0":{"value":"'Active'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"'Step Four Active'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"'is-active'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateUIControl({StepName-4},{StepStatus-4})","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"5":{"1":{"value":"'Step Four'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"''","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateUIControl({StepName-4},{StepStatus-4})","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}}},"columnDataArray":[{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}}]},"tag":"true|false|update","index":3},"Render Tiles":{"name":"Render Tiles","selections":{"0":{"row":4,"rowCount":1,"col":0,"colCount":1}},"columns":[{"size":384,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":false,"dirty":null}],"rowCount":50,"columnCount":9,"activeRow":4,"colHeaderRowInfos":[{"size":20,"dirty":true}],"data":{"dataTable":{"0":{"0":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}},"1":{"value":"Comment","style":{"backColor":"#FFFFE1 ","font":"italic 12px arial"}}},"1":{"0":{"value":"FinalOutput","style":{"backColor":"#F4B084","font":"700 13.3333px arial"}},"1":{"style":{"backColor":"#FFFFE1 ","font":"700 13.3333px arial","wordWrap":true}}},"2":{"0":{"value":"==","style":{"backColor":"#F4B084"}},"1":{"style":{"backColor":"#FFFFE1 "}}},"3":{"0":{"value":"CreateUIControlCollection(CreateUIProperty('xcachetemplate',{{QuickTileTemplate_ProgressSteps}}),{CreateControl-1},{CreateControl-2},{CreateControl-3},{CreateControl-4})","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"Idea from https://medium.com/@beyondborders/building-a-responsive-progress-bar-ea5a0ecabe91","style":{"autoFormatter":{"customerCultureName":"en-US"}}}}},"columnDataArray":[{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}}]},"tag":"true|false|clientside","index":4},"Global Calculations":{"name":"Global Calculations","columns":[{"size":300,"dirty":null},{"size":400,"dirty":null},{"size":400,"dirty":null}],"rowCount":200,"columnCount":6,"visible":false,"data":{"dataTable":{"0":{"0":{"value":"Calculation Name","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"1":{"value":"Calculation Value","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"2":{"value":"Comment","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}}}}},"index":5},"Global Actions":{"name":"Global Actions","selections":{"0":{"row":1,"rowCount":1,"col":1,"colCount":1}},"columns":[{"size":300,"dirty":null},{"size":400,"dirty":null},{"size":400,"dirty":null}],"rowCount":200,"columnCount":6,"activeRow":1,"activeCol":1,"visible":false,"data":{"dataTable":{"0":{"0":{"value":"Action Name","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"1":{"value":"Action Value","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"2":{"value":"Comment","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}}},"1":{"0":{"style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"autoFormatter":{"customerCultureName":"en-US"}}}}}},"index":6},"Global FetchXml":{"name":"Global FetchXml","columns":[{"size":300,"dirty":null},{"size":400,"dirty":null},{"size":400,"dirty":null}],"rowCount":200,"columnCount":6,"visible":false,"data":{"dataTable":{"0":{"0":{"value":"FetchXml Name","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"1":{"value":"FetchXml Query","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"2":{"value":"Comment","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}}}}},"index":7}}}*/
xCache
Category:
QuickTileTemplate
Base Key:
QuickTileTemplate_ProgressSteps
Value:
<style>
.progress-steps {
position: relative;
display: flex;
}
.progress-steps .progress-track {
position: absolute;
top: 7px;
width: 100%;
height: 6px;
background-color: #dfe3e4;
z-index: -1;
}
.progress-steps .progress-step {
position: relative;
width: 100%;
font-size: 12px;
text-align: center;
}
.progress-steps .progress-step:last-child:after {
display: none;
}
.progress-steps .progress-step:before {
content: "\e013";
display: flex;
margin: 0 auto;
margin-bottom: 10px;
width: 20px;
height: 20px;
background: #fff;
border: 10px solid #dfe3e4;
border-radius: 100%;
color: transparent;
align-items: center;
justify-content: center;
}
.progress-steps .progress-step:after {
content: "";
position: absolute;
top: 7px;
left: 50%;
width: 0%;
transition: width 1s ease-in;
height: 6px;
background: #dfe3e4;
z-index: -1;
}
.progress-steps .progress-step.is-active {
color: #2183dd;
}
.progress-steps .progress-step.is-active:before {
border: 4px solid #777;
animation: pulse 2s infinite;
}
.progress-steps .progress-step.is-complete {
color: #090;
}
.progress-steps .progress-step.is-complete:before {
font-family: 'Glyphicons Halflings';
font-size: 10px;
color: #fff;
background: #090;
border: 11px solid transparent;
line-height: 0;
}
.progress-steps .progress-step.is-complete:after {
background: #2183dd;
animation: nextStep 1s;
animation-fill-mode: forwards;
}
@keyframes pulse {
0% {
box-shadow: 0 0 0 0 rgba(33, 131, 221, 0.4);
}
70% {
box-shadow: 0 0 0 10px rgba(33, 131, 221, 0);
}
100% {
box-shadow: 0 0 0 0 rgba(33, 131, 221, 0);
}
}
@keyframes nextStep {
0% {
width: 0%;
}
100% {
width: 100%;
}
}
.progress-container {
margin: 20px 0px;
padding-bottom: 20px;
}
.message-panel {
margin-bottom: 0;
margin-top: 30px;
text-align: center;
background-color: #d9edf7;
}
</style>
<div class="progress-container">
<div class="progress-steps">
<div class="progress-track"></div>
{{#each tiles}}{{#if stepname}}
<div id="step{{@index}}" class="progress-step {{stepstatus}}">{{stepname}}</div>
{{/if}}{{/each}}
</div>
{{#each tiles}}{{#if message}}
<div class="panel panel-info message-panel">
<div class="panel-body">
{{{message}}}
</div>
</div>
{{/if}}{{/each}}
</div>
Progress Steps with Message
Formula logic
MultipleDecisionTable(
DecisionTable(
IfTrue( 'Complete' = 'Complete' ,
CreateUIProperty('StepName-1', 'Step One Complete'),
CreateUIProperty('StepStatus-1', 'is-complete'),
SetVar('CreateControl-1', CreateUIControl(GetVar('StepName-1'),GetVar('StepStatus-1')))) ,
IfTrue( 'Complete' = 'Active' ,
CreateUIProperty('StepName-1', 'Step One Active'),
CreateUIProperty('StepStatus-1', 'is-active'),
SetVar('CreateControl-1', CreateUIControl(GetVar('StepName-1'),GetVar('StepStatus-1')))) ,
IfTrue(true,
CreateUIProperty('StepName-1', 'Step One'),
CreateUIProperty('StepStatus-1', ''),
SetVar('CreateControl-1', CreateUIControl(GetVar('StepName-1'),GetVar('StepStatus-1'))))
, IfTrue(true, GetVar('CreateControl-1', 'NoOp') )
,
'true|false|update|Step 1') ,
DecisionTable(
IfTrue( 'Active' = 'Complete' ,
CreateUIProperty('StepName-2', 'Step Two Complete'),
CreateUIProperty('StepStatus-2', 'is-complete'),
SetVar('CreateControl-2', CreateUIControl(GetVar('StepName-2'),GetVar('StepStatus-2')))) ,
IfTrue( 'Active' = 'Active' ,
CreateUIProperty('StepName-2', 'Step Two Active'),
CreateUIProperty('StepStatus-2', 'is-active'),
SetVar('CreateControl-2', CreateUIControl(GetVar('StepName-2'),GetVar('StepStatus-2')))) ,
IfTrue(true,
CreateUIProperty('StepName-2', 'Step Two'),
CreateUIProperty('StepStatus-2', ''),
SetVar('CreateControl-2', CreateUIControl(GetVar('StepName-2'),GetVar('StepStatus-2'))))
, IfTrue(true, GetVar('CreateControl-2', 'NoOp') )
,
'true|false|update|Step 2') ,
DecisionTable(
IfTrue( '' = 'Complete' ,
CreateUIProperty('StepName-3', 'Step Three Complete'),
CreateUIProperty('StepStatus-3', 'is-complete'),
SetVar('CreateControl-3', CreateUIControl(GetVar('StepName-3'),GetVar('StepStatus-3')))) ,
IfTrue( '' = 'Active' ,
CreateUIProperty('StepName-3', 'Step Three Active'),
CreateUIProperty('StepStatus-3', 'is-active'),
SetVar('CreateControl-3', CreateUIControl(GetVar('StepName-3'),GetVar('StepStatus-3')))) ,
IfTrue(true,
CreateUIProperty('StepName-3', 'Step Three'),
CreateUIProperty('StepStatus-3', ''),
SetVar('CreateControl-3', CreateUIControl(GetVar('StepName-3'),GetVar('StepStatus-3'))))
, IfTrue(true, GetVar('CreateControl-3', 'NoOp') )
,
'true|false|update|Step 3') ,
DecisionTable(
IfTrue( '' = 'Complete' ,
CreateUIProperty('StepName-4', 'Step Four Complete'),
CreateUIProperty('StepStatus-4', 'is-complete'),
SetVar('CreateControl-4', CreateUIControl(GetVar('StepName-4'),GetVar('StepStatus-4')))) ,
IfTrue( '' = 'Active' ,
CreateUIProperty('StepName-4', 'Step Four Active'),
CreateUIProperty('StepStatus-4', 'is-active'),
SetVar('CreateControl-4', CreateUIControl(GetVar('StepName-4'),GetVar('StepStatus-4')))) ,
IfTrue(true,
CreateUIProperty('StepName-4', 'Step Four'),
CreateUIProperty('StepStatus-4', ''),
SetVar('CreateControl-4', CreateUIControl(GetVar('StepName-4'),GetVar('StepStatus-4'))))
, IfTrue(true, GetVar('CreateControl-4', 'NoOp') )
,
'true|false|update|Step 4') ,
DecisionTable(
IfTrue(true,
CreateUIProperty('Message-5', 'This is a message that can be displayed below the steps indicator'),
SetVar('CreateControl-5', CreateUIControl(GetVar('Message-5'))))
, IfTrue(true, GetVar('CreateControl-5', 'NoOp') )
,
'true|false|update|Message') ,
DecisionTable(
IfTrue(true,
SetVar('FinalOutput', CreateUIControlCollection(CreateUIProperty('xcachetemplate',xCacheGetGlobal('QuickTileTemplate_ProgressSteps')),GetVar('CreateControl-1'),GetVar('CreateControl-2'),GetVar('CreateControl-3'),GetVar('CreateControl-4'),GetVar('CreateControl-5'))))
,
'true|false|clientside|Render Tiles')
)
/*{"version":"8.40.20151.5","activeSheetIndex":5,"sheetCount":9,"newTabVisible":false,"allowDragDrop":false,"sheets":{"Step 1":{"name":"Step 1","columns":[{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":319,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":false,"dirty":null}],"rowCount":50,"columnCount":4,"data":{"dataTable":{"0":{"0":{"value":"Condition","style":{"backColor":"#ffdf80","foreColor":"Black","font":"italic 12px arial"}},"1":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"2":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"3":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}}},"1":{"0":{"value":"Step Status","style":{"backColor":"#ffdf80","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"StepName-1","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"StepStatus-1","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateControl-1","style":{"backColor":"#F4B084","font":"700 13.3333px arial","wordWrap":true}}},"2":{"0":{"value":"'Complete'","style":{"backColor":"#ffdf80","autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"ui","style":{"backColor":"#DDA0DD"}},"2":{"value":"ui","style":{"backColor":"#DDA0DD"}},"3":{"value":"==","style":{"backColor":"#F4B084"}}},"3":{"0":{"value":"'Complete'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"'Step One Complete'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"'is-complete'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateUIControl({StepName-1},{StepStatus-1})","style":{"autoFormatter":{"customerCultureName":"en-US"}}}},"4":{"0":{"value":"'Active'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"'Step One Active'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"'is-active'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateUIControl({StepName-1},{StepStatus-1})","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"5":{"1":{"value":"'Step One'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"''","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateUIControl({StepName-1},{StepStatus-1})","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}}},"columnDataArray":[{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}}]},"tag":"true|false|update","index":0},"Step 2":{"name":"Step 2","columns":[{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":319,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":false,"dirty":null}],"rowCount":50,"columnCount":4,"data":{"dataTable":{"0":{"0":{"value":"Condition","style":{"backColor":"#ffdf80","foreColor":"Black","font":"italic 12px arial"}},"1":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"2":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"3":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}}},"1":{"0":{"value":"Step Status","style":{"backColor":"#ffdf80","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"StepName-2","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"StepStatus-2","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateControl-2","style":{"backColor":"#F4B084","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}}},"2":{"0":{"value":"'Active'","style":{"backColor":"#ffdf80","hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"ui","style":{"backColor":"#DDA0DD"}},"2":{"value":"ui","style":{"backColor":"#DDA0DD"}},"3":{"value":"==","style":{"backColor":"#F4B084"}}},"3":{"0":{"value":"'Complete'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"'Step Two Complete'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"'is-complete'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateUIControl({StepName-2},{StepStatus-2})","style":{"autoFormatter":{"customerCultureName":"en-US"}}}},"4":{"0":{"value":"'Active'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"'Step Two Active'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"'is-active'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateUIControl({StepName-2},{StepStatus-2})","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"5":{"1":{"value":"'Step Two'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"''","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateUIControl({StepName-2},{StepStatus-2})","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}}},"columnDataArray":[{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}}]},"tag":"true|false|update","index":1},"Step 3":{"name":"Step 3","columns":[{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":319,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":false,"dirty":null}],"rowCount":50,"columnCount":4,"data":{"dataTable":{"0":{"0":{"value":"Condition","style":{"backColor":"#ffdf80","foreColor":"Black","font":"italic 12px arial"}},"1":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"2":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"3":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}}},"1":{"0":{"value":"Step Status","style":{"backColor":"#ffdf80","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"StepName-3","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"StepStatus-3","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateControl-3","style":{"backColor":"#F4B084","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}}},"2":{"0":{"value":"''","style":{"backColor":"#ffdf80","hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"ui","style":{"backColor":"#DDA0DD"}},"2":{"value":"ui","style":{"backColor":"#DDA0DD"}},"3":{"value":"==","style":{"backColor":"#F4B084"}}},"3":{"0":{"value":"'Complete'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"'Step Three Complete'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"'is-complete'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateUIControl({StepName-3},{StepStatus-3})","style":{"autoFormatter":{"customerCultureName":"en-US"}}}},"4":{"0":{"value":"'Active'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"'Step Three Active'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"'is-active'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateUIControl({StepName-3},{StepStatus-3})","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"5":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1}},"1":{"value":"'Step Three'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"''","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateUIControl({StepName-3},{StepStatus-3})","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}}},"columnDataArray":[{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}}]},"tag":"true|false|update","index":2},"Step 4":{"name":"Step 4","columns":[{"size":120,"dirty":null},{"size":419,"dirty":null},{"size":120,"dirty":null},{"size":319,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":false,"dirty":null}],"rowCount":50,"columnCount":4,"data":{"dataTable":{"0":{"0":{"value":"Condition","style":{"backColor":"#ffdf80","foreColor":"Black","font":"italic 12px arial"}},"1":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"2":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"3":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}}},"1":{"0":{"value":"Step Status","style":{"backColor":"#ffdf80","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"StepName-4","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"StepStatus-4","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateControl-4","style":{"backColor":"#F4B084","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}}},"2":{"0":{"value":"''","style":{"backColor":"#ffdf80","hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"ui","style":{"backColor":"#DDA0DD"}},"2":{"value":"ui","style":{"backColor":"#DDA0DD"}},"3":{"value":"==","style":{"backColor":"#F4B084"}}},"3":{"0":{"value":"'Complete'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"'Step Four Complete'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"'is-complete'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateUIControl({StepName-4},{StepStatus-4})","style":{"autoFormatter":{"customerCultureName":"en-US"}}}},"4":{"0":{"value":"'Active'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"'Step Four Active'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"'is-active'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateUIControl({StepName-4},{StepStatus-4})","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"5":{"1":{"value":"'Step Four'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"''","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateUIControl({StepName-4},{StepStatus-4})","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}}},"columnDataArray":[{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}}]},"tag":"true|false|update","index":3},"Message":{"name":"Message","selections":{"0":{"row":3,"rowCount":1,"col":1,"colCount":1}},"columns":[{"size":120,"dirty":null},{"size":419,"dirty":null},{"size":319,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":false,"dirty":null}],"rowCount":50,"columnCount":3,"activeRow":3,"activeCol":1,"data":{"dataTable":{"0":{"0":{"value":"Condition","style":{"backColor":"#ffdf80","foreColor":"Black","font":"italic 12px arial"}},"1":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"2":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}}},"1":{"0":{"style":{"backColor":"#ffdf80","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"Message-5","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"CreateControl-5","style":{"backColor":"#F4B084","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}}},"2":{"0":{"value":"''","style":{"backColor":"#ffdf80","hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"ui","style":{"backColor":"#DDA0DD"}},"2":{"value":"==","style":{"backColor":"#F4B084"}}},"3":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"'This is a message that can be displayed below the steps indicator'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"CreateUIControl({Message-5})","style":{"autoFormatter":{"customerCultureName":"en-US"}}}},"4":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"5":{"1":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}}},"columnDataArray":[{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}}]},"tag":"true|false|update","index":4},"Render Tiles":{"name":"Render Tiles","selections":{"0":{"row":4,"rowCount":1,"col":0,"colCount":1}},"columns":[{"size":384,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":false,"dirty":null}],"rowCount":50,"columnCount":9,"activeRow":4,"colHeaderRowInfos":[{"size":20,"dirty":true}],"data":{"dataTable":{"0":{"0":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}},"1":{"value":"Comment","style":{"backColor":"#FFFFE1 ","font":"italic 12px arial"}}},"1":{"0":{"value":"FinalOutput","style":{"backColor":"#F4B084","font":"700 13.3333px arial"}},"1":{"style":{"backColor":"#FFFFE1 ","font":"700 13.3333px arial","wordWrap":true}}},"2":{"0":{"value":"==","style":{"backColor":"#F4B084"}},"1":{"style":{"backColor":"#FFFFE1 "}}},"3":{"0":{"value":"CreateUIControlCollection(CreateUIProperty('xcachetemplate',{{QuickTileTemplate_ProgressSteps}}),{CreateControl-1},{CreateControl-2},{CreateControl-3},{CreateControl-4},{CreateControl-5})","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"Idea from https://medium.com/@beyondborders/building-a-responsive-progress-bar-ea5a0ecabe91","style":{"autoFormatter":{"customerCultureName":"en-US"}}}}},"columnDataArray":[{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}}]},"tag":"true|false|clientside","index":5},"Global Calculations":{"name":"Global Calculations","columns":[{"size":300,"dirty":null},{"size":400,"dirty":null},{"size":400,"dirty":null}],"rowCount":200,"columnCount":6,"visible":false,"data":{"dataTable":{"0":{"0":{"value":"Calculation Name","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"1":{"value":"Calculation Value","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"2":{"value":"Comment","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}}}}},"index":6},"Global Actions":{"name":"Global Actions","selections":{"0":{"row":1,"rowCount":1,"col":1,"colCount":1}},"columns":[{"size":300,"dirty":null},{"size":400,"dirty":null},{"size":400,"dirty":null}],"rowCount":200,"columnCount":6,"activeRow":1,"activeCol":1,"visible":false,"data":{"dataTable":{"0":{"0":{"value":"Action Name","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"1":{"value":"Action Value","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"2":{"value":"Comment","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}}},"1":{"0":{"style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"autoFormatter":{"customerCultureName":"en-US"}}}}}},"index":7},"Global FetchXml":{"name":"Global FetchXml","columns":[{"size":300,"dirty":null},{"size":400,"dirty":null},{"size":400,"dirty":null}],"rowCount":200,"columnCount":6,"visible":false,"data":{"dataTable":{"0":{"0":{"value":"FetchXml Name","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"1":{"value":"FetchXml Query","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"2":{"value":"Comment","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}}}}},"index":8}}}*/
xCache
Category:
QuickTileTemplate
Base Key:
QuickTileTemplate_ProgressSteps
Value:
<style>
.progress-steps {
position: relative;
display: flex;
}
.progress-steps .progress-track {
position: absolute;
top: 7px;
width: 100%;
height: 6px;
background-color: #dfe3e4;
z-index: -1;
}
.progress-steps .progress-step {
position: relative;
width: 100%;
font-size: 12px;
text-align: center;
}
.progress-steps .progress-step:last-child:after {
display: none;
}
.progress-steps .progress-step:before {
content: "\e013";
display: flex;
margin: 0 auto;
margin-bottom: 10px;
width: 20px;
height: 20px;
background: #fff;
border: 10px solid #dfe3e4;
border-radius: 100%;
color: transparent;
align-items: center;
justify-content: center;
}
.progress-steps .progress-step:after {
content: "";
position: absolute;
top: 7px;
left: 50%;
width: 0%;
transition: width 1s ease-in;
height: 6px;
background: #dfe3e4;
z-index: -1;
}
.progress-steps .progress-step.is-active {
color: #2183dd;
}
.progress-steps .progress-step.is-active:before {
border: 4px solid #777;
animation: pulse 2s infinite;
}
.progress-steps .progress-step.is-complete {
color: #090;
}
.progress-steps .progress-step.is-complete:before {
font-family: 'Glyphicons Halflings';
font-size: 10px;
color: #fff;
background: #090;
border: 11px solid transparent;
line-height: 0;
}
.progress-steps .progress-step.is-complete:after {
background: #2183dd;
animation: nextStep 1s;
animation-fill-mode: forwards;
}
@keyframes pulse {
0% {
box-shadow: 0 0 0 0 rgba(33, 131, 221, 0.4);
}
70% {
box-shadow: 0 0 0 10px rgba(33, 131, 221, 0);
}
100% {
box-shadow: 0 0 0 0 rgba(33, 131, 221, 0);
}
}
@keyframes nextStep {
0% {
width: 0%;
}
100% {
width: 100%;
}
}
.progress-container {
margin: 20px 0px;
padding-bottom: 20px;
}
.message-panel {
margin-bottom: 0;
margin-top: 30px;
text-align: center;
background-color: #d9edf7;
}
</style>
<div class="progress-container">
<div class="progress-steps">
<div class="progress-track"></div>
{{#each tiles}}{{#if stepname}}
<div id="step{{@index}}" class="progress-step {{stepstatus}}">{{stepname}}</div>
{{/if}}{{/each}}
</div>
{{#each tiles}}{{#if message}}
<div class="panel panel-info message-panel">
<div class="panel-body">
{{{message}}}
</div>
</div>
{{/if}}{{/each}}
</div>
Labels
Formula logic
MultipleDecisionTable(
DecisionTable(
IfTrue(true,
CreateUIProperty('Label-1', 'Default'),
CreateUIProperty('Class-1', 'default'),
CreateUIProperty('Style-1', ''),
CreateUIProperty('Link-1', ''),
CreateUIProperty('LinkTarget-1', ''),
SetVar('CreateControl-1', CreateUIControl(GetVar('Label-1'),GetVar('Class-1'),GetVar('Style-1'),GetVar('Link-1'),GetVar('LinkTarget-1'))))
, IfTrue(true, GetVar('CreateControl-1', 'NoOp') )
,
'true|false|update|Label 1') ,
DecisionTable(
IfTrue(true,
CreateUIProperty('Label-2', 'Label Primary'),
CreateUIProperty('Class-2', 'primary'),
CreateUIProperty('Style-2', ''),
CreateUIProperty('Link-2', ''),
CreateUIProperty('LinkTarget-2', ''),
SetVar('CreateControl-2', CreateUIControl(GetVar('Label-2'),GetVar('Class-2'),GetVar('Style-2'),GetVar('Link-2'),GetVar('LinkTarget-2'))))
, IfTrue(true, GetVar('CreateControl-2', 'NoOp') )
,
'true|false|update|Label 2') ,
DecisionTable(
IfTrue(true,
CreateUIProperty('Label-3', 'Label Success'),
CreateUIProperty('Class-3', 'success'),
CreateUIProperty('Style-3', ''),
CreateUIProperty('Link-3', ''),
CreateUIProperty('LinkTarget-3', ''),
SetVar('CreateControl-3', CreateUIControl(GetVar('Label-3'),GetVar('Class-3'),GetVar('Style-3'),GetVar('Link-3'),GetVar('LinkTarget-3'))))
, IfTrue(true, GetVar('CreateControl-3', 'NoOp') )
,
'true|false|update|Label 3') ,
DecisionTable(
IfTrue(true,
CreateUIProperty('Label-4', 'Label Info'),
CreateUIProperty('Class-4', 'info'),
CreateUIProperty('Style-4', ''),
CreateUIProperty('Link-4', ''),
CreateUIProperty('LinkTarget-4', ''),
SetVar('CreateControl-4', CreateUIControl(GetVar('Label-4'),GetVar('Class-4'),GetVar('Style-4'),GetVar('Link-4'),GetVar('LinkTarget-4'))))
, IfTrue(true, GetVar('CreateControl-4', 'NoOp') )
,
'true|false|update|Label 4') ,
DecisionTable(
IfTrue(true,
CreateUIProperty('Label-5', 'Label Warning'),
CreateUIProperty('Class-5', 'warning'),
CreateUIProperty('Style-5', ''),
CreateUIProperty('Link-5', ''),
CreateUIProperty('LinkTarget-5', ''),
SetVar('CreateControl-5', CreateUIControl(GetVar('Label-5'),GetVar('Class-5'),GetVar('Style-5'),GetVar('Link-5'),GetVar('LinkTarget-5'))))
, IfTrue(true, GetVar('CreateControl-5', 'NoOp') )
,
'true|false|update|Label 5') ,
DecisionTable(
IfTrue(true,
CreateUIProperty('Label-6', 'Label Danger'),
CreateUIProperty('Class-6', 'danger'),
CreateUIProperty('Style-6', ''),
CreateUIProperty('Link-6', ''),
CreateUIProperty('LinkTarget-6', ''),
SetVar('CreateControl-6', CreateUIControl(GetVar('Label-6'),GetVar('Class-6'),GetVar('Style-6'),GetVar('Link-6'),GetVar('LinkTarget-6'))))
, IfTrue(true, GetVar('CreateControl-6', 'NoOp') )
,
'true|false|update|Label 6') ,
DecisionTable(
IfTrue(true,
CreateUIProperty('Label-7', 'Label Custom 💥'),
CreateUIProperty('Class-7', ''),
CreateUIProperty('Style-7', 'color: #333;background-color: #f5f5f5;'),
CreateUIProperty('Link-7', ''),
CreateUIProperty('LinkTarget-7', ''),
SetVar('CreateControl-7', CreateUIControl(GetVar('Label-7'),GetVar('Class-7'),GetVar('Style-7'),GetVar('Link-7'),GetVar('LinkTarget-7'))))
, IfTrue(true, GetVar('CreateControl-7', 'NoOp') )
,
'true|false|update|Label Custom') ,
DecisionTable(
IfTrue(true,
SetVar('FinalOutput', CreateUIControlCollection(CreateUIProperty('xcachetemplate',xCacheGetGlobal('QuickTileTemplate_Labels')),GetVar('CreateControl-1'),GetVar('CreateControl-2'),GetVar('CreateControl-3'),GetVar('CreateControl-4'),GetVar('CreateControl-5'),GetVar('CreateControl-6'),GetVar('CreateControl-7'))))
, IfTrue(true, GetVar('FinalOutput', 'NoOp') )
,
'true|false|clientside|Render Tiles')
)
/*{"version":"8.40.20151.5","sheetCount":11,"newTabVisible":false,"allowDragDrop":false,"sheets":{"Label 1":{"name":"Label 1","columns":[{"size":186.99999976158142,"dirty":null},{"size":138.99999976158142,"dirty":null},{"size":156,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":319,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":false,"dirty":null}],"rowCount":50,"columnCount":6,"data":{"dataTable":{"0":{"0":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"1":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"2":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","hAlign":0,"vAlign":0,"font":"italic 12px arial","imeMode":1}},"3":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","hAlign":0,"vAlign":0,"font":"italic 12px arial","imeMode":1}},"4":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","hAlign":0,"vAlign":0,"font":"italic 12px arial","imeMode":1}},"5":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}}},"1":{"0":{"value":"Label-1","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"Class-1","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"Style-1","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"Link-1","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"LinkTarget-1","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"value":"CreateControl-1","style":{"backColor":"#F4B084","font":"700 13.3333px arial","wordWrap":true}}},"2":{"0":{"value":"ui","style":{"backColor":"#DDA0DD"}},"1":{"value":"ui","style":{"backColor":"#DDA0DD"}},"2":{"value":"ui","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"imeMode":1}},"3":{"value":"ui","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"imeMode":1}},"4":{"value":"ui","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"imeMode":1}},"5":{"value":"==","style":{"backColor":"#F4B084"}}},"3":{"0":{"value":"'Default'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"'default'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"''","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"''","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"''","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"value":"CreateUIControl({Label-1},{Class-1},{Style-1},{Link-1},{LinkTarget-1})","style":{"autoFormatter":{"customerCultureName":"en-US"}}}},"4":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"5":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"6":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}}},"columnDataArray":[{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}}]},"tag":"true|false|update","index":0},"Label 2":{"name":"Label 2","selections":{"0":{"row":0,"rowCount":1,"col":2,"colCount":1}},"columns":[{"size":186.99999976158142,"dirty":null},{"size":138.99999976158142,"dirty":null},{"size":156,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":319,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":false,"dirty":null}],"rowCount":50,"columnCount":6,"activeCol":2,"data":{"dataTable":{"0":{"0":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"1":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"2":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","hAlign":0,"vAlign":0,"font":"italic 12px arial","imeMode":1}},"3":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","hAlign":0,"vAlign":0,"font":"italic 12px arial","imeMode":1}},"4":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","hAlign":0,"vAlign":0,"font":"italic 12px arial","imeMode":1}},"5":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}}},"1":{"0":{"value":"Label-2","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"Class-2","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"Style-2","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"Link-2","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"LinkTarget-2","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"value":"CreateControl-2","style":{"backColor":"#F4B084","font":"700 13.3333px arial","wordWrap":true}}},"2":{"0":{"value":"ui","style":{"backColor":"#DDA0DD"}},"1":{"value":"ui","style":{"backColor":"#DDA0DD"}},"2":{"value":"ui","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"imeMode":1}},"3":{"value":"ui","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"imeMode":1}},"4":{"value":"ui","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"imeMode":1}},"5":{"value":"==","style":{"backColor":"#F4B084"}}},"3":{"0":{"value":"'Label Primary'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"'primary'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"''","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"''","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"''","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"value":"CreateUIControl({Label-2},{Class-2},{Style-2},{Link-2},{LinkTarget-2})","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"4":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"5":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"6":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}}},"columnDataArray":[{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}}]},"tag":"true|false|update","index":1},"Label 3":{"name":"Label 3","selections":{"0":{"row":0,"rowCount":1,"col":2,"colCount":1}},"columns":[{"size":186.99999976158142,"dirty":null},{"size":138.99999976158142,"dirty":null},{"size":156,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":319,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":false,"dirty":null}],"rowCount":50,"columnCount":6,"activeCol":2,"data":{"dataTable":{"0":{"0":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"1":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"2":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","hAlign":0,"vAlign":0,"font":"italic 12px arial","imeMode":1}},"3":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","hAlign":0,"vAlign":0,"font":"italic 12px arial","imeMode":1}},"4":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","hAlign":0,"vAlign":0,"font":"italic 12px arial","imeMode":1}},"5":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}}},"1":{"0":{"value":"Label-3","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"Class-3","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"Style-3","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"Link-3","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"LinkTarget-3","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"value":"CreateControl-3","style":{"backColor":"#F4B084","font":"700 13.3333px arial","wordWrap":true}}},"2":{"0":{"value":"ui","style":{"backColor":"#DDA0DD"}},"1":{"value":"ui","style":{"backColor":"#DDA0DD"}},"2":{"value":"ui","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"imeMode":1}},"3":{"value":"ui","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"imeMode":1}},"4":{"value":"ui","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"imeMode":1}},"5":{"value":"==","style":{"backColor":"#F4B084"}}},"3":{"0":{"value":"'Label Success'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"'success'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"''","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"''","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"''","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"value":"CreateUIControl({Label-3},{Class-3},{Style-3},{Link-3},{LinkTarget-3})","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"4":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"5":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"6":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}}},"columnDataArray":[{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}}]},"tag":"true|false|update","index":2},"Label 4":{"name":"Label 4","selections":{"0":{"row":0,"rowCount":1,"col":2,"colCount":1}},"columns":[{"size":186.99999976158142,"dirty":null},{"size":138.99999976158142,"dirty":null},{"size":156,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":319,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":false,"dirty":null}],"rowCount":50,"columnCount":6,"activeCol":2,"data":{"dataTable":{"0":{"0":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"1":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"2":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","hAlign":0,"vAlign":0,"font":"italic 12px arial","imeMode":1}},"3":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","hAlign":0,"vAlign":0,"font":"italic 12px arial","imeMode":1}},"4":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","hAlign":0,"vAlign":0,"font":"italic 12px arial","imeMode":1}},"5":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}}},"1":{"0":{"value":"Label-4","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"Class-4","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"Style-4","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"Link-4","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"LinkTarget-4","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"value":"CreateControl-4","style":{"backColor":"#F4B084","font":"700 13.3333px arial","wordWrap":true}}},"2":{"0":{"value":"ui","style":{"backColor":"#DDA0DD"}},"1":{"value":"ui","style":{"backColor":"#DDA0DD"}},"2":{"value":"ui","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"imeMode":1}},"3":{"value":"ui","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"imeMode":1}},"4":{"value":"ui","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"imeMode":1}},"5":{"value":"==","style":{"backColor":"#F4B084"}}},"3":{"0":{"value":"'Label Info'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"'info'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"''","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"''","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"''","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"value":"CreateUIControl({Label-4},{Class-4},{Style-4},{Link-4},{LinkTarget-4})","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"4":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"5":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"6":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}}},"columnDataArray":[{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}}]},"tag":"true|false|update","index":3},"Label 5":{"name":"Label 5","selections":{"0":{"row":0,"rowCount":1,"col":2,"colCount":1}},"columns":[{"size":186.99999976158142,"dirty":null},{"size":138.99999976158142,"dirty":null},{"size":156,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":319,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":false,"dirty":null}],"rowCount":50,"columnCount":6,"activeCol":2,"data":{"dataTable":{"0":{"0":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"1":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"2":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","hAlign":0,"vAlign":0,"font":"italic 12px arial","imeMode":1}},"3":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","hAlign":0,"vAlign":0,"font":"italic 12px arial","imeMode":1}},"4":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","hAlign":0,"vAlign":0,"font":"italic 12px arial","imeMode":1}},"5":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}}},"1":{"0":{"value":"Label-5","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"Class-5","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"Style-5","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"Link-5","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"LinkTarget-5","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"value":"CreateControl-5","style":{"backColor":"#F4B084","font":"700 13.3333px arial","wordWrap":true}}},"2":{"0":{"value":"ui","style":{"backColor":"#DDA0DD"}},"1":{"value":"ui","style":{"backColor":"#DDA0DD"}},"2":{"value":"ui","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"imeMode":1}},"3":{"value":"ui","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"imeMode":1}},"4":{"value":"ui","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"imeMode":1}},"5":{"value":"==","style":{"backColor":"#F4B084"}}},"3":{"0":{"value":"'Label Warning'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"'warning'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"''","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"''","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"''","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"value":"CreateUIControl({Label-5},{Class-5},{Style-5},{Link-5},{LinkTarget-5})","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"4":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"5":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"6":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}}},"columnDataArray":[{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}}]},"tag":"true|false|update","index":4},"Label 6":{"name":"Label 6","columns":[{"size":186.99999976158142,"dirty":null},{"size":138.99999976158142,"dirty":null},{"size":156,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":319,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":false,"dirty":null}],"rowCount":50,"columnCount":6,"data":{"dataTable":{"0":{"0":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"1":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"2":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","hAlign":0,"vAlign":0,"font":"italic 12px arial","imeMode":1}},"3":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","hAlign":0,"vAlign":0,"font":"italic 12px arial","imeMode":1}},"4":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","hAlign":0,"vAlign":0,"font":"italic 12px arial","imeMode":1}},"5":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}}},"1":{"0":{"value":"Label-6","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"Class-6","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"Style-6","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"Link-6","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"LinkTarget-6","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"value":"CreateControl-6","style":{"backColor":"#F4B084","font":"700 13.3333px arial","wordWrap":true}}},"2":{"0":{"value":"ui","style":{"backColor":"#DDA0DD"}},"1":{"value":"ui","style":{"backColor":"#DDA0DD"}},"2":{"value":"ui","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"imeMode":1}},"3":{"value":"ui","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"imeMode":1}},"4":{"value":"ui","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"imeMode":1}},"5":{"value":"==","style":{"backColor":"#F4B084"}}},"3":{"0":{"value":"'Label Danger'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"'danger'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"''","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"''","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"''","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"value":"CreateUIControl({Label-6},{Class-6},{Style-6},{Link-6},{LinkTarget-6})","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"4":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"5":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"6":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}}},"columnDataArray":[{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}}]},"tag":"true|false|update","index":5},"Label Custom":{"name":"Label Custom","columns":[{"size":186.99999976158142,"dirty":null},{"size":138.99999976158142,"dirty":null},{"size":156,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":319,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":false,"dirty":null}],"rowCount":50,"columnCount":6,"data":{"dataTable":{"0":{"0":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"1":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"2":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","hAlign":0,"vAlign":0,"font":"italic 12px arial","imeMode":1}},"3":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","hAlign":0,"vAlign":0,"font":"italic 12px arial","imeMode":1}},"4":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","hAlign":0,"vAlign":0,"font":"italic 12px arial","imeMode":1}},"5":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}}},"1":{"0":{"value":"Label-7","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"Class-7","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"Style-7","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"Link-7","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"LinkTarget-7","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"value":"CreateControl-7","style":{"backColor":"#F4B084","font":"700 13.3333px arial","wordWrap":true}}},"2":{"0":{"value":"ui","style":{"backColor":"#DDA0DD"}},"1":{"value":"ui","style":{"backColor":"#DDA0DD"}},"2":{"value":"ui","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"imeMode":1}},"3":{"value":"ui","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"imeMode":1}},"4":{"value":"ui","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"imeMode":1}},"5":{"value":"==","style":{"backColor":"#F4B084"}}},"3":{"0":{"value":"'Label Custom 💥'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"''","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"'color: #333;background-color: #f5f5f5;'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"''","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"''","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"value":"CreateUIControl({Label-7},{Class-7},{Style-7},{Link-7},{LinkTarget-7})","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"4":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"5":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"6":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}}},"columnDataArray":[{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}}]},"tag":"true|false|update","index":6},"Render Tiles":{"name":"Render Tiles","columns":[{"size":384,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":false,"dirty":null}],"rowCount":50,"columnCount":9,"colHeaderRowInfos":[{"size":20,"dirty":true}],"data":{"dataTable":{"0":{"0":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}},"1":{"value":"Comment","style":{"backColor":"#FFFFE1 ","font":"italic 12px arial"}}},"1":{"0":{"value":"FinalOutput","style":{"backColor":"#F4B084","font":"700 13.3333px arial"}},"1":{"style":{"backColor":"#FFFFE1 ","font":"700 13.3333px arial","wordWrap":true}}},"2":{"0":{"value":"==","style":{"backColor":"#F4B084"}},"1":{"style":{"backColor":"#FFFFE1 "}}},"3":{"0":{"value":"CreateUIControlCollection(CreateUIProperty('xcachetemplate',{{QuickTileTemplate_Labels}}),{CreateControl-1},{CreateControl-2},{CreateControl-3},{CreateControl-4},{CreateControl-5},{CreateControl-6},{CreateControl-7})","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"autoFormatter":{"customerCultureName":"en-US"}}}}},"columnDataArray":[{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}}]},"tag":"true|false|clientside","index":7},"Global Calculations":{"name":"Global Calculations","columns":[{"size":300,"dirty":null},{"size":400,"dirty":null},{"size":400,"dirty":null}],"rowCount":200,"columnCount":6,"visible":false,"data":{"dataTable":{"0":{"0":{"value":"Calculation Name","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"1":{"value":"Calculation Value","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"2":{"value":"Comment","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}}}}},"index":8},"Global Actions":{"name":"Global Actions","selections":{"0":{"row":1,"rowCount":1,"col":1,"colCount":1}},"columns":[{"size":300,"dirty":null},{"size":400,"dirty":null},{"size":400,"dirty":null}],"rowCount":200,"columnCount":6,"activeRow":1,"activeCol":1,"visible":false,"data":{"dataTable":{"0":{"0":{"value":"Action Name","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"1":{"value":"Action Value","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"2":{"value":"Comment","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}}},"1":{"0":{"style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"autoFormatter":{"customerCultureName":"en-US"}}}}}},"index":9},"Global FetchXml":{"name":"Global FetchXml","columns":[{"size":300,"dirty":null},{"size":400,"dirty":null},{"size":400,"dirty":null}],"rowCount":200,"columnCount":6,"visible":false,"data":{"dataTable":{"0":{"0":{"value":"FetchXml Name","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"1":{"value":"FetchXml Query","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"2":{"value":"Comment","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}}}}},"index":10}}}*/
xCache
Category:
QuickTileTemplate
Base Key:
QuickTileTemplate_Labels
Value:
<style>.label{font-size:85%}</style>
{{#each tiles}}{{#if link}}<a href="{{link}}" target="{{linktarget}}">{{/if}}<span class="label {{#if class}}label-{{class}}{{/if}}" style="{{{style}}}">{{label}}</span>{{#if link}}</a>{{/if}} {{/each}}
Statistics
Formula logic
MultipleDecisionTable(
DecisionTable(
IfTrue(true,
CreateUIProperty('StatValue-1', '1,576'),
CreateUIProperty('StatLabel-1', 'Total Units'),
CreateUIProperty('Class-1', ''),
SetVar('CreateControl-1', CreateUIControl(GetVar('StatValue-1'),GetVar('StatLabel-1'),GetVar('Class-1'))))
, IfTrue(true, GetVar('CreateControl-1', 'NoOp') )
,
'true|false|update|Stat 1') ,
DecisionTable(
IfTrue(true,
CreateUIProperty('StatValue-2', '$2,345'),
CreateUIProperty('StatLabel-2', 'Total Sales'),
CreateUIProperty('Class-2', 'positive'),
SetVar('CreateControl-2', CreateUIControl(GetVar('StatValue-2'),GetVar('StatLabel-2'),GetVar('Class-2'))))
, IfTrue(true, GetVar('CreateControl-2', 'NoOp') )
,
'true|false|update|Stat 2') ,
DecisionTable(
IfTrue(true,
CreateUIProperty('StatValue-3', '$1,396'),
CreateUIProperty('StatLabel-3', 'Total Costs'),
CreateUIProperty('Class-3', 'negative'),
SetVar('CreateControl-3', CreateUIControl(GetVar('StatValue-3'),GetVar('StatLabel-3'),GetVar('Class-3'))))
, IfTrue(true, GetVar('CreateControl-3', 'NoOp') )
,
'true|false|update|Stat 3') ,
DecisionTable(
IfTrue(true,
SetVar('FinalOutput', CreateUIControlCollection(CreateUIProperty('xcachetemplate',xCacheGetGlobal('QuickTileTemplate_StatsList')),GetVar('CreateControl-1'),GetVar('CreateControl-2'),GetVar('CreateControl-3'))))
, IfTrue(true, GetVar('FinalOutput', 'NoOp') )
,
'true|false|clientside|Render Tiles')
)
/*{"version":"8.40.20151.5","activeSheetIndex":3,"sheetCount":8,"tabStripRatio":0.6949078138718178,"newTabVisible":false,"allowDragDrop":false,"sheets":{"Info exclude":{"name":"Info exclude","selections":{"0":{"row":18,"rowCount":1,"col":0,"colCount":1}},"columns":[{"size":577,"dirty":true},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":false,"dirty":null}],"rowCount":50,"columnCount":11,"activeRow":18,"data":{"dataTable":{"0":{"0":{"value":"Comment","style":{"backColor":"#FFFFE1 ","font":"italic 12px arial"}}},"1":{"0":{"style":{"backColor":"#FFFFE1 ","font":"700 13.3333px arial","wordWrap":true}}},"2":{"0":{"style":{"backColor":"#FFFFE1 "}}},"3":{"0":{"value":"Template for displaying numerical statistics","style":{"autoFormatter":{"customerCultureName":"en-US"}}}},"4":{"0":{"value":"Class options are:","style":{"autoFormatter":{"customerCultureName":"en-US"}}}},"5":{"0":{"value":" - \"positive\" : will be displayed in Green","style":{"autoFormatter":{"customerCultureName":"en-US"}}}},"6":{"0":{"value":" - \"negative\" : will be displayed in Red","style":{"autoFormatter":{"customerCultureName":"en-US"}}}},"8":{"0":{"value":"Modifications to template can be made in the xCache record \"QuickTileTemplate_StatsList\"","style":{"autoFormatter":{"customerCultureName":"en-US"}}}}},"columnDataArray":[{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}}]},"tag":"true|false|update","index":0},"Stat 1":{"name":"Stat 1","selections":{"0":{"row":4,"rowCount":1,"col":0,"colCount":1}},"columns":[{"size":186.99999976158142,"dirty":null},{"size":138.99999976158142,"dirty":null},{"size":156,"dirty":null},{"size":319,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":false,"dirty":null}],"rowCount":50,"columnCount":4,"activeRow":4,"data":{"dataTable":{"0":{"0":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"1":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"2":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","hAlign":0,"vAlign":0,"font":"italic 12px arial","imeMode":1}},"3":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}}},"1":{"0":{"value":"StatValue-1","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"StatLabel-1","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"Class-1","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateControl-1","style":{"backColor":"#F4B084","font":"700 13.3333px arial","wordWrap":true}}},"2":{"0":{"value":"ui","style":{"backColor":"#DDA0DD"}},"1":{"value":"ui","style":{"backColor":"#DDA0DD"}},"2":{"value":"ui","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"imeMode":1}},"3":{"value":"==","style":{"backColor":"#F4B084"}}},"3":{"0":{"value":"'1,576'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"'Total Units'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"''","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateUIControl({StatValue-1},{StatLabel-1},{Class-1})","style":{"autoFormatter":{"customerCultureName":"en-US"}}}},"4":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"5":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"6":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}}},"columnDataArray":[{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}}]},"tag":"true|false|update","index":1},"Stat 2":{"name":"Stat 2","selections":{"0":{"row":4,"rowCount":1,"col":1,"colCount":1}},"columns":[{"size":186.99999976158142,"dirty":null},{"size":138.99999976158142,"dirty":null},{"size":156,"dirty":null},{"size":319,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":false,"dirty":null}],"rowCount":50,"columnCount":4,"activeRow":4,"activeCol":1,"data":{"dataTable":{"0":{"0":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"1":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"2":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","hAlign":0,"vAlign":0,"font":"italic 12px arial","imeMode":1}},"3":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}}},"1":{"0":{"value":"StatValue-2","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"StatLabel-2","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"Class-2","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateControl-2","style":{"backColor":"#F4B084","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}}},"2":{"0":{"value":"ui","style":{"backColor":"#DDA0DD"}},"1":{"value":"ui","style":{"backColor":"#DDA0DD"}},"2":{"value":"ui","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"imeMode":1}},"3":{"value":"==","style":{"backColor":"#F4B084"}}},"3":{"0":{"value":"'$2,345'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"'Total Sales'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"'positive'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateUIControl({StatValue-2},{StatLabel-2},{Class-2})","style":{"autoFormatter":{"customerCultureName":"en-US"}}}},"4":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"5":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"6":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}}},"columnDataArray":[{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}}]},"tag":"true|false|update","index":2},"Stat 3":{"name":"Stat 3","selections":{"0":{"row":4,"rowCount":1,"col":0,"colCount":1}},"columns":[{"size":186.99999976158142,"dirty":null},{"size":138.99999976158142,"dirty":null},{"size":156,"dirty":null},{"size":319,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":false,"dirty":null}],"rowCount":50,"columnCount":4,"activeRow":4,"data":{"dataTable":{"0":{"0":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"1":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"2":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","hAlign":0,"vAlign":0,"font":"italic 12px arial","imeMode":1}},"3":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}}},"1":{"0":{"value":"StatValue-3","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"StatLabel-3","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"Class-3","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateControl-3","style":{"backColor":"#F4B084","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}}},"2":{"0":{"value":"ui","style":{"backColor":"#DDA0DD"}},"1":{"value":"ui","style":{"backColor":"#DDA0DD"}},"2":{"value":"ui","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"imeMode":1}},"3":{"value":"==","style":{"backColor":"#F4B084"}}},"3":{"0":{"value":"'$1,396'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"'Total Costs'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"'negative'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateUIControl({StatValue-3},{StatLabel-3},{Class-3})","style":{"autoFormatter":{"customerCultureName":"en-US"}}}},"4":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"5":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"6":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}}},"columnDataArray":[{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}}]},"tag":"true|false|update","index":3},"Render Tiles":{"name":"Render Tiles","selections":{"0":{"row":3,"rowCount":1,"col":0,"colCount":1}},"columns":[{"size":384,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":false,"dirty":null}],"rowCount":50,"columnCount":9,"activeRow":3,"colHeaderRowInfos":[{"size":20,"dirty":true}],"data":{"dataTable":{"0":{"0":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}},"1":{"value":"Comment","style":{"backColor":"#FFFFE1 ","font":"italic 12px arial"}}},"1":{"0":{"value":"FinalOutput","style":{"backColor":"#F4B084","font":"700 13.3333px arial"}},"1":{"style":{"backColor":"#FFFFE1 ","font":"700 13.3333px arial","wordWrap":true}}},"2":{"0":{"value":"==","style":{"backColor":"#F4B084"}},"1":{"style":{"backColor":"#FFFFE1 "}}},"3":{"0":{"value":"CreateUIControlCollection(CreateUIProperty('xcachetemplate',{{QuickTileTemplate_StatsList}}),{CreateControl-1},{CreateControl-2},{CreateControl-3})","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"autoFormatter":{"customerCultureName":"en-US"}}}}},"columnDataArray":[{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}}]},"tag":"true|false|clientside","index":4},"Global Calculations":{"name":"Global Calculations","columns":[{"size":300,"dirty":null},{"size":400,"dirty":null},{"size":400,"dirty":null}],"rowCount":200,"columnCount":6,"visible":false,"data":{"dataTable":{"0":{"0":{"value":"Calculation Name","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"1":{"value":"Calculation Value","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"2":{"value":"Comment","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}}}}},"index":5},"Global Actions":{"name":"Global Actions","selections":{"0":{"row":1,"rowCount":1,"col":1,"colCount":1}},"columns":[{"size":300,"dirty":null},{"size":400,"dirty":null},{"size":400,"dirty":null}],"rowCount":200,"columnCount":6,"activeRow":1,"activeCol":1,"visible":false,"data":{"dataTable":{"0":{"0":{"value":"Action Name","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"1":{"value":"Action Value","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"2":{"value":"Comment","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}}},"1":{"0":{"style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"autoFormatter":{"customerCultureName":"en-US"}}}}}},"index":6},"Global FetchXml":{"name":"Global FetchXml","columns":[{"size":300,"dirty":null},{"size":400,"dirty":null},{"size":400,"dirty":null}],"rowCount":200,"columnCount":6,"visible":false,"data":{"dataTable":{"0":{"0":{"value":"FetchXml Name","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"1":{"value":"FetchXml Query","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"2":{"value":"Comment","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}}}}},"index":7}}}*/
xCache
Category:
QuickTileTemplate
Base Key:
QuickTileTemplate_StatsList
Value:
<style>
.stats-list {
list-style-type: none;
clear: left;
margin: 0;
padding: 0;
text-align: center;
margin-bottom: 30px;
}
.stats-list .stats-list-positive {
color: #3adb76;
}
.stats-list .stats-list-negative {
color: #cc4b37;
}
.stats-list > li {
display: inline-block;
margin-right: 10px;
padding-right: 10px;
border-right: 1px solid #cacaca;
text-align: center;
font-size: 1.1em;
font-weight: bold;
}
.stats-list > li:last-child {
border: none;
margin: 0;
padding: 0;
}
.stats-list > li .stats-list-label {
display: block;
margin-top: 2px;
font-size: 0.9em;
font-weight: normal;
}
</style>
<ul class="stats-list">
{{#each tiles}}<li{{#if class}} class="stats-list-{{class}}"{{/if}}>
{{statvalue}} <span class="stats-list-label">{{statlabel}}</span>
</li>{{/each}}
</ul>
Notification Badges
Formula logic
MultipleDecisionTable(
DecisionTable(
IfTrue(true,
CreateUIProperty('AlertValue-1', '5'),
CreateUIProperty('IconName-1', 'glyphicon-exclamation-sign'),
CreateUIProperty('LinkURL-1', 'https://google.com'),
SetVar('CreateControl-1', CreateUIControl(GetVar('AlertValue-1'),GetVar('IconName-1'),GetVar('LinkURL-1'))))
, IfTrue(true, GetVar('CreateControl-1', 'NoOp') )
,
'true|false|update|Icon 1') ,
DecisionTable(
IfTrue(true,
CreateUIProperty('AlertValue-2', '12'),
CreateUIProperty('IconName-2', 'glyphicon-envelope'),
CreateUIProperty('LinkURL-2', 'https://google.com'),
SetVar('CreateControl-2', CreateUIControl(GetVar('AlertValue-2'),GetVar('IconName-2'),GetVar('LinkURL-2'))))
, IfTrue(true, GetVar('CreateControl-2', 'NoOp') )
,
'true|false|update|Icon 2') ,
DecisionTable(
IfTrue(true,
CreateUIProperty('AlertValue-3', '1'),
CreateUIProperty('IconName-3', 'glyphicon-wrench'),
CreateUIProperty('LinkURL-3', 'https://google.com'),
SetVar('CreateControl-3', CreateUIControl(GetVar('AlertValue-3'),GetVar('IconName-3'),GetVar('LinkURL-3'))))
, IfTrue(true, GetVar('CreateControl-3', 'NoOp') )
,
'true|false|update|Icon 3') ,
DecisionTable(
IfTrue(true,
SetVar('FinalOutput', CreateUIControlCollection(CreateUIProperty('xcachetemplate',xCacheGetGlobal('QuickTileTemplate_NotificationBadge')),GetVar('CreateControl-1'),GetVar('CreateControl-2'),GetVar('CreateControl-3'))))
, IfTrue(true, GetVar('FinalOutput', 'NoOp') )
,
'true|false|clientside|Render Tiles')
)
/*{"version":"8.40.20151.5","activeSheetIndex":3,"sheetCount":8,"tabStripRatio":0.6949078138718178,"newTabVisible":false,"allowDragDrop":false,"sheets":{"Info exclude":{"name":"Info exclude","selections":{"0":{"row":4,"rowCount":1,"col":0,"colCount":1}},"columns":[{"size":835,"dirty":true},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":false,"dirty":null}],"rowCount":50,"columnCount":11,"activeRow":4,"data":{"dataTable":{"0":{"0":{"value":"Comment","style":{"backColor":"#FFFFE1 ","font":"italic 12px arial"}}},"1":{"0":{"style":{"backColor":"#FFFFE1 ","font":"700 13.3333px arial","wordWrap":true}}},"2":{"0":{"style":{"backColor":"#FFFFE1 "}}},"3":{"0":{"value":"Template for displaying icons with badge notifications","style":{"autoFormatter":{"customerCultureName":"en-US"}}}},"4":{"0":{"value":"Icon name options are Bootstrap 3 Glyphicons e.g. \"glyphicon-envelope\"","style":{"autoFormatter":{"customerCultureName":"en-US"}}}},"5":{"0":{"style":{"autoFormatter":{"customerCultureName":"en-US"}}}},"6":{"0":{"value":"Modifications to template can be made in the xCache record \"QuickTileTemplate_NotificationBadge\"","style":{"autoFormatter":{"customerCultureName":"en-US"}}}},"8":{"0":{"style":{"autoFormatter":{"customerCultureName":"en-US"}}}}},"columnDataArray":[{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}}]},"tag":"true|false|update","index":0},"Icon 1":{"name":"Icon 1","selections":{"0":{"row":3,"rowCount":1,"col":2,"colCount":1}},"columns":[{"size":186.99999976158142,"dirty":null},{"size":138.99999976158142,"dirty":null},{"size":156,"dirty":null},{"size":319,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":false,"dirty":null}],"rowCount":50,"columnCount":4,"activeRow":3,"activeCol":2,"data":{"dataTable":{"0":{"0":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"1":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"2":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","hAlign":0,"vAlign":0,"font":"italic 12px arial","imeMode":1}},"3":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}}},"1":{"0":{"value":"AlertValue-1","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"IconName-1","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"LinkURL-1","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateControl-1","style":{"backColor":"#F4B084","font":"700 13.3333px arial","wordWrap":true}}},"2":{"0":{"value":"ui","style":{"backColor":"#DDA0DD"}},"1":{"value":"ui","style":{"backColor":"#DDA0DD"}},"2":{"value":"ui","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"imeMode":1}},"3":{"value":"==","style":{"backColor":"#F4B084"}}},"3":{"0":{"value":"'5'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"'glyphicon-exclamation-sign'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"'https://google.com'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateUIControl({AlertValue-1},{IconName-1},{LinkURL-1})","style":{"autoFormatter":{"customerCultureName":"en-US"}}}},"4":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"5":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"6":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}}},"columnDataArray":[{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}}]},"tag":"true|false|update","index":1},"Icon 2":{"name":"Icon 2","selections":{"0":{"row":4,"rowCount":1,"col":2,"colCount":1}},"columns":[{"size":186.99999976158142,"dirty":null},{"size":138.99999976158142,"dirty":null},{"size":156,"dirty":null},{"size":319,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":false,"dirty":null}],"rowCount":50,"columnCount":4,"activeRow":4,"activeCol":2,"data":{"dataTable":{"0":{"0":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"1":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"2":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","hAlign":0,"vAlign":0,"font":"italic 12px arial","imeMode":1}},"3":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}}},"1":{"0":{"value":"AlertValue-2","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"IconName-2","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"LinkURL-2","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateControl-2","style":{"backColor":"#F4B084","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}}},"2":{"0":{"value":"ui","style":{"backColor":"#DDA0DD"}},"1":{"value":"ui","style":{"backColor":"#DDA0DD"}},"2":{"value":"ui","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"imeMode":1}},"3":{"value":"==","style":{"backColor":"#F4B084"}}},"3":{"0":{"value":"'12'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"'glyphicon-envelope'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"'https://google.com'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateUIControl({AlertValue-2},{IconName-2},{LinkURL-2})","style":{"autoFormatter":{"customerCultureName":"en-US"}}}},"4":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"5":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"6":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}}},"columnDataArray":[{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}}]},"tag":"true|false|update","index":2},"Icon 3":{"name":"Icon 3","selections":{"0":{"row":4,"rowCount":1,"col":2,"colCount":1}},"columns":[{"size":186.99999976158142,"dirty":null},{"size":138.99999976158142,"dirty":null},{"size":156,"dirty":null},{"size":319,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":false,"dirty":null}],"rowCount":50,"columnCount":4,"activeRow":4,"activeCol":2,"data":{"dataTable":{"0":{"0":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"1":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"2":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","hAlign":0,"vAlign":0,"font":"italic 12px arial","imeMode":1}},"3":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}}},"1":{"0":{"value":"AlertValue-3","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"IconName-3","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"LinkURL-3","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateControl-3","style":{"backColor":"#F4B084","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}}},"2":{"0":{"value":"ui","style":{"backColor":"#DDA0DD"}},"1":{"value":"ui","style":{"backColor":"#DDA0DD"}},"2":{"value":"ui","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"imeMode":1}},"3":{"value":"==","style":{"backColor":"#F4B084"}}},"3":{"0":{"value":"'1'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"'glyphicon-wrench'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"'https://google.com'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateUIControl({AlertValue-3},{IconName-3},{LinkURL-3})","style":{"autoFormatter":{"customerCultureName":"en-US"}}}},"4":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"5":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"6":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}}},"columnDataArray":[{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}}]},"tag":"true|false|update","index":3},"Render Tiles":{"name":"Render Tiles","selections":{"0":{"row":3,"rowCount":1,"col":0,"colCount":1}},"columns":[{"size":384,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":false,"dirty":null}],"rowCount":50,"columnCount":9,"activeRow":3,"colHeaderRowInfos":[{"size":20,"dirty":true}],"data":{"dataTable":{"0":{"0":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}},"1":{"value":"Comment","style":{"backColor":"#FFFFE1 ","font":"italic 12px arial"}}},"1":{"0":{"value":"FinalOutput","style":{"backColor":"#F4B084","font":"700 13.3333px arial"}},"1":{"style":{"backColor":"#FFFFE1 ","font":"700 13.3333px arial","wordWrap":true}}},"2":{"0":{"value":"==","style":{"backColor":"#F4B084"}},"1":{"style":{"backColor":"#FFFFE1 "}}},"3":{"0":{"value":"CreateUIControlCollection(CreateUIProperty('xcachetemplate',{{QuickTileTemplate_NotificationBadge}}),{CreateControl-1},{CreateControl-2},{CreateControl-3})","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"autoFormatter":{"customerCultureName":"en-US"}}}}},"columnDataArray":[{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}}]},"tag":"true|false|clientside","index":4},"Global Calculations":{"name":"Global Calculations","columns":[{"size":300,"dirty":null},{"size":400,"dirty":null},{"size":400,"dirty":null}],"rowCount":200,"columnCount":6,"visible":false,"data":{"dataTable":{"0":{"0":{"value":"Calculation Name","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"1":{"value":"Calculation Value","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"2":{"value":"Comment","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}}}}},"index":5},"Global Actions":{"name":"Global Actions","selections":{"0":{"row":1,"rowCount":1,"col":1,"colCount":1}},"columns":[{"size":300,"dirty":null},{"size":400,"dirty":null},{"size":400,"dirty":null}],"rowCount":200,"columnCount":6,"activeRow":1,"activeCol":1,"visible":false,"data":{"dataTable":{"0":{"0":{"value":"Action Name","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"1":{"value":"Action Value","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"2":{"value":"Comment","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}}},"1":{"0":{"style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"autoFormatter":{"customerCultureName":"en-US"}}}}}},"index":6},"Global FetchXml":{"name":"Global FetchXml","columns":[{"size":300,"dirty":null},{"size":400,"dirty":null},{"size":400,"dirty":null}],"rowCount":200,"columnCount":6,"visible":false,"data":{"dataTable":{"0":{"0":{"value":"FetchXml Name","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"1":{"value":"FetchXml Query","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"2":{"value":"Comment","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}}}}},"index":7}}}*/
xCache
Category:
QuickTileTemplate
Base Key:
QuickTileTemplate_NotificationBadge
Value:
<style>
.n52-button-badge {
background-color: #1779ba;
text-decoration: none;
padding: 0.9rem;
position: relative;
display: inline-block;
border-radius: 0.4rem;
transition: all ease 0.4s;
margin-right: 10px;
}
.n52-button-badge:hover {
box-shadow: 0 1px 5px rgba(0, 0, 0, 0.1);
}
.n52-badge {
position: absolute;
top: -10px;
right: -10px;
font-size: .8em;
}
.n52-badge.n52-alert {
background: #cc4b37;
color: #fefefe;
display: inline-block;
min-width: 2.1em;
padding: 0.3em;
border-radius: 50%;
text-align: center;
}
.glyphicon {
color: white;
font-size: 16px;
}
</style>
<div style="padding: 15px; text-align: center;">
{{#each tiles}}
<a href="{{linkurl}}" target="_top" class="n52-button-badge">
<span class="glyphicon {{iconname}}"></span>
<span class="n52-badge n52-alert">{{alertvalue}}</span>
</a>
{{/each}}
</div>
Custom Tables
Formula logic
MultipleDecisionTable(
DecisionTable(
IfTrue(true,
SetVar('Heading Name', 'Heading One'),
SetVar('Column CSS Class', ''),
SetVar('Headings JSON', SetVarAppendJArray('headings',
CreateJObject(
CreateJProperty('value', GetVar('Heading Name')),
CreateJProperty('class', GetVar('Column CSS Class'))
)
))) ,
IfTrue(true,
SetVar('Heading Name', 'Heading Two'),
SetVar('Column CSS Class', ''),
SetVar('Headings JSON', SetVarAppendJArray('headings',
CreateJObject(
CreateJProperty('value', GetVar('Heading Name')),
CreateJProperty('class', GetVar('Column CSS Class'))
)
))) ,
IfTrue(true,
SetVar('Heading Name', 'Heading Three'),
SetVar('Column CSS Class', ''),
SetVar('Headings JSON', SetVarAppendJArray('headings',
CreateJObject(
CreateJProperty('value', GetVar('Heading Name')),
CreateJProperty('class', GetVar('Column CSS Class'))
)
)))
, IfTrue(true, GetVar('Headings JSON', 'NoOp') )
,
'false|false|update|Table Headings') ,
DecisionTable(
IfTrue(true,
SetVar('Cell Value 1', 'Column One Row One'),
SetVar('Cell CSS Class 1', ''),
SetVar('Cell Value 2', 'Column Two Row One'),
SetVar('Cell CSS Class 2', ''),
SetVar('Cell Value 3', 'Column Three Row One'),
SetVar('Cell CSS Class 3', ''),
SetVar('Row CSS Class', 'success'),
SetVar('Rows JSON', SetVarAppendJArray('rowsarray',
CreateJObject(
CreateJProperty('class',GetVar('Row CSS Class')),
CreateJProperty('cells',
CreateJArray(
CreateJObject(
CreateJProperty('value',GetVar('Cell Value 1')),
CreateJProperty('class',GetVar('Cell CSS Class 1'))
),
CreateJObject(
CreateJProperty('value',GetVar('Cell Value 2')),
CreateJProperty('class',GetVar('Cell CSS Class 2'))
),
CreateJObject(
CreateJProperty('value',GetVar('Cell Value 3')),
CreateJProperty('class',GetVar('Cell CSS Class 3'))
)
)
)
)
))) ,
IfTrue(true,
SetVar('Cell Value 1', 'Column One Row Two'),
SetVar('Cell CSS Class 1', 'alert-danger'),
SetVar('Cell Value 2', 'Column Two Row Two'),
SetVar('Cell CSS Class 2', ''),
SetVar('Cell Value 3', 'Column Three Row Two'),
SetVar('Cell CSS Class 3', ''),
SetVar('Row CSS Class', ''),
SetVar('Rows JSON', SetVarAppendJArray('rowsarray',
CreateJObject(
CreateJProperty('class',GetVar('Row CSS Class')),
CreateJProperty('cells',
CreateJArray(
CreateJObject(
CreateJProperty('value',GetVar('Cell Value 1')),
CreateJProperty('class',GetVar('Cell CSS Class 1'))
),
CreateJObject(
CreateJProperty('value',GetVar('Cell Value 2')),
CreateJProperty('class',GetVar('Cell CSS Class 2'))
),
CreateJObject(
CreateJProperty('value',GetVar('Cell Value 3')),
CreateJProperty('class',GetVar('Cell CSS Class 3'))
)
)
)
)
))) ,
IfTrue(true,
SetVar('Cell Value 1', 'Column One Row Three'),
SetVar('Cell CSS Class 1', ''),
SetVar('Cell Value 2', 'Column Two Row Three'),
SetVar('Cell CSS Class 2', ''),
SetVar('Cell Value 3', 'Column Three Row Three'),
SetVar('Cell CSS Class 3', ''),
SetVar('Row CSS Class', ''),
SetVar('Rows JSON', SetVarAppendJArray('rowsarray',
CreateJObject(
CreateJProperty('class',GetVar('Row CSS Class')),
CreateJProperty('cells',
CreateJArray(
CreateJObject(
CreateJProperty('value',GetVar('Cell Value 1')),
CreateJProperty('class',GetVar('Cell CSS Class 1'))
),
CreateJObject(
CreateJProperty('value',GetVar('Cell Value 2')),
CreateJProperty('class',GetVar('Cell CSS Class 2'))
),
CreateJObject(
CreateJProperty('value',GetVar('Cell Value 3')),
CreateJProperty('class',GetVar('Cell CSS Class 3'))
)
)
)
)
)))
, IfTrue(true, GetVar('Rows JSON', 'NoOp') )
,
'false|false|update|Table Rows') ,
DecisionTable(
IfTrue(true,
CreateUIProperty('TableClass-1', 'table table-striped'),
CreateUIProperty('Headings-1', GetVar('headings')),
CreateUIProperty('Rows-1', GetVar('rowsarray')),
SetVar('CreateControl-1', CreateUIControl(GetVar('TableClass-1'),GetVar('Headings-1'),GetVar('Rows-1'))))
, IfTrue(true, GetVar('CreateControl-1', 'NoOp') )
,
'true|false|update|Table Details') ,
DecisionTable(
IfTrue(true,
SetVar('FinalOutput', CreateUIControlCollection(CreateUIProperty('xcachetemplate',xCacheGetGlobal('QuickTileTemplate_Table')),GetVar('CreateControl-1'))))
, IfTrue(true, GetVar('FinalOutput', 'NoOp') )
,
'true|false|clientside|Render Tiles')
)
/*{"version":"8.40.20151.5","sheetCount":7,"newTabVisible":false,"allowDragDrop":false,"sheets":{"Table Headings":{"name":"Table Headings","selections":{"0":{"row":3,"rowCount":1,"col":2,"colCount":1}},"columns":[{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":false,"dirty":null}],"rowCount":50,"columnCount":11,"activeRow":3,"activeCol":2,"data":{"dataTable":{"0":{"0":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}},"1":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}},"2":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}}},"1":{"0":{"value":"Heading Name","style":{"backColor":"#F4B084","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"Column CSS Class","style":{"backColor":"#F4B084","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"Headings JSON","style":{"backColor":"#F4B084","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}}},"2":{"0":{"value":"==","style":{"backColor":"#F4B084"}},"1":{"value":"==","style":{"backColor":"#F4B084"}},"2":{"value":"==","style":{"backColor":"#F4B084"}}},"3":{"0":{"value":"'Heading One'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"''","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"SetVarAppendJArray('headings', \n CreateJObject(\n CreateJProperty('value', {Heading Name}),\n CreateJProperty('class', {Column CSS Class})\n )\n)"}},"4":{"0":{"value":"'Heading Two'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"''","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"SetVarAppendJArray('headings', \n CreateJObject(\n CreateJProperty('value', {Heading Name}),\n CreateJProperty('class', {Column CSS Class})\n )\n)","style":{"hAlign":0,"vAlign":0,"imeMode":1}}},"5":{"0":{"value":"'Heading Three'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"''","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"SetVarAppendJArray('headings', \n CreateJObject(\n CreateJProperty('value', {Heading Name}),\n CreateJProperty('class', {Column CSS Class})\n )\n)","style":{"hAlign":0,"vAlign":0,"imeMode":1}}}},"columnDataArray":[{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}}]},"tag":"false|false|update","index":0},"Table Rows":{"name":"Table Rows","selections":{"0":{"row":6,"rowCount":1,"col":4,"colCount":1}},"columns":[{"size":163,"dirty":true},{"size":120,"dirty":null},{"size":160,"dirty":true},{"size":120,"dirty":null},{"size":157,"dirty":true},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":false,"dirty":null}],"rowCount":50,"columnCount":11,"activeRow":6,"activeCol":4,"data":{"dataTable":{"0":{"0":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}},"1":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}},"2":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}},"3":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}},"4":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}},"5":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}},"6":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}},"7":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}}},"1":{"0":{"value":"Cell Value 1","style":{"backColor":"#F4B084","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"Cell CSS Class 1","style":{"backColor":"#F4B084","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"Cell Value 2","style":{"backColor":"#F4B084","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"Cell CSS Class 2","style":{"backColor":"#F4B084","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"Cell Value 3","style":{"backColor":"#F4B084","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"value":"Cell CSS Class 3","style":{"backColor":"#F4B084","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"6":{"value":"Row CSS Class","style":{"backColor":"#F4B084","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"7":{"value":"Rows JSON","style":{"backColor":"#F4B084","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}}},"2":{"0":{"value":"==","style":{"backColor":"#F4B084"}},"1":{"value":"==","style":{"backColor":"#F4B084"}},"2":{"value":"==","style":{"backColor":"#F4B084"}},"3":{"value":"==","style":{"backColor":"#F4B084"}},"4":{"value":"==","style":{"backColor":"#F4B084"}},"5":{"value":"==","style":{"backColor":"#F4B084"}},"6":{"value":"==","style":{"backColor":"#F4B084"}},"7":{"value":"==","style":{"backColor":"#F4B084"}}},"3":{"0":{"value":"'Column One Row One'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"''","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"'Column Two Row One'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"''","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"'Column Three Row One'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"value":"''","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"6":{"value":"'success'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"7":{"value":"SetVarAppendJArray('rowsarray', \n CreateJObject(\n CreateJProperty('class',{Row CSS Class}),\n CreateJProperty('cells',\n CreateJArray(\n CreateJObject(\n CreateJProperty('value',{Cell Value 1}),\n CreateJProperty('class',{Cell CSS Class 1})\n ),\n CreateJObject(\n CreateJProperty('value',{Cell Value 2}),\n CreateJProperty('class',{Cell CSS Class 2})\n ),\n CreateJObject(\n CreateJProperty('value',{Cell Value 3}),\n CreateJProperty('class',{Cell CSS Class 3})\n )\n )\n )\n )\n)","style":{"autoFormatter":{"customerCultureName":"en-US"}}}},"4":{"0":{"value":"'Column One Row Two'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"'alert-danger'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"'Column Two Row Two'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"''","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"'Column Three Row Two'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"value":"''","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"6":{"value":"''","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"7":{"value":"SetVarAppendJArray('rowsarray', \n CreateJObject(\n CreateJProperty('class',{Row CSS Class}),\n CreateJProperty('cells',\n CreateJArray(\n CreateJObject(\n CreateJProperty('value',{Cell Value 1}),\n CreateJProperty('class',{Cell CSS Class 1})\n ),\n CreateJObject(\n CreateJProperty('value',{Cell Value 2}),\n CreateJProperty('class',{Cell CSS Class 2})\n ),\n CreateJObject(\n CreateJProperty('value',{Cell Value 3}),\n CreateJProperty('class',{Cell CSS Class 3})\n )\n )\n )\n )\n)","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"5":{"0":{"value":"'Column One Row Three'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"''","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"'Column Two Row Three'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"''","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"'Column Three Row Three'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"value":"''","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"6":{"value":"''","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"7":{"value":"SetVarAppendJArray('rowsarray', \n CreateJObject(\n CreateJProperty('class',{Row CSS Class}),\n CreateJProperty('cells',\n CreateJArray(\n CreateJObject(\n CreateJProperty('value',{Cell Value 1}),\n CreateJProperty('class',{Cell CSS Class 1})\n ),\n CreateJObject(\n CreateJProperty('value',{Cell Value 2}),\n CreateJProperty('class',{Cell CSS Class 2})\n ),\n CreateJObject(\n CreateJProperty('value',{Cell Value 3}),\n CreateJProperty('class',{Cell CSS Class 3})\n )\n )\n )\n )\n)","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}}},"columnDataArray":[{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}}]},"tag":"false|false|update","index":1},"Table Details":{"name":"Table Details","selections":{"0":{"row":4,"rowCount":1,"col":2,"colCount":1}},"columns":[{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":319,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":false,"dirty":null}],"rowCount":50,"columnCount":4,"activeRow":4,"activeCol":2,"data":{"dataTable":{"0":{"0":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"1":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"2":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","hAlign":0,"vAlign":0,"font":"italic 12px arial","imeMode":1}},"3":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}}},"1":{"0":{"value":"TableClass-1","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"Headings-1","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"Rows-1","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateControl-1","style":{"backColor":"#F4B084","font":"700 13.3333px arial","wordWrap":true}}},"2":{"0":{"value":"ui","style":{"backColor":"#DDA0DD"}},"1":{"value":"ui","style":{"backColor":"#DDA0DD"}},"2":{"value":"ui","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"imeMode":1}},"3":{"value":"==","style":{"backColor":"#F4B084"}}},"3":{"0":{"value":"'table table-striped'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"GetVar('headings')","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"GetVar('rowsarray')","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"CreateUIControl({TableClass-1},{Headings-1},{Rows-1})","style":{"autoFormatter":{"customerCultureName":"en-US"}}}},"4":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"5":{"0":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}}},"columnDataArray":[{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}}]},"tag":"true|false|update","index":2},"Render Tiles":{"name":"Render Tiles","selections":{"0":{"row":4,"rowCount":1,"col":0,"colCount":1}},"columns":[{"size":384,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":false,"dirty":null}],"rowCount":50,"columnCount":9,"activeRow":4,"colHeaderRowInfos":[{"size":20,"dirty":true}],"data":{"dataTable":{"0":{"0":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}},"1":{"value":"Comment","style":{"backColor":"#FFFFE1 ","font":"italic 12px arial"}}},"1":{"0":{"value":"FinalOutput","style":{"backColor":"#F4B084","font":"700 13.3333px arial"}},"1":{"style":{"backColor":"#FFFFE1 ","font":"700 13.3333px arial","wordWrap":true}}},"2":{"0":{"value":"==","style":{"backColor":"#F4B084"}},"1":{"style":{"backColor":"#FFFFE1 "}}},"3":{"0":{"value":"CreateUIControlCollection(CreateUIProperty('xcachetemplate',{{QuickTileTemplate_Table}}),{CreateControl-1})","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"autoFormatter":{"customerCultureName":"en-US"}}}}},"columnDataArray":[{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}}]},"tag":"true|false|clientside","index":3},"Global Calculations":{"name":"Global Calculations","columns":[{"size":300,"dirty":null},{"size":400,"dirty":null},{"size":400,"dirty":null}],"rowCount":200,"columnCount":6,"visible":false,"data":{"dataTable":{"0":{"0":{"value":"Calculation Name","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"1":{"value":"Calculation Value","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"2":{"value":"Comment","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}}}}},"index":4},"Global Actions":{"name":"Global Actions","selections":{"0":{"row":1,"rowCount":1,"col":1,"colCount":1}},"columns":[{"size":300,"dirty":null},{"size":400,"dirty":null},{"size":400,"dirty":null}],"rowCount":200,"columnCount":6,"activeRow":1,"activeCol":1,"visible":false,"data":{"dataTable":{"0":{"0":{"value":"Action Name","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"1":{"value":"Action Value","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"2":{"value":"Comment","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}}},"1":{"0":{"style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"autoFormatter":{"customerCultureName":"en-US"}}}}}},"index":5},"Global FetchXml":{"name":"Global FetchXml","columns":[{"size":300,"dirty":null},{"size":400,"dirty":null},{"size":400,"dirty":null}],"rowCount":200,"columnCount":6,"visible":false,"data":{"dataTable":{"0":{"0":{"value":"FetchXml Name","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"1":{"value":"FetchXml Query","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"2":{"value":"Comment","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}}}}},"index":6}}}*/
xCache
Category:
QuickTileTemplate
Base Key:
QuickTileTemplate_Table
Value:
<style>table {font-size:100%}</style>
{{#each tiles}}
<table class="{{tableclass}}">
{{#if headings}}<thead>
<tr>
{{#each headings}}
<th class="{{class}}">{{{value}}}</th>
{{/each}}
</tr>
</thead>{{/if}}
<tbody>
{{#each rows}}
<tr class="{{class}}">
{{#each cells}}
<td class="{{class}}">{{{value}}}</td>
{{/each}}
</tr>
{{/each}}
</tbody>
</table>
{{/each}}
Custom Columns
Formula logic
MultipleDecisionTable(
DecisionTable(
SetVar('Test', CreateJObject(
CreateJProperty('coverageName', 'Dental - Gold'),
CreateJProperty('exclusionInclusions',
CreateJArray(
CreateJObject(
CreateJProperty('exclusionInclusionLOB', '1 Included'),
CreateJProperty('excludeInclude', 'Include')
),
CreateJObject(
CreateJProperty('exclusionInclusionLOB', '2 Included'),
CreateJProperty('excludeInclude', 'Include')
),
CreateJObject(
CreateJProperty('exclusionInclusionLOB', '3 Included'),
CreateJProperty('excludeInclude', 'Include')
),
CreateJObject(
CreateJProperty('exclusionInclusionLOB', '4 Excluded'),
CreateJProperty('excludeInclude', 'Exclude')
),
CreateJObject(
CreateJProperty('exclusionInclusionLOB', '5 Excluded'),
CreateJProperty('excludeInclude', 'Exclude')
)
)
)
)
),
IfTrue(true,
CreateUIProperty('Header-1', 'Header-1'),
CreateUIProperty('HeaderBkg-1', '#073B4C'),
CreateUIProperty('Body-1', JObjectParse(GetVar('Test'))),
CreateUIProperty('BodyBkg-1', '#E3F6FC'),
CreateUIProperty('FooterRaw-1', '<button>Click Me!</button>'),
CreateUIProperty('FooterBkg-1', '#0C6583'),
SetVar('CreateControl-1', CreateUIControl(GetVar('Header-1'),GetVar('HeaderBkg-1'),GetVar('Body-1'),GetVar('BodyBkg-1'),GetVar('FooterRaw-1'),GetVar('FooterBkg-1'))))
, IfTrue(true, GetVar('CreateControl-1', 'NoOp') )
,
'true|false|update|Tile 1') ,
DecisionTable(
SetVar('Test', CreateJObject(
CreateJProperty('coverageName', 'Dental - Gold'),
CreateJProperty('exclusionInclusions',
CreateJArray(
CreateJObject(
CreateJProperty('exclusionInclusionLOB', '1 Included'),
CreateJProperty('excludeInclude', 'Include')
),
CreateJObject(
CreateJProperty('exclusionInclusionLOB', '2 Excluded'),
CreateJProperty('excludeInclude', 'Exclude')
)
)
)
)
),
IfTrue(true,
CreateUIProperty('Header-2', 'Header-2'),
CreateUIProperty('HeaderBkg-2', '#118AB2'),
CreateUIProperty('Body-2', JObjectParse(GetVar('Test'))),
CreateUIProperty('BodyBkg-2', '#EAF8FD'),
CreateUIProperty('FooterRaw-2', '<button>Click Me!</button>'),
CreateUIProperty('FooterBkg-2', '#1299C6'),
SetVar('CreateControl-2', CreateUIControl(GetVar('Header-2'),GetVar('HeaderBkg-2'),GetVar('Body-2'),GetVar('BodyBkg-2'),GetVar('FooterRaw-2'),GetVar('FooterBkg-2'))))
, IfTrue(true, GetVar('CreateControl-2', 'NoOp') )
,
'true|false|update|Tile 2') ,
DecisionTable(
SetVar('Test', CreateJObject(
CreateJProperty('coverageName', 'Dental - Gold'),
CreateJProperty('exclusionInclusions',
CreateJArray(
CreateJObject(
CreateJProperty('exclusionInclusionLOB', '1 Included'),
CreateJProperty('excludeInclude', 'Include')
),
CreateJObject(
CreateJProperty('exclusionInclusionLOB', '2 Excluded'),
CreateJProperty('excludeInclude', 'Exclude')
)
)
)
)
),
IfTrue(true,
CreateUIProperty('Header-3', 'Header-3'),
CreateUIProperty('HeaderBkg-3', '#06D6A0'),
CreateUIProperty('Body-3', JObjectParse(GetVar('Test'))),
CreateUIProperty('BodyBkg-3', '#EBFEF9'),
CreateUIProperty('FooterRaw-3', '<button>Click Me!</button>'),
CreateUIProperty('FooterBkg-3', '#06EAAD'),
SetVar('CreateControl-3', CreateUIControl(GetVar('Header-3'),GetVar('HeaderBkg-3'),GetVar('Body-3'),GetVar('BodyBkg-3'),GetVar('FooterRaw-3'),GetVar('FooterBkg-3'))))
, IfTrue(true, GetVar('CreateControl-3', 'NoOp') )
,
'true|false|update|Tile 3') ,
DecisionTable(
SetVar('Test', CreateJObject(
CreateJProperty('coverageName', 'Dental - Gold'),
CreateJProperty('exclusionInclusions',
CreateJArray(
CreateJObject(
CreateJProperty('exclusionInclusionLOB', '1 Included'),
CreateJProperty('excludeInclude', 'Include')
),
CreateJObject(
CreateJProperty('exclusionInclusionLOB', '2 Excluded'),
CreateJProperty('excludeInclude', 'Exclude')
)
)
)
)
),
IfTrue(true,
CreateUIProperty('Header-4', 'Header-4'),
CreateUIProperty('HeaderBkg-4', '#FFD166'),
CreateUIProperty('Body-4', JObjectParse(GetVar('Test'))),
CreateUIProperty('BodyBkg-4', '#FFFCF4'),
CreateUIProperty('FooterRaw-4', '<button>Click Me!</button>'),
CreateUIProperty('FooterBkg-4', '#FFD471'),
SetVar('CreateControl-4', CreateUIControl(GetVar('Header-4'),GetVar('HeaderBkg-4'),GetVar('Body-4'),GetVar('BodyBkg-4'),GetVar('FooterRaw-4'),GetVar('FooterBkg-4'))))
, IfTrue(true, GetVar('CreateControl-4', 'NoOp') )
,
'true|false|update|Tile 4') ,
DecisionTable(
IfTrue(true,
SetVar('FinalOutput', CreateUIControlCollection(CreateUIProperty('xcachetemplate',xCacheGetGlobal('QuickTileTemplate_Grid')),GetVar('CreateControl-1'),GetVar('CreateControl-2'),GetVar('CreateControl-3'),GetVar('CreateControl-4'))))
,
'true|false|clientside|Render Tiles')
)
/*{"version":"8.40.20151.5","activeSheetIndex":4,"sheetCount":8,"newTabVisible":false,"allowDragDrop":false,"sheets":{"Tile 1":{"name":"Tile 1","selections":{"0":{"row":3,"rowCount":1,"col":0,"colCount":1}},"columns":[{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":true,"dirty":null}],"rowCount":50,"columnCount":8,"activeRow":3,"data":{"dataTable":{"0":{"0":{"value":"Calc-Table","style":{"backColor":"#F4B084","foreColor":"Black","hAlign":0,"vAlign":0,"font":"italic 12px arial","imeMode":1}},"1":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"2":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"3":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"4":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"5":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"6":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"7":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}}},"1":{"0":{"value":"Test","style":{"backColor":"#F4B084","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"Header-1","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"HeaderBkg-1","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"Body-1","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"BodyBkg-1","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"value":"FooterRaw-1","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"6":{"value":"FooterBkg-1","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"7":{"value":"CreateControl-1","style":{"backColor":"#F4B084","font":"700 13.3333px arial","wordWrap":true}}},"2":{"0":{"value":"===","style":{"backColor":"#F4B084"}},"1":{"value":"ui","style":{"backColor":"#DDA0DD"}},"2":{"value":"ui","style":{"backColor":"#DDA0DD"}},"3":{"value":"ui","style":{"backColor":"#DDA0DD"}},"4":{"value":"ui","style":{"backColor":"#DDA0DD"}},"5":{"value":"ui","style":{"backColor":"#DDA0DD"}},"6":{"value":"ui","style":{"backColor":"#DDA0DD"}},"7":{"value":"==","style":{"backColor":"#F4B084"}}},"3":{"0":{"value":"CreateJObject(\n CreateJProperty('coverageName', 'Dental - Gold'), \n CreateJProperty('exclusionInclusions',\n CreateJArray(\n CreateJObject(\n CreateJProperty('exclusionInclusionLOB', '1 Included'),\n CreateJProperty('excludeInclude', 'Include')\n ),\n CreateJObject(\n CreateJProperty('exclusionInclusionLOB', '2 Included'),\n CreateJProperty('excludeInclude', 'Include')\n ),\n CreateJObject(\n CreateJProperty('exclusionInclusionLOB', '3 Included'),\n CreateJProperty('excludeInclude', 'Include')\n ),\n CreateJObject(\n CreateJProperty('exclusionInclusionLOB', '4 Excluded'),\n CreateJProperty('excludeInclude', 'Exclude')\n ),\n CreateJObject(\n CreateJProperty('exclusionInclusionLOB', '5 Excluded'),\n CreateJProperty('excludeInclude', 'Exclude')\n )\n ) \n )\n)\n","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"'Header-1'"},"2":{"value":"'#073B4C'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"JObjectParse({Test})","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"'#E3F6FC'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"value":"'<button>Click Me!</button>'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"6":{"value":"'#0C6583'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"7":{"value":"CreateUIControl({Header-1},{HeaderBkg-1},{Body-1},{BodyBkg-1},{FooterRaw-1},{FooterBkg-1})","style":{"autoFormatter":{"customerCultureName":"en-US"}}}}},"columnDataArray":[{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}}]},"tag":"true|false|update","index":0},"Tile 2":{"name":"Tile 2","selections":{"0":{"row":3,"rowCount":1,"col":0,"colCount":1}},"columns":[{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":true,"dirty":null}],"rowCount":50,"columnCount":8,"activeRow":3,"data":{"dataTable":{"0":{"0":{"value":"Calc-Table","style":{"backColor":"#F4B084","foreColor":"Black","hAlign":0,"vAlign":0,"font":"italic 12px arial","imeMode":1}},"1":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"2":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"3":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"4":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"5":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"6":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"7":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}}},"1":{"0":{"value":"Test","style":{"backColor":"#F4B084","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"Header-2","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"HeaderBkg-2","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"Body-2","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"BodyBkg-2","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"value":"FooterRaw-2","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"6":{"value":"FooterBkg-2","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"7":{"value":"CreateControl-2","style":{"backColor":"#F4B084","font":"700 13.3333px arial","wordWrap":true}}},"2":{"0":{"value":"===","style":{"backColor":"#F4B084"}},"1":{"value":"ui","style":{"backColor":"#DDA0DD"}},"2":{"value":"ui","style":{"backColor":"#DDA0DD"}},"3":{"value":"ui","style":{"backColor":"#DDA0DD"}},"4":{"value":"ui","style":{"backColor":"#DDA0DD"}},"5":{"value":"ui","style":{"backColor":"#DDA0DD"}},"6":{"value":"ui","style":{"backColor":"#DDA0DD"}},"7":{"value":"==","style":{"backColor":"#F4B084"}}},"3":{"0":{"value":"CreateJObject(\n CreateJProperty('coverageName', 'Dental - Gold'), \n CreateJProperty('exclusionInclusions',\n CreateJArray(\n CreateJObject(\n CreateJProperty('exclusionInclusionLOB', '1 Included'),\n CreateJProperty('excludeInclude', 'Include')\n ),\n CreateJObject(\n CreateJProperty('exclusionInclusionLOB', '2 Excluded'),\n CreateJProperty('excludeInclude', 'Exclude')\n )\n ) \n )\n)\n","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"'Header-2'"},"2":{"value":"'#118AB2'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"JObjectParse({Test})","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"'#EAF8FD'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"value":"'<button>Click Me!</button>'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"6":{"value":"'#1299C6'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"7":{"value":"CreateUIControl({Header-2},{HeaderBkg-2},{Body-2},{BodyBkg-2},{FooterRaw-2},{FooterBkg-2})","style":{"autoFormatter":{"customerCultureName":"en-US"}}}}},"columnDataArray":[{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}}]},"tag":"true|false|update","index":1},"Tile 3":{"name":"Tile 3","selections":{"0":{"row":3,"rowCount":1,"col":0,"colCount":1}},"columns":[{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":true,"dirty":null}],"rowCount":50,"columnCount":8,"activeRow":3,"data":{"dataTable":{"0":{"0":{"value":"Calc-Table","style":{"backColor":"#F4B084","foreColor":"Black","hAlign":0,"vAlign":0,"font":"italic 12px arial","imeMode":1}},"1":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"2":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"3":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"4":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"5":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"6":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"7":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}}},"1":{"0":{"value":"Test","style":{"backColor":"#F4B084","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"Header-3","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"HeaderBkg-3","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"Body-3","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"BodyBkg-3","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"value":"FooterRaw-3","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"6":{"value":"FooterBkg-3","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"7":{"value":"CreateControl-3","style":{"backColor":"#F4B084","font":"700 13.3333px arial","wordWrap":true}}},"2":{"0":{"value":"===","style":{"backColor":"#F4B084"}},"1":{"value":"ui","style":{"backColor":"#DDA0DD"}},"2":{"value":"ui","style":{"backColor":"#DDA0DD"}},"3":{"value":"ui","style":{"backColor":"#DDA0DD"}},"4":{"value":"ui","style":{"backColor":"#DDA0DD"}},"5":{"value":"ui","style":{"backColor":"#DDA0DD"}},"6":{"value":"ui","style":{"backColor":"#DDA0DD"}},"7":{"value":"==","style":{"backColor":"#F4B084"}}},"3":{"0":{"value":"CreateJObject(\n CreateJProperty('coverageName', 'Dental - Gold'), \n CreateJProperty('exclusionInclusions',\n CreateJArray(\n CreateJObject(\n CreateJProperty('exclusionInclusionLOB', '1 Included'),\n CreateJProperty('excludeInclude', 'Include')\n ),\n CreateJObject(\n CreateJProperty('exclusionInclusionLOB', '2 Excluded'),\n CreateJProperty('excludeInclude', 'Exclude')\n )\n ) \n )\n)\n","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"'Header-3'"},"2":{"value":"'#06D6A0'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"JObjectParse({Test})","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"'#EBFEF9'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"value":"'<button>Click Me!</button>'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"6":{"value":"'#06EAAD'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"7":{"value":"CreateUIControl({Header-3},{HeaderBkg-3},{Body-3},{BodyBkg-3},{FooterRaw-3},{FooterBkg-3})","style":{"autoFormatter":{"customerCultureName":"en-US"}}}}},"columnDataArray":[{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}}]},"tag":"true|false|update","index":2},"Tile 4":{"name":"Tile 4","columns":[{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":true,"dirty":null}],"rowCount":50,"columnCount":8,"data":{"dataTable":{"0":{"0":{"value":"Calc-Table","style":{"backColor":"#F4B084","foreColor":"Black","hAlign":0,"vAlign":0,"font":"italic 12px arial","imeMode":1}},"1":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"2":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"3":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"4":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"5":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"6":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"7":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}}},"1":{"0":{"value":"Test","style":{"backColor":"#F4B084","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"Header-4","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"HeaderBkg-4","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"Body-4","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"BodyBkg-4","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"value":"FooterRaw-4","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"6":{"value":"FooterBkg-4","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"7":{"value":"CreateControl-4","style":{"backColor":"#F4B084","font":"700 13.3333px arial","wordWrap":true}}},"2":{"0":{"value":"===","style":{"backColor":"#F4B084"}},"1":{"value":"ui","style":{"backColor":"#DDA0DD"}},"2":{"value":"ui","style":{"backColor":"#DDA0DD"}},"3":{"value":"ui","style":{"backColor":"#DDA0DD"}},"4":{"value":"ui","style":{"backColor":"#DDA0DD"}},"5":{"value":"ui","style":{"backColor":"#DDA0DD"}},"6":{"value":"ui","style":{"backColor":"#DDA0DD"}},"7":{"value":"==","style":{"backColor":"#F4B084"}}},"3":{"0":{"value":"CreateJObject(\n CreateJProperty('coverageName', 'Dental - Gold'), \n CreateJProperty('exclusionInclusions',\n CreateJArray(\n CreateJObject(\n CreateJProperty('exclusionInclusionLOB', '1 Included'),\n CreateJProperty('excludeInclude', 'Include')\n ),\n CreateJObject(\n CreateJProperty('exclusionInclusionLOB', '2 Excluded'),\n CreateJProperty('excludeInclude', 'Exclude')\n )\n ) \n )\n)\n","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"'Header-4'"},"2":{"value":"'#FFD166'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"JObjectParse({Test})","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"'#FFFCF4'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"value":"'<button>Click Me!</button>'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"6":{"value":"'#FFD471'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"7":{"value":"CreateUIControl({Header-4},{HeaderBkg-4},{Body-4},{BodyBkg-4},{FooterRaw-4},{FooterBkg-4})","style":{"autoFormatter":{"customerCultureName":"en-US"}}}}},"columnDataArray":[{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}}]},"tag":"true|false|update","index":3},"Render Tiles":{"name":"Render Tiles","selections":{"0":{"row":3,"rowCount":1,"col":0,"colCount":1}},"columns":[{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":true,"dirty":null}],"rowCount":50,"columnCount":9,"activeRow":3,"colHeaderRowInfos":[{"size":20,"dirty":true}],"data":{"dataTable":{"0":{"0":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}},"1":{"value":"Comment","style":{"backColor":"#FFFFE1 ","font":"italic 12px arial"}}},"1":{"0":{"value":"FinalOutput","style":{"backColor":"#F4B084","font":"700 13.3333px arial"}},"1":{"style":{"backColor":"#FFFFE1 ","font":"700 13.3333px arial","wordWrap":true}}},"2":{"0":{"value":"==","style":{"backColor":"#F4B084"}},"1":{"style":{"backColor":"#FFFFE1 "}}},"3":{"0":{"value":"CreateUIControlCollection(CreateUIProperty('xcachetemplate',{{QuickTileTemplate_Grid}}),{CreateControl-1},{CreateControl-2},{CreateControl-3},{CreateControl-4})","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"Colour palate from https://coolors.co/palette/ef476f-ffd166-06d6a0-118ab2-073b4c","style":{"autoFormatter":{"customerCultureName":"en-US"}}}}},"columnDataArray":[{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}}]},"tag":"true|false|clientside","index":4},"Global Calculations":{"name":"Global Calculations","columns":[{"size":300,"dirty":null},{"size":400,"dirty":null},{"size":400,"dirty":null}],"rowCount":200,"columnCount":6,"data":{"dataTable":{"0":{"0":{"value":"Calculation Name","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"1":{"value":"Calculation Value","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"2":{"value":"Comment","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}}}}},"index":5},"Global Actions":{"name":"Global Actions","selections":{"0":{"row":1,"rowCount":1,"col":1,"colCount":1}},"columns":[{"size":300,"dirty":null},{"size":400,"dirty":null},{"size":400,"dirty":null}],"rowCount":200,"columnCount":6,"activeRow":1,"activeCol":1,"data":{"dataTable":{"0":{"0":{"value":"Action Name","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"1":{"value":"Action Value","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"2":{"value":"Comment","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}}},"1":{"0":{"style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"autoFormatter":{"customerCultureName":"en-US"}}}}}},"index":6},"Global FetchXml":{"name":"Global FetchXml","columns":[{"size":300,"dirty":null},{"size":400,"dirty":null},{"size":400,"dirty":null}],"rowCount":200,"columnCount":6,"data":{"dataTable":{"0":{"0":{"value":"FetchXml Name","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"1":{"value":"FetchXml Query","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"2":{"value":"Comment","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}}}}},"index":7}}}*/
xCache
Category:
QuickTileTemplate
Base Key:
QuickTileTemplate_Grid
Value:
<style>.wrapper-grid{display: grid;grid-template-columns: repeat(auto-fit, minmax(200px, 1fr));}
.include{
color:inherit;
}
.exclude{
color:inherit;
}
.wrapper-grid{
grid-gap: 20px;
}
.grid-item{
border-radius:5px;
display: grid;
grid-template-rows: auto 1fr auto;
}
.grid-item-header {
color: rgba(255, 255, 255, 0.9);
padding: 10px;
background:lightgrey;
font-weight:bold;
font-size:14px;
border-top-left-radius: inherit;
border-top-right-radius: inherit;
}
.grid-item-body {
padding: 20px;
font-size: 14px
}
.grid-item-body i {
padding-right: 7px;
}
.grid-item-body ul {
list-style: none;
margin: 0;
padding: 0;
}
.grid-item-body li {
display: flex;
align-items: center;
padding-bottom: 7px;
}
.grid-item-body .glyphicon-ok {
color: green;
font-size: 20px;
}
.grid-item-body .glyphicon-remove {
color: red;
font-size: 20px;
}
.grid-item-footer {
background: grey;
padding: 10px;
border-bottom-left-radius: inherit;
border-bottom-right-radius: inherit;
text-align: center;
}
</style>
<div class="wrapper-grid">
{{#each tiles}}
<div class="grid-item item{{@index}}">
<div class="grid-item-header" style="background:{{headerbkg}}">{{header}}</div>
<div class="grid-item-body" style="background:{{bodybkg}}">
<ul>
{{#each body.exclusionInclusions}}<li class="{{#ifEquals excludeInclude 'Include'}}include{{else}}exclude{{/ifEquals}}"><i class="glyphicon {{#ifEquals excludeInclude 'Include'}}glyphicon-ok{{else}}glyphicon-remove{{/ifEquals}}"></i>{{exclusionInclusionLOB}}</li>{{/each}}
</ul>
</div>
<div class="grid-item-footer" style="background:{{footerbkg}}">{{footer}}{{{footerraw}}}</div>
</div>
{{/each}}
</div>
Simple Message
Formula logic
MultipleDecisionTable(
DecisionTable(
IfTrue( [account.fax] = 'goo' ,
CreateUIProperty('Label-1', ''),
CreateUIProperty('URL-1', 'https://google.com'),
CreateUIProperty('UrlName-1', 'https://google.com'),
CreateUIProperty('UrlCssStyle-1', ''),
SetVar('CreateControl-1', CreateUIControl(GetVar('Label-1'),GetVar('URL-1'),GetVar('UrlName-1'),GetVar('UrlCssStyle-1')))) ,
IfTrue( [account.fax] = 'duck' ,
CreateUIProperty('Label-1', '⚠️ Quack Quack, get going to '),
CreateUIProperty('URL-1', 'https://duckduckgo.com/'),
CreateUIProperty('UrlName-1', 'Duck Duck Go! ↗️'),
CreateUIProperty('UrlCssStyle-1', 'color:orange; font-weight:bold'),
SetVar('CreateControl-1', CreateUIControl(GetVar('Label-1'),GetVar('URL-1'),GetVar('UrlName-1'),GetVar('UrlCssStyle-1')))) ,
IfTrue(true,
CreateUIProperty('Label-1', '✅ No message to display'),
CreateUIProperty('URL-1', ''),
CreateUIProperty('UrlName-1', ''),
CreateUIProperty('UrlCssStyle-1', ''),
SetVar('CreateControl-1', CreateUIControl(GetVar('Label-1'),GetVar('URL-1'),GetVar('UrlName-1'),GetVar('UrlCssStyle-1'))))
, IfTrue(true, GetVar('CreateControl-1', 'NoOp') )
,
'true|false|update|Message 1') ,
DecisionTable(
IfTrue(true,
SetVar('FinalOutput', CreateUIControlCollection(CreateUIProperty('xcachetemplate',xCacheGetGlobal('QuickTileTemplate_SimpleMessage')),GetVar('CreateControl-1'))))
, IfTrue(true, GetVar('FinalOutput', 'NoOp') )
,
'true|false|clientside|Render Tiles')
)
/*{"version":"8.40.20151.5","sheetCount":6,"tabStripRatio":0.6949078138718178,"newTabVisible":false,"allowDragDrop":false,"sheets":{"Info exclude":{"name":"Info exclude","columns":[{"size":577,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":false,"dirty":null}],"rowCount":50,"columnCount":11,"data":{"dataTable":{"0":{"0":{"value":"Comment","style":{"backColor":"#FFFFE1 ","font":"italic 12px arial"}}},"1":{"0":{"style":{"backColor":"#FFFFE1 ","font":"700 13.3333px arial","wordWrap":true}}},"2":{"0":{"style":{"backColor":"#FFFFE1 "}}},"3":{"0":{"value":"Template for displaying message and/or link","style":{"autoFormatter":{"customerCultureName":"en-US"}}}},"4":{"0":{"value":"Label displays message preceding link - optional","style":{"autoFormatter":{"customerCultureName":"en-US"}}}},"5":{"0":{"value":"URL is the link that will open in a new window/tab - optional","style":{"autoFormatter":{"customerCultureName":"en-US"}}}},"6":{"0":{"value":"URLName is the clickable text that will be displays - only applicable if URL is specified","style":{"autoFormatter":{"customerCultureName":"en-US"}}}},"7":{"0":{"value":"UrlCssStyle - add css styling for the link - only applicable if URL is specified","style":{"autoFormatter":{"customerCultureName":"en-US"}}}},"8":{"0":{"style":{"autoFormatter":{"customerCultureName":"en-US"}}}},"9":{"0":{"value":"Modifications to template can be made in the xCache record \"QuickTileTemplate_SimpleMessage\"","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"10":{"0":{"style":{"autoFormatter":{"customerCultureName":"en-US"}}}}},"columnDataArray":[{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}}]},"tag":"true|false|update","index":0},"Message 1":{"name":"Message 1","columns":[{"size":120,"dirty":null},{"size":243,"dirty":null},{"size":186.99999976158142,"dirty":null},{"size":138.99999976158142,"dirty":null},{"size":202,"dirty":null},{"size":319,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":false,"dirty":null}],"rowCount":50,"columnCount":6,"data":{"dataTable":{"0":{"0":{"value":"Condition","style":{"backColor":"#ffdf80","foreColor":"Black","font":"italic 12px arial"}},"1":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","hAlign":0,"vAlign":0,"font":"italic 12px arial","imeMode":1}},"2":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"3":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"4":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","hAlign":0,"vAlign":0,"font":"italic 12px arial","imeMode":1}},"5":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}}},"1":{"0":{"value":"Fax","style":{"backColor":"#ffdf80","font":"700 13.3333px arial","wordWrap":true}},"1":{"value":"Label-1","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"URL-1","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"UrlName-1","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"UrlCssStyle-1","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"value":"CreateControl-1","style":{"backColor":"#F4B084","font":"700 13.3333px arial","wordWrap":true}}},"2":{"0":{"value":"[account.fax]","style":{"backColor":"#ffdf80"}},"1":{"value":"ui","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"imeMode":1}},"2":{"value":"ui","style":{"backColor":"#DDA0DD"}},"3":{"value":"ui","style":{"backColor":"#DDA0DD"}},"4":{"value":"ui","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"imeMode":1}},"5":{"value":"==","style":{"backColor":"#F4B084"}}},"3":{"0":{"value":"'goo'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"''","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"'https://google.com'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"'https://google.com'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"''","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"value":"CreateUIControl({Label-1},{URL-1},{UrlName-1},{UrlCssStyle-1})","style":{"autoFormatter":{"customerCultureName":"en-US"}}}},"4":{"0":{"value":"'duck'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"'⚠️ Quack Quack, get going to '","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"'https://duckduckgo.com/'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"'Duck Duck Go! ↗️'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"'color:orange; font-weight:bold'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"value":"CreateUIControl({Label-1},{URL-1},{UrlName-1},{UrlCssStyle-1})","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"5":{"1":{"value":"'✅ No message to display'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"''","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"''","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"''","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"5":{"value":"CreateUIControl({Label-1},{URL-1},{UrlName-1},{UrlCssStyle-1})","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}},"6":{"2":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}}}},"columnDataArray":[{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}}]},"tag":"true|false|update","index":1},"Render Tiles":{"name":"Render Tiles","selections":{"0":{"row":4,"rowCount":1,"col":0,"colCount":1}},"columns":[{"size":384,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":false,"dirty":null}],"rowCount":50,"columnCount":9,"activeRow":4,"colHeaderRowInfos":[{"size":20,"dirty":true}],"data":{"dataTable":{"0":{"0":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}},"1":{"value":"Comment","style":{"backColor":"#FFFFE1 ","font":"italic 12px arial"}}},"1":{"0":{"value":"FinalOutput","style":{"backColor":"#F4B084","font":"700 13.3333px arial"}},"1":{"style":{"backColor":"#FFFFE1 ","font":"700 13.3333px arial","wordWrap":true}}},"2":{"0":{"value":"==","style":{"backColor":"#F4B084"}},"1":{"style":{"backColor":"#FFFFE1 "}}},"3":{"0":{"value":"CreateUIControlCollection(CreateUIProperty('xcachetemplate',{{QuickTileTemplate_SimpleMessage}}),{CreateControl-1})","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"autoFormatter":{"customerCultureName":"en-US"}}}}},"columnDataArray":[{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}}]},"tag":"true|false|clientside","index":2},"Global Calculations":{"name":"Global Calculations","selections":{"0":{"row":1,"rowCount":1,"col":0,"colCount":1}},"columns":[{"size":300,"dirty":null},{"size":400,"dirty":null},{"size":400,"dirty":null}],"rowCount":200,"columnCount":6,"activeRow":1,"visible":false,"data":{"dataTable":{"0":{"0":{"value":"Calculation Name","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"1":{"value":"Calculation Value","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"2":{"value":"Comment","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}}},"1":{"0":{"style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"autoFormatter":{"customerCultureName":"en-US"}}}}}},"index":3},"Global Actions":{"name":"Global Actions","selections":{"0":{"row":1,"rowCount":1,"col":1,"colCount":1}},"columns":[{"size":300,"dirty":null},{"size":400,"dirty":null},{"size":400,"dirty":null}],"rowCount":200,"columnCount":6,"activeRow":1,"activeCol":1,"visible":false,"data":{"dataTable":{"0":{"0":{"value":"Action Name","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"1":{"value":"Action Value","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"2":{"value":"Comment","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}}},"1":{"0":{"style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"autoFormatter":{"customerCultureName":"en-US"}}}}}},"index":4},"Global FetchXml":{"name":"Global FetchXml","columns":[{"size":300,"dirty":null},{"size":400,"dirty":null},{"size":400,"dirty":null}],"rowCount":200,"columnCount":6,"visible":false,"data":{"dataTable":{"0":{"0":{"value":"FetchXml Name","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"1":{"value":"FetchXml Query","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}},"2":{"value":"Comment","style":{"backColor":"#d3d3d3","font":"700 13.3333px arial"}}}}},"index":5}}}*/
xCache
Category:
QuickTileTemplate
Base Key:
QuickTileTemplate_SimpleMessage
Value:
{{#each tiles}}<p>{{#if label}}{{label}} {{/if}}{{#if url}}<a href="{{url}}" target="_blank" {{#if urlcssstyle}} style="{{urlcssstyle}}"{{/if}}>{{urlname}}</a>{{/if}}</p>{{/each}}