North52 App - Quick Tile - Custom Templates - 3. Sample Templates

Views:

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}}

Keywords: Quick Tile, custom template