Note: This functionality requires Quick Tile v9.30+
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('isComplete-1', true), CreateUIProperty('isActive-1', false), SetVar('CreateControl-1', CreateUIControl(GetVar('StepName-1'),GetVar('isComplete-1'),GetVar('isActive-1')))) , IfTrue( 'Complete' = 'Active' , CreateUIProperty('StepName-1', 'Step One Active'), CreateUIProperty('isComplete-1', false), CreateUIProperty('isActive-1', true), SetVar('CreateControl-1', CreateUIControl(GetVar('StepName-1'),GetVar('isComplete-1'),GetVar('isActive-1')))) , IfTrue(true, CreateUIProperty('StepName-1', 'Step One'), CreateUIProperty('isComplete-1', false), CreateUIProperty('isActive-1', false), SetVar('CreateControl-1', CreateUIControl(GetVar('StepName-1'),GetVar('isComplete-1'),GetVar('isActive-1')))) , IfTrue(true, GetVar('CreateControl-1', 'NoOp') ) , 'true|false|update|Step 1') , DecisionTable( IfTrue( 'Active' = 'Complete' , CreateUIProperty('StepName-2', 'Step Two Complete'), CreateUIProperty('isComplete-2', true), CreateUIProperty('isActive-2', false), SetVar('CreateControl-2', CreateUIControl(GetVar('StepName-2'),GetVar('isComplete-2'),GetVar('isActive-2')))) , IfTrue( 'Active' = 'Active' , CreateUIProperty('StepName-2', 'Step Two Active'), CreateUIProperty('isComplete-2', false), CreateUIProperty('isActive-2', true), SetVar('CreateControl-2', CreateUIControl(GetVar('StepName-2'),GetVar('isComplete-2'),GetVar('isActive-2')))) , IfTrue(true, CreateUIProperty('StepName-2', 'Step Two'), CreateUIProperty('isComplete-2', false), CreateUIProperty('isActive-2', false), SetVar('CreateControl-2', CreateUIControl(GetVar('StepName-2'),GetVar('isComplete-2'),GetVar('isActive-2')))) , IfTrue(true, GetVar('CreateControl-2', 'NoOp') ) , 'true|false|update|Step 2') , DecisionTable( IfTrue( '' = 'Complete' , CreateUIProperty('StepName-3', 'Step Three Complete'), CreateUIProperty('isComplete-3', true), CreateUIProperty('isActive-3', false), SetVar('CreateControl-3', CreateUIControl(GetVar('StepName-3'),GetVar('isComplete-3'),GetVar('isActive-3')))) , IfTrue( '' = 'Active' , CreateUIProperty('StepName-3', 'Step Three Active'), CreateUIProperty('isComplete-3', false), CreateUIProperty('isActive-3', true), SetVar('CreateControl-3', CreateUIControl(GetVar('StepName-3'),GetVar('isComplete-3'),GetVar('isActive-3')))) , IfTrue(true, CreateUIProperty('StepName-3', 'Step Three'), CreateUIProperty('isComplete-3', false), CreateUIProperty('isActive-3', false), SetVar('CreateControl-3', CreateUIControl(GetVar('StepName-3'),GetVar('isComplete-3'),GetVar('isActive-3')))) , IfTrue(true, GetVar('CreateControl-3', 'NoOp') ) , 'true|false|update|Step 3') , DecisionTable( IfTrue( '' = 'Complete' , CreateUIProperty('StepName-4', 'Step Four Complete'), CreateUIProperty('isComplete-4', true), CreateUIProperty('isActive-4', false), SetVar('CreateControl-4', CreateUIControl(GetVar('StepName-4'),GetVar('isComplete-4'),GetVar('isActive-4')))) , IfTrue( '' = 'Active' , CreateUIProperty('StepName-4', 'Step Four Active'), CreateUIProperty('isComplete-4', false), CreateUIProperty('isActive-4', true), SetVar('CreateControl-4', CreateUIControl(GetVar('StepName-4'),GetVar('isComplete-4'),GetVar('isActive-4')))) , IfTrue(true, CreateUIProperty('StepName-4', 'Step Four'), CreateUIProperty('isComplete-4', false), CreateUIProperty('isActive-4', false), SetVar('CreateControl-4', CreateUIControl(GetVar('StepName-4'),GetVar('isComplete-4'),GetVar('isActive-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","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":120,"dirty":null},{"size":378,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":true,"dirty":null}],"rowCount":50,"columnCount":5,"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":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","hAlign":0,"vAlign":0,"font":"italic 12px arial","imeMode":1}},"4":{"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":"isComplete-1","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"isActive-1","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"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":"ui","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"imeMode":1}},"4":{"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":true,"style":{"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":false,"style":{"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"CreateUIControl({StepName-1},{isComplete-1},{isActive-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":false,"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":true,"style":{"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"CreateUIControl({StepName-1},{isComplete-1},{isActive-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":false,"style":{"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":false,"style":{"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"CreateUIControl({StepName-1},{isComplete-1},{isActive-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}},{"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":120,"dirty":null},{"size":319,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":true,"dirty":null}],"rowCount":50,"columnCount":5,"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","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":"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":"isComplete-2","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"isActive-2","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"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","hAlign":0,"vAlign":0,"imeMode":1}},"3":{"value":"ui","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"imeMode":1}},"4":{"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":true,"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":false,"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"CreateUIControl({StepName-2},{isComplete-2},{isActive-2})","style":{"hAlign":0,"vAlign":0,"imeMode":1,"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":false,"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":true,"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"CreateUIControl({StepName-2},{isComplete-2},{isActive-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":false,"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":false,"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"CreateUIControl({StepName-2},{isComplete-2},{isActive-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}},{"style":{"hAlign":0}}]},"tag":"true|false|update","index":1},"Step 3":{"name":"Step 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":405,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":true,"dirty":null}],"rowCount":50,"columnCount":5,"activeRow":3,"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","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":"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":"isComplete-3","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"isActive-3","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"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","hAlign":0,"vAlign":0,"imeMode":1}},"3":{"value":"ui","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"imeMode":1}},"4":{"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":true,"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":false,"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"CreateUIControl({StepName-3},{isComplete-3},{isActive-3})","style":{"hAlign":0,"vAlign":0,"imeMode":1,"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":false,"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":true,"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"CreateUIControl({StepName-3},{isComplete-3},{isActive-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":false,"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":false,"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"CreateUIControl({StepName-3},{isComplete-3},{isActive-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}},{"style":{"hAlign":0}}]},"tag":"true|false|update","index":2},"Step 4":{"name":"Step 4","columns":[{"size":120,"dirty":null},{"size":151,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":442,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":true,"dirty":null}],"rowCount":50,"columnCount":5,"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","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":"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":"isComplete-4","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"isActive-4","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"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","hAlign":0,"vAlign":0,"imeMode":1}},"3":{"value":"ui","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"imeMode":1}},"4":{"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":true,"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":false,"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"CreateUIControl({StepName-4},{isComplete-4},{isActive-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":false,"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":true,"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"CreateUIControl({StepName-4},{isComplete-4},{isActive-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":false,"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":false,"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"CreateUIControl({StepName-4},{isComplete-4},{isActive-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}}]},"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":true,"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,"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_SimpleMessage
Value:
Progress Steps with Message
Formula logic
MultipleDecisionTable( DecisionTable( IfTrue( 'Complete' = 'Complete' , CreateUIProperty('StepName-1', 'Step One Complete'), CreateUIProperty('isComplete-1', true), CreateUIProperty('isActive-1', false), SetVar('CreateControl-1', CreateUIControl(GetVar('StepName-1'),GetVar('isComplete-1'),GetVar('isActive-1')))) , IfTrue( 'Complete' = 'Active' , CreateUIProperty('StepName-1', 'Step One Active'), CreateUIProperty('isComplete-1', false), CreateUIProperty('isActive-1', true), SetVar('CreateControl-1', CreateUIControl(GetVar('StepName-1'),GetVar('isComplete-1'),GetVar('isActive-1')))) , IfTrue(true, CreateUIProperty('StepName-1', 'Step One'), CreateUIProperty('isComplete-1', false), CreateUIProperty('isActive-1', false), SetVar('CreateControl-1', CreateUIControl(GetVar('StepName-1'),GetVar('isComplete-1'),GetVar('isActive-1')))) , IfTrue(true, GetVar('CreateControl-1', 'NoOp') ) , 'true|false|update|Step 1') , DecisionTable( IfTrue( 'Active' = 'Complete' , CreateUIProperty('StepName-2', 'Step Two Complete'), CreateUIProperty('isComplete-2', true), CreateUIProperty('isActive-2', false), SetVar('CreateControl-2', CreateUIControl(GetVar('StepName-2'),GetVar('isComplete-2'),GetVar('isActive-2')))) , IfTrue( 'Active' = 'Active' , CreateUIProperty('StepName-2', 'Step Two Active'), CreateUIProperty('isComplete-2', false), CreateUIProperty('isActive-2', true), SetVar('CreateControl-2', CreateUIControl(GetVar('StepName-2'),GetVar('isComplete-2'),GetVar('isActive-2')))) , IfTrue(true, CreateUIProperty('StepName-2', 'Step Two'), CreateUIProperty('isComplete-2', false), CreateUIProperty('isActive-2', false), SetVar('CreateControl-2', CreateUIControl(GetVar('StepName-2'),GetVar('isComplete-2'),GetVar('isActive-2')))) , IfTrue(true, GetVar('CreateControl-2', 'NoOp') ) , 'true|false|update|Step 2') , DecisionTable( IfTrue( '' = 'Complete' , CreateUIProperty('StepName-3', 'Step Three Complete'), CreateUIProperty('isComplete-3', true), CreateUIProperty('isActive-3', false), SetVar('CreateControl-3', CreateUIControl(GetVar('StepName-3'),GetVar('isComplete-3'),GetVar('isActive-3')))) , IfTrue( '' = 'Active' , CreateUIProperty('StepName-3', 'Step Three Active'), CreateUIProperty('isComplete-3', false), CreateUIProperty('isActive-3', true), SetVar('CreateControl-3', CreateUIControl(GetVar('StepName-3'),GetVar('isComplete-3'),GetVar('isActive-3')))) , IfTrue(true, CreateUIProperty('StepName-3', 'Step Three'), CreateUIProperty('isComplete-3', false), CreateUIProperty('isActive-3', false), SetVar('CreateControl-3', CreateUIControl(GetVar('StepName-3'),GetVar('isComplete-3'),GetVar('isActive-3')))) , IfTrue(true, GetVar('CreateControl-3', 'NoOp') ) , 'true|false|update|Step 3') , DecisionTable( IfTrue( '' = 'Complete' , CreateUIProperty('StepName-4', 'Step Four Complete'), CreateUIProperty('isComplete-4', true), CreateUIProperty('isActive-4', false), SetVar('CreateControl-4', CreateUIControl(GetVar('StepName-4'),GetVar('isComplete-4'),GetVar('isActive-4')))) , IfTrue( '' = 'Active' , CreateUIProperty('StepName-4', 'Step Four Active'), CreateUIProperty('isComplete-4', false), CreateUIProperty('isActive-4', true), SetVar('CreateControl-4', CreateUIControl(GetVar('StepName-4'),GetVar('isComplete-4'),GetVar('isActive-4')))) , IfTrue(true, CreateUIProperty('StepName-4', 'Step Four'), CreateUIProperty('isComplete-4', false), CreateUIProperty('isActive-4', false), SetVar('CreateControl-4', CreateUIControl(GetVar('StepName-4'),GetVar('isComplete-4'),GetVar('isActive-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":3,"sheetCount":9,"newTabVisible":false,"allowDragDrop":false,"sheets":{"Step 1":{"name":"Step 1","selections":{"0":{"row":3,"rowCount":1,"col":4,"colCount":1}},"columns":[{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":true},{"size":378,"dirty":true}],"rows":[null,{"size":35,"dirty":null},{"visible":true,"dirty":true}],"rowCount":50,"columnCount":5,"activeRow":3,"activeCol":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":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","hAlign":0,"vAlign":0,"font":"italic 12px arial","imeMode":1}},"4":{"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":"isComplete-1","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"isActive-1","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"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":"ui","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"imeMode":1}},"4":{"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":true,"style":{"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":false,"style":{"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"CreateUIControl({StepName-1},{isComplete-1},{isActive-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":false,"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":true,"style":{"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"CreateUIControl({StepName-1},{isComplete-1},{isActive-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":false,"style":{"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":false,"style":{"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"CreateUIControl({StepName-1},{isComplete-1},{isActive-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}},{"style":{"hAlign":0}}]},"tag":"true|false|update","index":0},"Step 2":{"name":"Step 2","selections":{"0":{"row":3,"rowCount":1,"col":4,"colCount":1}},"columns":[{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":true},{"size":319,"dirty":null}],"rows":[null,{"size":35,"dirty":null},{"visible":true,"dirty":true}],"rowCount":50,"columnCount":5,"activeRow":3,"activeCol":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","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":"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":"isComplete-2","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"isActive-2","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"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","hAlign":0,"vAlign":0,"imeMode":1}},"3":{"value":"ui","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"imeMode":1}},"4":{"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":true,"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":false,"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"CreateUIControl({StepName-2},{isComplete-2},{isActive-2})","style":{"hAlign":0,"vAlign":0,"imeMode":1,"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":false,"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":true,"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"CreateUIControl({StepName-2},{isComplete-2},{isActive-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":false,"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":false,"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"CreateUIControl({StepName-2},{isComplete-2},{isActive-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}},{"style":{"hAlign":0}}]},"tag":"true|false|update","index":1},"Step 3":{"name":"Step 3","selections":{"0":{"row":3,"rowCount":1,"col":4,"colCount":1}},"columns":[{"size":120,"dirty":null},{"size":120,"dirty":null},{"size":120,"dirty":true},{"size":120,"dirty":null},{"size":405,"dirty":true}],"rows":[null,{"size":35,"dirty":null},{"visible":true,"dirty":true}],"rowCount":50,"columnCount":5,"activeRow":3,"activeCol":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","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":"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":"isComplete-3","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"isActive-3","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"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","hAlign":0,"vAlign":0,"imeMode":1}},"3":{"value":"ui","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"imeMode":1}},"4":{"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":true,"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":false,"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"CreateUIControl({StepName-3},{isComplete-3},{isActive-3})","style":{"hAlign":0,"vAlign":0,"imeMode":1,"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":false,"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":true,"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"CreateUIControl({StepName-3},{isComplete-3},{isActive-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":false,"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":false,"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"CreateUIControl({StepName-3},{isComplete-3},{isActive-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}},{"style":{"hAlign":0}}]},"tag":"true|false|update","index":2},"Step 4":{"name":"Step 4","selections":{"0":{"row":2,"rowCount":1,"col":3,"colCount":1}},"columns":[{"size":120,"dirty":null},{"size":151,"dirty":true},{"size":120,"dirty":true},{"size":120,"dirty":null},{"size":442,"dirty":true}],"rows":[null,{"size":35,"dirty":null},{"visible":true,"dirty":true}],"rowCount":50,"columnCount":5,"activeRow":2,"activeCol":3,"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","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":"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":"isComplete-4","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":"isActive-4","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"font":"700 13.3333px arial","wordWrap":true,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"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","hAlign":0,"vAlign":0,"imeMode":1}},"3":{"value":"ui","style":{"backColor":"#DDA0DD","hAlign":0,"vAlign":0,"imeMode":1}},"4":{"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":true,"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":false,"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"CreateUIControl({StepName-4},{isComplete-4},{isActive-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":false,"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":true,"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"CreateUIControl({StepName-4},{isComplete-4},{isActive-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":false,"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"3":{"value":false,"style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"4":{"value":"CreateUIControl({StepName-4},{isComplete-4},{isActive-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}}]},"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":true,"dirty":true}],"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","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":true,"dirty":true}],"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_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,"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,"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,"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:
<div style="margin: 20px 0; padding-bottom: 20px;"> <div style="position: relative; display: flex; align-items: flex-start; margin-bottom: 10px;"> <!-- Background line --> <div style="position: absolute; top: 10px; left: 10px; right: 10px; height: 4px; background-color: #dfe3e4; z-index: 1;"></div> {{#each tiles}}{{#if stepname}} <div style="position: relative; flex: 1; text-align: center; z-index: 2;"> {{#if iscomplete}} <!-- Complete step circle with checkmark --> <div style="width: 20px; height: 20px; margin: 0 auto 8px; background: #090; border: 4px solid #090; border-radius: 50%; display: flex; align-items: center; justify-content: center; color: white; font-size: 12px; font-weight: bold; position: relative; z-index: 3;">✓</div> <div style="font-size: 12px; color: #090; font-weight: 500;">{{stepname}}</div> <!-- Progress line to next step --> <div style="position: absolute; top: 10px; left: 50%; width: 100%; height: 4px; background: #2183dd; z-index: 1;"></div> {{else}} {{#if isactive}} <!-- Active step circle --> <div style="width: 20px; height: 20px; margin: 0 auto 8px; background: white; border: 4px solid #2183dd; border-radius: 50%; box-shadow: 0 0 0 4px rgba(33, 131, 221, 0.2); position: relative; z-index: 3;"></div> <div style="font-size: 12px; color: #2183dd; font-weight: 500;">{{stepname}}</div> {{else}} <!-- Inactive step circle --> <div style="width: 20px; height: 20px; margin: 0 auto 8px; background: white; border: 4px solid #dfe3e4; border-radius: 50%; position: relative; z-index: 3;"></div> <div style="font-size: 12px; color: #888;">{{stepname}}</div> {{/if}} {{/if}} </div> {{/if}}{{/each}} </div> <!-- Message panels --> {{#each tiles}}{{#if message}} <div style="margin-bottom: 0; margin-top: 30px; text-align: center; background-color: #d9edf7; padding: 15px; border: 1px solid #bce8f1; border-radius: 4px;"> {{{message}}} </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:
{{#each tiles}}{{#if link}}<a href="{{link}}" target="{{linktarget}}">{{/if}}<span class="label {{#if class}}label-{{class}}{{/if}}" style="font-size:85%;{{style}}">{{label}}</span>{{#if link}}</a>{{/if}} {{/each}}
Statistics
Formula logic
MultipleDecisionTable( DecisionTable( IfTrue(true, SetVar('Positive', '#3adb76'), SetVar('Negative', '#cc4b37')) , 'true|false|update|Info and Colors') , DecisionTable( IfTrue(true, CreateUIProperty('StatValue-1', '1,576'), CreateUIProperty('StatLabel-1', 'Total Units'), CreateUIProperty('CssColor-1', ''), SetVar('CreateControl-1', CreateUIControl(GetVar('StatValue-1'),GetVar('StatLabel-1'),GetVar('CssColor-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('CssColor-2', GetVar('Positive')), SetVar('CreateControl-2', CreateUIControl(GetVar('StatValue-2'),GetVar('StatLabel-2'),GetVar('CssColor-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('CssColor-3', GetVar('Negative')), SetVar('CreateControl-3', CreateUIControl(GetVar('StatValue-3'),GetVar('StatLabel-3'),GetVar('CssColor-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":4,"sheetCount":8,"tabStripRatio":0.6949078138718178,"newTabVisible":false,"allowDragDrop":false,"sheets":{"Info and Colors":{"name":"Info and Colors","columns":[{"size":577,"dirty":null},{"size":120,"dirty":true},{"size":120,"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}],"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":{"value":"Calc-Inline","style":{"backColor":"#F4B084","font":"italic 12px arial"}},"2":{"value":"Calc-Inline","style":{"backColor":"#F4B084","font":"italic 12px arial"}}},"1":{"0":{"style":{"backColor":"#FFFFE1 ","font":"700 13.3333px arial","wordWrap":true}},"1":{"value":"Positive","style":{"backColor":"#F4B084","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"Negative","style":{"backColor":"#F4B084","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}}},"2":{"0":{"style":{"backColor":"#FFFFE1 "}},"1":{"value":"==","style":{"backColor":"#F4B084"}},"2":{"value":"==","style":{"backColor":"#F4B084"}}},"3":{"0":{"value":"Template for displaying numerical statistics","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"'#3adb76'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"2":{"value":"'#cc4b37'","style":{"autoFormatter":{"customerCultureName":"en-US"}}}},"4":{"0":{"value":"Css Color options (colors can be edited in the inline calcs on this sheet:","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":3,"colCount":1}},"columns":[{"size":186.99999976158142,"dirty":null},{"size":138.99999976158142,"dirty":null},{"size":156,"dirty":null},{"size":386,"dirty":true}],"rows":[null,{"size":35,"dirty":null},{"visible":false,"dirty":null}],"rowCount":50,"columnCount":4,"activeRow":4,"activeCol":3,"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":"CssColor-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},{CssColor-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":3,"colCount":1}},"columns":[{"size":186.99999976158142,"dirty":null},{"size":138.99999976158142,"dirty":null},{"size":156,"dirty":null},{"size":378,"dirty":true}],"rows":[null,{"size":35,"dirty":null},{"visible":false,"dirty":null}],"rowCount":50,"columnCount":4,"activeRow":4,"activeCol":3,"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":"CssColor-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},{CssColor-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":3,"colCount":1}},"columns":[{"size":186.99999976158142,"dirty":null},{"size":138.99999976158142,"dirty":null},{"size":156,"dirty":null},{"size":400,"dirty":true}],"rows":[null,{"size":35,"dirty":null},{"visible":false,"dirty":null}],"rowCount":50,"columnCount":4,"activeRow":4,"activeCol":3,"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":"CssColor-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},{CssColor-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:
<ul style="list-style-type: none; clear: left; margin: 0; padding: 0; text-align: center; margin-bottom: 30px;"> {{#each tiles}}<li style="display: inline-block; margin-right: 10px; padding-right: 10px; border-right: 1px solid #cacaca; text-align: center; font-size: 1.1em; font-weight: bold;{{#if csscolor}} color: {{csscolor}};{{/if}}{{#if @last}} border: none; margin: 0; padding: 0;{{/if}}"> {{statvalue}} <span style="display: block; margin-top: 2px; font-size: 0.9em; font-weight: normal;">{{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:
<div style="padding: 15px; text-align: center;"> {{#each tiles}} <a href="{{linkurl}}" target="_top" style="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;"> <span style="color: white; font-size: 16px;" class="glyphicon {{iconname}}"></span> <span style="position: absolute; top: -10px; right: -10px; font-size: .8em; background: #cc4b37; color: #fefefe; display: inline-block; min-width: 2.1em; padding: 0.3em; border-radius: 50%; text-align: center;">{{alertvalue}}</span> </a> {{/each}} </div>
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('ButtonText-1', 'Click Me!'), CreateUIProperty('FooterBkg-1', '#0C6583'), SetVar('CreateControl-1', CreateUIControl(GetVar('Header-1'),GetVar('HeaderBkg-1'),GetVar('Body-1'),GetVar('BodyBkg-1'),GetVar('ButtonText-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('ButtonText-2', 'Click Me!'), CreateUIProperty('FooterBkg-2', '#1299C6'), SetVar('CreateControl-2', CreateUIControl(GetVar('Header-2'),GetVar('HeaderBkg-2'),GetVar('Body-2'),GetVar('BodyBkg-2'),GetVar('ButtonText-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('ButtonText-3', 'Click Me!'), CreateUIProperty('FooterBkg-3', '#06EAAD'), SetVar('CreateControl-3', CreateUIControl(GetVar('Header-3'),GetVar('HeaderBkg-3'),GetVar('Body-3'),GetVar('BodyBkg-3'),GetVar('ButtonText-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('ButtonText-4', 'Click Me!'), CreateUIProperty('FooterBkg-4', '#FFD471'), SetVar('CreateControl-4', CreateUIControl(GetVar('Header-4'),GetVar('HeaderBkg-4'),GetVar('Body-4'),GetVar('BodyBkg-4'),GetVar('ButtonText-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","sheetCount":8,"tabStripRatio":0.6485664639443962,"newTabVisible":false,"allowDragDrop":false,"sheets":{"Tile 1":{"name":"Tile 1","selections":{"0":{"row":4,"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":4,"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":"ButtonText-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":"'Click Me!'","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},{ButtonText-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":5,"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,"activeCol":5,"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":"ButtonText-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":"'Click Me!'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"6":{"value":"'#1299C6'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"7":{"value":"CreateUIControl({Header-2},{HeaderBkg-2},{Body-2},{BodyBkg-2},{ButtonText-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":5,"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,"activeCol":5,"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":"ButtonText-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":"'Click Me!'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"6":{"value":"'#06EAAD'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"7":{"value":"CreateUIControl({Header-3},{HeaderBkg-3},{Body-3},{BodyBkg-3},{ButtonText-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","selections":{"0":{"row":3,"rowCount":1,"col":5,"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,"activeCol":5,"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":"ButtonText-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":"'Click Me!'","style":{"hAlign":0,"vAlign":0,"imeMode":1,"autoFormatter":{"customerCultureName":"en-US"}}},"6":{"value":"'#FFD471'","style":{"autoFormatter":{"customerCultureName":"en-US"}}},"7":{"value":"CreateUIControl({Header-4},{HeaderBkg-4},{Body-4},{BodyBkg-4},{ButtonText-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:
<div style="display: grid; grid-template-columns: repeat(auto-fit, minmax(200px, 1fr)); grid-gap: 20px;"> {{#each tiles}} <div style="border-radius: 5px; display: grid; grid-template-rows: auto 1fr auto;"> <div style="color: rgba(255, 255, 255, 0.9); padding: 10px; background: {{headerbkg}}; font-weight: bold; font-size: 14px; border-top-left-radius: inherit; border-top-right-radius: inherit;">{{header}}</div> <div style="padding: 20px; font-size: 14px; background: {{bodybkg}};"> <ul style="list-style: none; margin: 0; padding: 0;"> {{#each body.exclusionInclusions}}<li style="display: flex; align-items: center; padding-bottom: 7px; color: inherit;"><i style="padding-right: 7px; {{#ifEquals excludeInclude 'Include'}}color: green; font-size: 20px;{{else}}color: red; font-size: 20px;{{/ifEquals}}" class="glyphicon {{#ifEquals excludeInclude 'Include'}}glyphicon-ok{{else}}glyphicon-remove{{/ifEquals}}"></i>{{exclusionInclusionLOB}}</li>{{/each}} </ul> </div> <div style="background: {{footerbkg}}; padding: 10px; border-bottom-left-radius: inherit; border-bottom-right-radius: inherit; text-align: center;"><button class="btn btn-xs n52button" data-n52shortcode="abc" data-n52identifier="{{recordId}}" data-n52bind="{{@index}}">{{buttontext}}</button> </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}}
Validation Messages
This example takes JSON stored in a field (Description for the purpose of this sample) and renders it in a friendly, easily readable format. The field names and messages are totally dynamic.
Formula logic
MultipleDecisionTable( DecisionTable( IfTrue(true, CreateUIProperty('Validations-1', JArrayParse([account.description])), SetVar('CreateControl-1', CreateUIControl(GetVar('Validations-1')))) , IfTrue(true, GetVar('CreateControl-1', 'NoOp') ) , 'true|false|update|Add to QT Control') , DecisionTable( IfTrue(true, SetVar('FinalOutput', CreateUIControlCollection(CreateUIProperty('xcachetemplate',xCacheGetGlobal('QuickTileTemplate_ValidationJSON')),GetVar('CreateControl-1')))) , IfTrue(true, GetVar('FinalOutput', 'NoOp') ) , 'true|false|clientside|Render QuickTile') ) /*{"version":"8.40.20151.5","sheetCount":5,"tabStripRatio":0.7319721980886188,"newTabVisible":false,"allowDragDrop":false,"sheets":{"Add to QT Control":{"name":"Add to QT Control","selections":{"0":{"row":3,"rowCount":1,"col":0,"colCount":1}},"columns":[{"size":259,"dirty":true},{"size":180,"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":5,"activeRow":3,"data":{"dataTable":{"0":{"0":{"value":"UI-Property","style":{"backColor":"#DDA0DD","foreColor":"Black","font":"italic 12px arial"}},"1":{"value":"Calc-Inline","style":{"backColor":"#F4B084","foreColor":"Black","font":"italic 12px arial"}}},"1":{"0":{"value":"Validations-1","style":{"backColor":"#DDA0DD","font":"700 13.3333px arial","wordWrap":true,"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"value":"CreateControl-1","style":{"backColor":"#F4B084","font":"700 13.3333px arial","wordWrap":true}}},"2":{"0":{"value":"ui","style":{"backColor":"#DDA0DD"}},"1":{"value":"==","style":{"backColor":"#F4B084"}}},"3":{"0":{"value":"JArrayParse({Description})"},"1":{"value":"CreateUIControl({Validations-1})"}}},"columnDataArray":[{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}},{"style":{"hAlign":0}}]},"tag":"true|false|update","index":0},"Render QuickTile":{"name":"Render QuickTile","selections":{"0":{"row":3,"rowCount":1,"col":0,"colCount":1}},"columns":[{"size":683,"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":true}],"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_ValidationJSON}}),{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":1},"Global Calculations":{"name":"Global Calculations","selections":{"0":{"row":1,"rowCount":2,"col":0,"colCount":2}},"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"}}}},"2":{"0":{"style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"autoFormatter":{"customerCultureName":"en-US"}}}}}},"index":2},"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":3},"Global FetchXml":{"name":"Global FetchXml","selections":{"0":{"row":1,"rowCount":1,"col":0,"colCount":2}},"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":"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"}}},"1":{"0":{"style":{"autoFormatter":{"customerCultureName":"en-US"}}},"1":{"style":{"autoFormatter":{"customerCultureName":"en-US"}}}}}},"index":4}}}*/
xCache
Category:
QuickTileTemplate
Base Key:
QuickTileTemplate_ValidationJSON
Value:
{{#each tiles}} {{#each validations}} {{#each this}} <!-- Label for each validation group --> <h4 style="margin-top: 20px; margin-bottom: 10px; color: #333;">{{@key}}</h4> <div style="border: 1px solid #ddd; border-radius: 4px; overflow: hidden;width: calc(100% - 1px);"> <!-- Header --> <div style="display: flex; background-color: #f5f5f5; border-bottom: 1px solid #ddd; font-weight: bold;"> <div style="flex: 1; padding: 8px 12px; border-right: 1px solid #ddd;">Field Name</div> <div style="flex: 2; padding: 8px 12px;">Validation Message</div> </div> <!-- Body --> <div> {{#each this}} {{#each this}} <div style="display: flex; border-bottom: 1px solid #eee; background-color: #fff;"> <div style="flex: 1; padding: 8px 12px; border-right: 1px solid #eee;">{{@key}}</div> <div style="flex: 2; padding: 8px 12px;">{{this}}</div> </div> {{/each}} {{else}} <div style="display: flex; padding: 8px 12px; text-align: center; color: #999; font-style: italic; justify-content: center;"> <div>No validation messages</div> </div> {{/each}} </div> </div> {{/each}} {{/each}} {{/each}}