Created
January 11, 2022 13:40
-
-
Save tecchan1107/c46b185dda50a8317f3f39a284ebcb8c to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/tile-formatting.schema.json", | |
| "height": 420, | |
| "width": 330, | |
| "hideSelection": true, | |
| "formatter": { | |
| "elmType": "div", | |
| "style": { | |
| "width": "90%", | |
| "height": "90%", | |
| "border": "1.5px solid", | |
| "flex-direction": "column", | |
| "align-items": "center", | |
| "justify-content": "center" | |
| }, | |
| "attributes": { | |
| "class": "ms-fontColor-neutralTertiaryAlt" | |
| }, | |
| "children": [ | |
| { | |
| "elmType": "div", | |
| "style": { | |
| "display": "flex", | |
| "flex-direction": "row", | |
| "justify-content": "space-around", | |
| "align-items": "center", | |
| "width": "100%" | |
| }, | |
| "children": [ | |
| { | |
| "elmType": "div", | |
| "txtContent": "= '#' + [$Number]", | |
| "style": { | |
| "font-size": "26px", | |
| "font-weight": "bold" | |
| }, | |
| "attributes": { | |
| "class": "ms-fontColor-neutralSecondaryAlt" | |
| } | |
| }, | |
| { | |
| "elmType": "div", | |
| "txtContent": "Answer", | |
| "style": { | |
| "padding": "5px 8px 5px 8px", | |
| "cursor": "pointer", | |
| "border-radius": "3px" | |
| }, | |
| "attributes": { | |
| "class": "ms-bgColor-neutralSecondaryAlt ms-fontColor-white" | |
| }, | |
| "customCardProps": { | |
| "openOnEvent": "click", | |
| "directionalHint": "rightCenter", | |
| "isBeakVisible": true, | |
| "formatter": { | |
| "elmType": "div", | |
| "txtContent": "=toUpperCase([$Title])", | |
| "style": { | |
| "padding": "10px 20px 10px 20px", | |
| "font-size": "30px", | |
| "font-weight": "bold" | |
| } | |
| } | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "elmType": "div", | |
| "style": { | |
| "display": "flex", | |
| "flex-direction": "column", | |
| "font-size": "28px", | |
| "font-weight": "bold", | |
| "width": "100%", | |
| "align-items": "center" | |
| }, | |
| "children": [ | |
| { | |
| "elmType": "div", | |
| "inlineEditField": "[$Text1]", | |
| "style": { | |
| "display": "flex", | |
| "flex-direction": "row", | |
| "justify-content": "space-around", | |
| "width": "90%", | |
| "padding": "5px" | |
| }, | |
| "children": [ | |
| { | |
| "elmType": "div", | |
| "style": { | |
| "text-align": "center", | |
| "border": "2px solid", | |
| "width": "40px", | |
| "height": "40px" | |
| }, | |
| "attributes": { | |
| "class": "=if([$Text1] == '' , 'ms-bgColor-white ms-fontColor-neutralTertiaryAlt' , if(substring([$Text1] , 0 , 1) == '' || indexOf(toUpperCase([$Title]) , toUpperCase(substring([$Text1] , 0 , 1))) < 0 , 'ms-bgColor-neutralSecondaryAlt ms-fontColor-neutralSecondaryAlt' , if(toUpperCase(substring([$Title] , 0 , 1)) == toUpperCase(substring([$Text1] , 0 , 1)) , 'ms-bgColor-sharedGreenCyan10 ms-fontColor-sharedGreenCyan10' , 'ms-bgColor-sharedOrangeYellow10 ms-fontColor-sharedOrangeYellow10') ) )" | |
| }, | |
| "children": [ | |
| { | |
| "elmType": "span", | |
| "txtContent": "=toUpperCase(substring([$Text1] , 0 , 1))", | |
| "attributes": { | |
| "class": "ms-fontColor-white" | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "elmType": "div", | |
| "style": { | |
| "text-align": "center", | |
| "border": "2px solid", | |
| "width": "40px", | |
| "height": "40px" | |
| }, | |
| "attributes": { | |
| "class": "=if([$Text1] == '' , 'ms-bgColor-white ms-fontColor-neutralTertiaryAlt' , if(substring([$Text1] , 1 , 2) == '' || indexOf(toUpperCase([$Title]) , toUpperCase(substring([$Text1] , 1 , 2))) < 0 , 'ms-bgColor-neutralSecondaryAlt ms-fontColor-neutralSecondaryAlt' , if(toUpperCase(substring([$Title] , 1 , 2)) == toUpperCase(substring([$Text1] , 1 , 2)) , 'ms-bgColor-sharedGreenCyan10 ms-fontColor-sharedGreenCyan10' , 'ms-bgColor-sharedOrangeYellow10 ms-fontColor-sharedOrangeYellow10') ) )" | |
| }, | |
| "children": [ | |
| { | |
| "elmType": "span", | |
| "txtContent": "=toUpperCase(substring([$Text1] , 1 , 2))", | |
| "attributes": { | |
| "class": "ms-fontColor-white" | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "elmType": "div", | |
| "style": { | |
| "text-align": "center", | |
| "border": "2px solid", | |
| "width": "40px", | |
| "height": "40px" | |
| }, | |
| "attributes": { | |
| "class": "=if([$Text1] == '' , 'ms-bgColor-white ms-fontColor-neutralTertiaryAlt' , if(substring([$Text1] , 2 , 3) == '' || indexOf(toUpperCase([$Title]) , toUpperCase(substring([$Text1] , 2 , 3))) < 0 , 'ms-bgColor-neutralSecondaryAlt ms-fontColor-neutralSecondaryAlt' , if(toUpperCase(substring([$Title] , 2 , 3)) == toUpperCase(substring([$Text1] , 2 , 3)) , 'ms-bgColor-sharedGreenCyan10 ms-fontColor-sharedGreenCyan10' , 'ms-bgColor-sharedOrangeYellow10 ms-fontColor-sharedOrangeYellow10') ) )" | |
| }, | |
| "children": [ | |
| { | |
| "elmType": "span", | |
| "txtContent": "=toUpperCase(substring([$Text1] , 2 , 3))", | |
| "attributes": { | |
| "class": "ms-fontColor-white" | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "elmType": "div", | |
| "style": { | |
| "text-align": "center", | |
| "border": "2px solid", | |
| "width": "40px", | |
| "height": "40px" | |
| }, | |
| "attributes": { | |
| "class": "=if([$Text1] == '' , 'ms-bgColor-white ms-fontColor-neutralTertiaryAlt' , if(substring([$Text1] , 3 , 4) == '' || indexOf(toUpperCase([$Title]) , toUpperCase(substring([$Text1] , 3 , 4))) < 0 , 'ms-bgColor-neutralSecondaryAlt ms-fontColor-neutralSecondaryAlt' , if(toUpperCase(substring([$Title] , 3 , 4)) == toUpperCase(substring([$Text1] , 3 , 4)) , 'ms-bgColor-sharedGreenCyan10 ms-fontColor-sharedGreenCyan10' , 'ms-bgColor-sharedOrangeYellow10 ms-fontColor-sharedOrangeYellow10') ) )" | |
| }, | |
| "children": [ | |
| { | |
| "elmType": "span", | |
| "txtContent": "=toUpperCase(substring([$Text1] , 3 , 4))", | |
| "attributes": { | |
| "class": "ms-fontColor-white" | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "elmType": "div", | |
| "style": { | |
| "text-align": "center", | |
| "border": "2px solid", | |
| "width": "40px", | |
| "height": "40px" | |
| }, | |
| "attributes": { | |
| "class": "=if([$Text1] == '' , 'ms-bgColor-white ms-fontColor-neutralTertiaryAlt' , if(substring([$Text1] , 4 , 5) == '' || indexOf(toUpperCase([$Title]) , toUpperCase(substring([$Text1] , 4 , 5))) < 0 , 'ms-bgColor-neutralSecondaryAlt ms-fontColor-neutralSecondaryAlt' , if(toUpperCase(substring([$Title] , 4 , 5)) == toUpperCase(substring([$Text1] , 4 , 5)) , 'ms-bgColor-sharedGreenCyan10 ms-fontColor-sharedGreenCyan10' , 'ms-bgColor-sharedOrangeYellow10 ms-fontColor-sharedOrangeYellow10') ) )" | |
| }, | |
| "children": [ | |
| { | |
| "elmType": "span", | |
| "txtContent": "=toUpperCase(substring([$Text1] , 4 , 5))", | |
| "attributes": { | |
| "class": "ms-fontColor-white" | |
| } | |
| } | |
| ] | |
| } | |
| ] | |
| }, | |
| { | |
| "elmType": "div", | |
| "inlineEditField": "[$Text2]", | |
| "style": { | |
| "display": "flex", | |
| "flex-direction": "row", | |
| "justify-content": "space-around", | |
| "width": "90%", | |
| "padding": "5px" | |
| }, | |
| "children": [ | |
| { | |
| "elmType": "div", | |
| "style": { | |
| "text-align": "center", | |
| "border": "2px solid", | |
| "width": "40px", | |
| "height": "40px" | |
| }, | |
| "attributes": { | |
| "class": "=if([$Text2] == '' , 'ms-bgColor-white ms-fontColor-neutralTertiaryAlt' , if(substring([$Text2] , 0 , 1) == '' || indexOf(toUpperCase([$Title]) , toUpperCase(substring([$Text2] , 0 , 1))) < 0 , 'ms-bgColor-neutralSecondaryAlt ms-fontColor-neutralSecondaryAlt' , if(toUpperCase(substring([$Title] , 0 , 1)) == toUpperCase(substring([$Text2] , 0 , 1)) , 'ms-bgColor-sharedGreenCyan10 ms-fontColor-sharedGreenCyan10' , 'ms-bgColor-sharedOrangeYellow10 ms-fontColor-sharedOrangeYellow10') ) )" | |
| }, | |
| "children": [ | |
| { | |
| "elmType": "span", | |
| "txtContent": "=toUpperCase(substring([$Text2] , 0 , 1))", | |
| "attributes": { | |
| "class": "ms-fontColor-white" | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "elmType": "div", | |
| "style": { | |
| "text-align": "center", | |
| "border": "2px solid", | |
| "width": "40px", | |
| "height": "40px" | |
| }, | |
| "attributes": { | |
| "class": "=if([$Text2] == '' , 'ms-bgColor-white ms-fontColor-neutralTertiaryAlt' , if(substring([$Text2] , 1 , 2) == '' || indexOf(toUpperCase([$Title]) , toUpperCase(substring([$Text2] , 1 , 2))) < 0 , 'ms-bgColor-neutralSecondaryAlt ms-fontColor-neutralSecondaryAlt' , if(toUpperCase(substring([$Title] , 1 , 2)) == toUpperCase(substring([$Text2] , 1 , 2)) , 'ms-bgColor-sharedGreenCyan10 ms-fontColor-sharedGreenCyan10' , 'ms-bgColor-sharedOrangeYellow10 ms-fontColor-sharedOrangeYellow10') ) )" | |
| }, | |
| "children": [ | |
| { | |
| "elmType": "span", | |
| "txtContent": "=toUpperCase(substring([$Text2] , 1 , 2))", | |
| "attributes": { | |
| "class": "ms-fontColor-white" | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "elmType": "div", | |
| "style": { | |
| "text-align": "center", | |
| "border": "2px solid", | |
| "width": "40px", | |
| "height": "40px" | |
| }, | |
| "attributes": { | |
| "class": "=if([$Text2] == '' , 'ms-bgColor-white ms-fontColor-neutralTertiaryAlt' , if(substring([$Text2] , 2 , 3) == '' || indexOf(toUpperCase([$Title]) , toUpperCase(substring([$Text2] , 2 , 3))) < 0 , 'ms-bgColor-neutralSecondaryAlt ms-fontColor-neutralSecondaryAlt' , if(toUpperCase(substring([$Title] , 2 , 3)) == toUpperCase(substring([$Text2] , 2 , 3)) , 'ms-bgColor-sharedGreenCyan10 ms-fontColor-sharedGreenCyan10' , 'ms-bgColor-sharedOrangeYellow10 ms-fontColor-sharedOrangeYellow10') ) )" | |
| }, | |
| "children": [ | |
| { | |
| "elmType": "span", | |
| "txtContent": "=toUpperCase(substring([$Text2] , 2 , 3))", | |
| "attributes": { | |
| "class": "ms-fontColor-white" | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "elmType": "div", | |
| "style": { | |
| "text-align": "center", | |
| "border": "2px solid", | |
| "width": "40px", | |
| "height": "40px" | |
| }, | |
| "attributes": { | |
| "class": "=if([$Text2] == '' , 'ms-bgColor-white ms-fontColor-neutralTertiaryAlt' , if(substring([$Text2] , 3 , 4) == '' || indexOf(toUpperCase([$Title]) , toUpperCase(substring([$Text2] , 3 , 4))) < 0 , 'ms-bgColor-neutralSecondaryAlt ms-fontColor-neutralSecondaryAlt' , if(toUpperCase(substring([$Title] , 3 , 4)) == toUpperCase(substring([$Text2] , 3 , 4)) , 'ms-bgColor-sharedGreenCyan10 ms-fontColor-sharedGreenCyan10' , 'ms-bgColor-sharedOrangeYellow10 ms-fontColor-sharedOrangeYellow10') ) )" | |
| }, | |
| "children": [ | |
| { | |
| "elmType": "span", | |
| "txtContent": "=toUpperCase(substring([$Text2] , 3 , 4))", | |
| "attributes": { | |
| "class": "ms-fontColor-white" | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "elmType": "div", | |
| "style": { | |
| "text-align": "center", | |
| "border": "2px solid", | |
| "width": "40px", | |
| "height": "40px" | |
| }, | |
| "attributes": { | |
| "class": "=if([$Text2] == '' , 'ms-bgColor-white ms-fontColor-neutralTertiaryAlt' , if(substring([$Text2] , 4 , 5) == '' || indexOf(toUpperCase([$Title]) , toUpperCase(substring([$Text2] , 4 , 5))) < 0 , 'ms-bgColor-neutralSecondaryAlt ms-fontColor-neutralSecondaryAlt' , if(toUpperCase(substring([$Title] , 4 , 5)) == toUpperCase(substring([$Text2] , 4 , 5)) , 'ms-bgColor-sharedGreenCyan10 ms-fontColor-sharedGreenCyan10' , 'ms-bgColor-sharedOrangeYellow10 ms-fontColor-sharedOrangeYellow10') ) )" | |
| }, | |
| "children": [ | |
| { | |
| "elmType": "span", | |
| "txtContent": "=toUpperCase(substring([$Text2] , 4 , 5))", | |
| "attributes": { | |
| "class": "ms-fontColor-white" | |
| } | |
| } | |
| ] | |
| } | |
| ] | |
| }, | |
| { | |
| "elmType": "div", | |
| "inlineEditField": "[$Text3]", | |
| "style": { | |
| "display": "flex", | |
| "flex-direction": "row", | |
| "justify-content": "space-around", | |
| "width": "90%", | |
| "padding": "5px" | |
| }, | |
| "children": [ | |
| { | |
| "elmType": "div", | |
| "style": { | |
| "text-align": "center", | |
| "border": "2px solid", | |
| "width": "40px", | |
| "height": "40px" | |
| }, | |
| "attributes": { | |
| "class": "=if([$Text3] == '' , 'ms-bgColor-white ms-fontColor-neutralTertiaryAlt' , if(substring([$Text3] , 0 , 1) == '' || indexOf(toUpperCase([$Title]) , toUpperCase(substring([$Text3] , 0 , 1))) < 0 , 'ms-bgColor-neutralSecondaryAlt ms-fontColor-neutralSecondaryAlt' , if(toUpperCase(substring([$Title] , 0 , 1)) == toUpperCase(substring([$Text3] , 0 , 1)) , 'ms-bgColor-sharedGreenCyan10 ms-fontColor-sharedGreenCyan10' , 'ms-bgColor-sharedOrangeYellow10 ms-fontColor-sharedOrangeYellow10') ) )" | |
| }, | |
| "children": [ | |
| { | |
| "elmType": "span", | |
| "txtContent": "=toUpperCase(substring([$Text3] , 0 , 1))", | |
| "attributes": { | |
| "class": "ms-fontColor-white" | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "elmType": "div", | |
| "style": { | |
| "text-align": "center", | |
| "border": "2px solid", | |
| "width": "40px", | |
| "height": "40px" | |
| }, | |
| "attributes": { | |
| "class": "=if([$Text3] == '' , 'ms-bgColor-white ms-fontColor-neutralTertiaryAlt' , if(substring([$Text3] , 1 , 2) == '' || indexOf(toUpperCase([$Title]) , toUpperCase(substring([$Text3] , 1 , 2))) < 0 , 'ms-bgColor-neutralSecondaryAlt ms-fontColor-neutralSecondaryAlt' , if(toUpperCase(substring([$Title] , 1 , 2)) == toUpperCase(substring([$Text3] , 1 , 2)) , 'ms-bgColor-sharedGreenCyan10 ms-fontColor-sharedGreenCyan10' , 'ms-bgColor-sharedOrangeYellow10 ms-fontColor-sharedOrangeYellow10') ) )" | |
| }, | |
| "children": [ | |
| { | |
| "elmType": "span", | |
| "txtContent": "=toUpperCase(substring([$Text3] , 1 , 2))", | |
| "attributes": { | |
| "class": "ms-fontColor-white" | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "elmType": "div", | |
| "style": { | |
| "text-align": "center", | |
| "border": "2px solid", | |
| "width": "40px", | |
| "height": "40px" | |
| }, | |
| "attributes": { | |
| "class": "=if([$Text3] == '' , 'ms-bgColor-white ms-fontColor-neutralTertiaryAlt' , if(substring([$Text3] , 2 , 3) == '' || indexOf(toUpperCase([$Title]) , toUpperCase(substring([$Text3] , 2 , 3))) < 0 , 'ms-bgColor-neutralSecondaryAlt ms-fontColor-neutralSecondaryAlt' , if(toUpperCase(substring([$Title] , 2 , 3)) == toUpperCase(substring([$Text3] , 2 , 3)) , 'ms-bgColor-sharedGreenCyan10 ms-fontColor-sharedGreenCyan10' , 'ms-bgColor-sharedOrangeYellow10 ms-fontColor-sharedOrangeYellow10') ) )" | |
| }, | |
| "children": [ | |
| { | |
| "elmType": "span", | |
| "txtContent": "=toUpperCase(substring([$Text3] , 2 , 3))", | |
| "attributes": { | |
| "class": "ms-fontColor-white" | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "elmType": "div", | |
| "style": { | |
| "text-align": "center", | |
| "border": "2px solid", | |
| "width": "40px", | |
| "height": "40px" | |
| }, | |
| "attributes": { | |
| "class": "=if([$Text3] == '' , 'ms-bgColor-white ms-fontColor-neutralTertiaryAlt' , if(substring([$Text3] , 3 , 4) == '' || indexOf(toUpperCase([$Title]) , toUpperCase(substring([$Text3] , 3 , 4))) < 0 , 'ms-bgColor-neutralSecondaryAlt ms-fontColor-neutralSecondaryAlt' , if(toUpperCase(substring([$Title] , 3 , 4)) == toUpperCase(substring([$Text3] , 3 , 4)) , 'ms-bgColor-sharedGreenCyan10 ms-fontColor-sharedGreenCyan10' , 'ms-bgColor-sharedOrangeYellow10 ms-fontColor-sharedOrangeYellow10') ) )" | |
| }, | |
| "children": [ | |
| { | |
| "elmType": "span", | |
| "txtContent": "=toUpperCase(substring([$Text3] , 3 , 4))", | |
| "attributes": { | |
| "class": "ms-fontColor-white" | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "elmType": "div", | |
| "style": { | |
| "text-align": "center", | |
| "border": "2px solid", | |
| "width": "40px", | |
| "height": "40px" | |
| }, | |
| "attributes": { | |
| "class": "=if([$Text3] == '' , 'ms-bgColor-white ms-fontColor-neutralTertiaryAlt' , if(substring([$Text3] , 4 , 5) == '' || indexOf(toUpperCase([$Title]) , toUpperCase(substring([$Text3] , 4 , 5))) < 0 , 'ms-bgColor-neutralSecondaryAlt ms-fontColor-neutralSecondaryAlt' , if(toUpperCase(substring([$Title] , 4 , 5)) == toUpperCase(substring([$Text3] , 4 , 5)) , 'ms-bgColor-sharedGreenCyan10 ms-fontColor-sharedGreenCyan10' , 'ms-bgColor-sharedOrangeYellow10 ms-fontColor-sharedOrangeYellow10') ) )" | |
| }, | |
| "children": [ | |
| { | |
| "elmType": "span", | |
| "txtContent": "=toUpperCase(substring([$Text3] , 4 , 5))", | |
| "attributes": { | |
| "class": "ms-fontColor-white" | |
| } | |
| } | |
| ] | |
| } | |
| ] | |
| }, | |
| { | |
| "elmType": "div", | |
| "inlineEditField": "[$Text4]", | |
| "style": { | |
| "display": "flex", | |
| "flex-direction": "row", | |
| "justify-content": "space-around", | |
| "width": "90%", | |
| "padding": "5px" | |
| }, | |
| "children": [ | |
| { | |
| "elmType": "div", | |
| "style": { | |
| "text-align": "center", | |
| "border": "2px solid", | |
| "width": "40px", | |
| "height": "40px" | |
| }, | |
| "attributes": { | |
| "class": "=if([$Text4] == '' , 'ms-bgColor-white ms-fontColor-neutralTertiaryAlt' , if(substring([$Text4] , 0 , 1) == '' || indexOf(toUpperCase([$Title]) , toUpperCase(substring([$Text4] , 0 , 1))) < 0 , 'ms-bgColor-neutralSecondaryAlt ms-fontColor-neutralSecondaryAlt' , if(toUpperCase(substring([$Title] , 0 , 1)) == toUpperCase(substring([$Text4] , 0 , 1)) , 'ms-bgColor-sharedGreenCyan10 ms-fontColor-sharedGreenCyan10' , 'ms-bgColor-sharedOrangeYellow10 ms-fontColor-sharedOrangeYellow10') ) )" | |
| }, | |
| "children": [ | |
| { | |
| "elmType": "span", | |
| "txtContent": "=toUpperCase(substring([$Text4] , 0 , 1))", | |
| "attributes": { | |
| "class": "ms-fontColor-white" | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "elmType": "div", | |
| "style": { | |
| "text-align": "center", | |
| "border": "2px solid", | |
| "width": "40px", | |
| "height": "40px" | |
| }, | |
| "attributes": { | |
| "class": "=if([$Text4] == '' , 'ms-bgColor-white ms-fontColor-neutralTertiaryAlt' , if(substring([$Text4] , 1 , 2) == '' || indexOf(toUpperCase([$Title]) , toUpperCase(substring([$Text4] , 1 , 2))) < 0 , 'ms-bgColor-neutralSecondaryAlt ms-fontColor-neutralSecondaryAlt' , if(toUpperCase(substring([$Title] , 1 , 2)) == toUpperCase(substring([$Text4] , 1 , 2)) , 'ms-bgColor-sharedGreenCyan10 ms-fontColor-sharedGreenCyan10' , 'ms-bgColor-sharedOrangeYellow10 ms-fontColor-sharedOrangeYellow10') ) )" | |
| }, | |
| "children": [ | |
| { | |
| "elmType": "span", | |
| "txtContent": "=toUpperCase(substring([$Text4] , 1 , 2))", | |
| "attributes": { | |
| "class": "ms-fontColor-white" | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "elmType": "div", | |
| "style": { | |
| "text-align": "center", | |
| "border": "2px solid", | |
| "width": "40px", | |
| "height": "40px" | |
| }, | |
| "attributes": { | |
| "class": "=if([$Text4] == '' , 'ms-bgColor-white ms-fontColor-neutralTertiaryAlt' , if(substring([$Text4] , 2 , 3) == '' || indexOf(toUpperCase([$Title]) , toUpperCase(substring([$Text4] , 2 , 3))) < 0 , 'ms-bgColor-neutralSecondaryAlt ms-fontColor-neutralSecondaryAlt' , if(toUpperCase(substring([$Title] , 2 , 3)) == toUpperCase(substring([$Text4] , 2 , 3)) , 'ms-bgColor-sharedGreenCyan10 ms-fontColor-sharedGreenCyan10' , 'ms-bgColor-sharedOrangeYellow10 ms-fontColor-sharedOrangeYellow10') ) )" | |
| }, | |
| "children": [ | |
| { | |
| "elmType": "span", | |
| "txtContent": "=toUpperCase(substring([$Text4] , 2 , 3))", | |
| "attributes": { | |
| "class": "ms-fontColor-white" | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "elmType": "div", | |
| "style": { | |
| "text-align": "center", | |
| "border": "2px solid", | |
| "width": "40px", | |
| "height": "40px" | |
| }, | |
| "attributes": { | |
| "class": "=if([$Text4] == '' , 'ms-bgColor-white ms-fontColor-neutralTertiaryAlt' , if(substring([$Text4] , 3 , 4) == '' || indexOf(toUpperCase([$Title]) , toUpperCase(substring([$Text4] , 3 , 4))) < 0 , 'ms-bgColor-neutralSecondaryAlt ms-fontColor-neutralSecondaryAlt' , if(toUpperCase(substring([$Title] , 3 , 4)) == toUpperCase(substring([$Text4] , 3 , 4)) , 'ms-bgColor-sharedGreenCyan10 ms-fontColor-sharedGreenCyan10' , 'ms-bgColor-sharedOrangeYellow10 ms-fontColor-sharedOrangeYellow10') ) )" | |
| }, | |
| "children": [ | |
| { | |
| "elmType": "span", | |
| "txtContent": "=toUpperCase(substring([$Text4] , 3 , 4))", | |
| "attributes": { | |
| "class": "ms-fontColor-white" | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "elmType": "div", | |
| "style": { | |
| "text-align": "center", | |
| "border": "2px solid", | |
| "width": "40px", | |
| "height": "40px" | |
| }, | |
| "attributes": { | |
| "class": "=if([$Text4] == '' , 'ms-bgColor-white ms-fontColor-neutralTertiaryAlt' , if(substring([$Text4] , 4 , 5) == '' || indexOf(toUpperCase([$Title]) , toUpperCase(substring([$Text4] , 4 , 5))) < 0 , 'ms-bgColor-neutralSecondaryAlt ms-fontColor-neutralSecondaryAlt' , if(toUpperCase(substring([$Title] , 4 , 5)) == toUpperCase(substring([$Text4] , 4 , 5)) , 'ms-bgColor-sharedGreenCyan10 ms-fontColor-sharedGreenCyan10' , 'ms-bgColor-sharedOrangeYellow10 ms-fontColor-sharedOrangeYellow10') ) )" | |
| }, | |
| "children": [ | |
| { | |
| "elmType": "span", | |
| "txtContent": "=toUpperCase(substring([$Text4] , 4 , 5))", | |
| "attributes": { | |
| "class": "ms-fontColor-white" | |
| } | |
| } | |
| ] | |
| } | |
| ] | |
| }, | |
| { | |
| "elmType": "div", | |
| "inlineEditField": "[$Text5]", | |
| "style": { | |
| "display": "flex", | |
| "flex-direction": "row", | |
| "justify-content": "space-around", | |
| "width": "90%", | |
| "padding": "5px" | |
| }, | |
| "children": [ | |
| { | |
| "elmType": "div", | |
| "style": { | |
| "text-align": "center", | |
| "border": "2px solid", | |
| "width": "40px", | |
| "height": "40px" | |
| }, | |
| "attributes": { | |
| "class": "=if([$Text5] == '' , 'ms-bgColor-white ms-fontColor-neutralTertiaryAlt' , if(substring([$Text5] , 0 , 1) == '' || indexOf(toUpperCase([$Title]) , toUpperCase(substring([$Text5] , 0 , 1))) < 0 , 'ms-bgColor-neutralSecondaryAlt ms-fontColor-neutralSecondaryAlt' , if(toUpperCase(substring([$Title] , 0 , 1)) == toUpperCase(substring([$Text5] , 0 , 1)) , 'ms-bgColor-sharedGreenCyan10 ms-fontColor-sharedGreenCyan10' , 'ms-bgColor-sharedOrangeYellow10 ms-fontColor-sharedOrangeYellow10') ) )" | |
| }, | |
| "children": [ | |
| { | |
| "elmType": "span", | |
| "txtContent": "=toUpperCase(substring([$Text5] , 0 , 1))", | |
| "attributes": { | |
| "class": "ms-fontColor-white" | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "elmType": "div", | |
| "style": { | |
| "text-align": "center", | |
| "border": "2px solid", | |
| "width": "40px", | |
| "height": "40px" | |
| }, | |
| "attributes": { | |
| "class": "=if([$Text5] == '' , 'ms-bgColor-white ms-fontColor-neutralTertiaryAlt' , if(substring([$Text5] , 1 , 2) == '' || indexOf(toUpperCase([$Title]) , toUpperCase(substring([$Text5] , 1 , 2))) < 0 , 'ms-bgColor-neutralSecondaryAlt ms-fontColor-neutralSecondaryAlt' , if(toUpperCase(substring([$Title] , 1 , 2)) == toUpperCase(substring([$Text5] , 1 , 2)) , 'ms-bgColor-sharedGreenCyan10 ms-fontColor-sharedGreenCyan10' , 'ms-bgColor-sharedOrangeYellow10 ms-fontColor-sharedOrangeYellow10') ) )" | |
| }, | |
| "children": [ | |
| { | |
| "elmType": "span", | |
| "txtContent": "=toUpperCase(substring([$Text5] , 1 , 2))", | |
| "attributes": { | |
| "class": "ms-fontColor-white" | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "elmType": "div", | |
| "style": { | |
| "text-align": "center", | |
| "border": "2px solid", | |
| "width": "40px", | |
| "height": "40px" | |
| }, | |
| "attributes": { | |
| "class": "=if([$Text5] == '' , 'ms-bgColor-white ms-fontColor-neutralTertiaryAlt' , if(substring([$Text5] , 2 , 3) == '' || indexOf(toUpperCase([$Title]) , toUpperCase(substring([$Text5] , 2 , 3))) < 0 , 'ms-bgColor-neutralSecondaryAlt ms-fontColor-neutralSecondaryAlt' , if(toUpperCase(substring([$Title] , 2 , 3)) == toUpperCase(substring([$Text5] , 2 , 3)) , 'ms-bgColor-sharedGreenCyan10 ms-fontColor-sharedGreenCyan10' , 'ms-bgColor-sharedOrangeYellow10 ms-fontColor-sharedOrangeYellow10') ) )" | |
| }, | |
| "children": [ | |
| { | |
| "elmType": "span", | |
| "txtContent": "=toUpperCase(substring([$Text5] , 2 , 3))", | |
| "attributes": { | |
| "class": "ms-fontColor-white" | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "elmType": "div", | |
| "style": { | |
| "text-align": "center", | |
| "border": "2px solid", | |
| "width": "40px", | |
| "height": "40px" | |
| }, | |
| "attributes": { | |
| "class": "=if([$Text5] == '' , 'ms-bgColor-white ms-fontColor-neutralTertiaryAlt' , if(substring([$Text5] , 3 , 4) == '' || indexOf(toUpperCase([$Title]) , toUpperCase(substring([$Text5] , 3 , 4))) < 0 , 'ms-bgColor-neutralSecondaryAlt ms-fontColor-neutralSecondaryAlt' , if(toUpperCase(substring([$Title] , 3 , 4)) == toUpperCase(substring([$Text5] , 3 , 4)) , 'ms-bgColor-sharedGreenCyan10 ms-fontColor-sharedGreenCyan10' , 'ms-bgColor-sharedOrangeYellow10 ms-fontColor-sharedOrangeYellow10') ) )" | |
| }, | |
| "children": [ | |
| { | |
| "elmType": "span", | |
| "txtContent": "=toUpperCase(substring([$Text5] , 3 , 4))", | |
| "attributes": { | |
| "class": "ms-fontColor-white" | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "elmType": "div", | |
| "style": { | |
| "text-align": "center", | |
| "border": "2px solid", | |
| "width": "40px", | |
| "height": "40px" | |
| }, | |
| "attributes": { | |
| "class": "=if([$Text5] == '' , 'ms-bgColor-white ms-fontColor-neutralTertiaryAlt' , if(substring([$Text5] , 4 , 5) == '' || indexOf(toUpperCase([$Title]) , toUpperCase(substring([$Text5] , 4 , 5))) < 0 , 'ms-bgColor-neutralSecondaryAlt ms-fontColor-neutralSecondaryAlt' , if(toUpperCase(substring([$Title] , 4 , 5)) == toUpperCase(substring([$Text5] , 4 , 5)) , 'ms-bgColor-sharedGreenCyan10 ms-fontColor-sharedGreenCyan10' , 'ms-bgColor-sharedOrangeYellow10 ms-fontColor-sharedOrangeYellow10') ) )" | |
| }, | |
| "children": [ | |
| { | |
| "elmType": "span", | |
| "txtContent": "=toUpperCase(substring([$Text5] , 4 , 5))", | |
| "attributes": { | |
| "class": "ms-fontColor-white" | |
| } | |
| } | |
| ] | |
| } | |
| ] | |
| }, | |
| { | |
| "elmType": "div", | |
| "inlineEditField": "[$Text6]", | |
| "style": { | |
| "display": "flex", | |
| "flex-direction": "row", | |
| "justify-content": "space-around", | |
| "width": "90%", | |
| "padding": "5px" | |
| }, | |
| "children": [ | |
| { | |
| "elmType": "div", | |
| "style": { | |
| "text-align": "center", | |
| "border": "2px solid", | |
| "width": "40px", | |
| "height": "40px" | |
| }, | |
| "attributes": { | |
| "class": "=if([$Text6] == '' , 'ms-bgColor-white ms-fontColor-neutralTertiaryAlt' , if(substring([$Text6] , 0 , 1) == '' || indexOf(toUpperCase([$Title]) , toUpperCase(substring([$Text6] , 0 , 1))) < 0 , 'ms-bgColor-neutralSecondaryAlt ms-fontColor-neutralSecondaryAlt' , if(toUpperCase(substring([$Title] , 0 , 1)) == toUpperCase(substring([$Text6] , 0 , 1)) , 'ms-bgColor-sharedGreenCyan10 ms-fontColor-sharedGreenCyan10' , 'ms-bgColor-sharedOrangeYellow10 ms-fontColor-sharedOrangeYellow10') ) )" | |
| }, | |
| "children": [ | |
| { | |
| "elmType": "span", | |
| "txtContent": "=toUpperCase(substring([$Text6] , 0 , 1))", | |
| "attributes": { | |
| "class": "ms-fontColor-white" | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "elmType": "div", | |
| "style": { | |
| "text-align": "center", | |
| "border": "2px solid", | |
| "width": "40px", | |
| "height": "40px" | |
| }, | |
| "attributes": { | |
| "class": "=if([$Text6] == '' , 'ms-bgColor-white ms-fontColor-neutralTertiaryAlt' , if(substring([$Text6] , 1 , 2) == '' || indexOf(toUpperCase([$Title]) , toUpperCase(substring([$Text6] , 1 , 2))) < 0 , 'ms-bgColor-neutralSecondaryAlt ms-fontColor-neutralSecondaryAlt' , if(toUpperCase(substring([$Title] , 1 , 2)) == toUpperCase(substring([$Text6] , 1 , 2)) , 'ms-bgColor-sharedGreenCyan10 ms-fontColor-sharedGreenCyan10' , 'ms-bgColor-sharedOrangeYellow10 ms-fontColor-sharedOrangeYellow10') ) )" | |
| }, | |
| "children": [ | |
| { | |
| "elmType": "span", | |
| "txtContent": "=toUpperCase(substring([$Text6] , 1 , 2))", | |
| "attributes": { | |
| "class": "ms-fontColor-white" | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "elmType": "div", | |
| "style": { | |
| "text-align": "center", | |
| "border": "2px solid", | |
| "width": "40px", | |
| "height": "40px" | |
| }, | |
| "attributes": { | |
| "class": "=if([$Text6] == '' , 'ms-bgColor-white ms-fontColor-neutralTertiaryAlt' , if(substring([$Text6] , 2 , 3) == '' || indexOf(toUpperCase([$Title]) , toUpperCase(substring([$Text6] , 2 , 3))) < 0 , 'ms-bgColor-neutralSecondaryAlt ms-fontColor-neutralSecondaryAlt' , if(toUpperCase(substring([$Title] , 2 , 3)) == toUpperCase(substring([$Text6] , 2 , 3)) , 'ms-bgColor-sharedGreenCyan10 ms-fontColor-sharedGreenCyan10' , 'ms-bgColor-sharedOrangeYellow10 ms-fontColor-sharedOrangeYellow10') ) )" | |
| }, | |
| "children": [ | |
| { | |
| "elmType": "span", | |
| "txtContent": "=toUpperCase(substring([$Text6] , 2 , 3))", | |
| "attributes": { | |
| "class": "ms-fontColor-white" | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "elmType": "div", | |
| "style": { | |
| "text-align": "center", | |
| "border": "2px solid", | |
| "width": "40px", | |
| "height": "40px" | |
| }, | |
| "attributes": { | |
| "class": "=if([$Text6] == '' , 'ms-bgColor-white ms-fontColor-neutralTertiaryAlt' , if(substring([$Text6] , 3 , 4) == '' || indexOf(toUpperCase([$Title]) , toUpperCase(substring([$Text6] , 3 , 4))) < 0 , 'ms-bgColor-neutralSecondaryAlt ms-fontColor-neutralSecondaryAlt' , if(toUpperCase(substring([$Title] , 3 , 4)) == toUpperCase(substring([$Text6] , 3 , 4)) , 'ms-bgColor-sharedGreenCyan10 ms-fontColor-sharedGreenCyan10' , 'ms-bgColor-sharedOrangeYellow10 ms-fontColor-sharedOrangeYellow10') ) )" | |
| }, | |
| "children": [ | |
| { | |
| "elmType": "span", | |
| "txtContent": "=toUpperCase(substring([$Text6] , 3 , 4))", | |
| "attributes": { | |
| "class": "ms-fontColor-white" | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "elmType": "div", | |
| "style": { | |
| "text-align": "center", | |
| "border": "2px solid", | |
| "width": "40px", | |
| "height": "40px" | |
| }, | |
| "attributes": { | |
| "class": "=if([$Text6] == '' , 'ms-bgColor-white ms-fontColor-neutralTertiaryAlt' , if(substring([$Text6] , 4 , 5) == '' || indexOf(toUpperCase([$Title]) , toUpperCase(substring([$Text6] , 4 , 5))) < 0 , 'ms-bgColor-neutralSecondaryAlt ms-fontColor-neutralSecondaryAlt' , if(toUpperCase(substring([$Title] , 4 , 5)) == toUpperCase(substring([$Text6] , 4 , 5)) , 'ms-bgColor-sharedGreenCyan10 ms-fontColor-sharedGreenCyan10' , 'ms-bgColor-sharedOrangeYellow10 ms-fontColor-sharedOrangeYellow10') ) )" | |
| }, | |
| "children": [ | |
| { | |
| "elmType": "span", | |
| "txtContent": "=toUpperCase(substring([$Text6] , 4 , 5))", | |
| "attributes": { | |
| "class": "ms-fontColor-white" | |
| } | |
| } | |
| ] | |
| } | |
| ] | |
| } | |
| ] | |
| } | |
| ] | |
| } | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment