Latest Contributions by RPGIS

Hi, I noticed that there aren't any options for arcade expressions/attribute rules to update/populate using rasterized features, imagery, or dems and I was wondering if that is something that might be planned for upcoming updates to arcade. For instance, I update a feature layer representing a building that pulls elevation data from a dem and updates either the geometry or the specified field with whatever calculation I need.  This would be incredibly helpful and also helps streamlining similar or more complex workflows. ... View more

Hi, I believe that there might be a potential bug regarding attribute rules and field maps. I have an editable feature service in field maps that has an attribute rule which populates information from a view table of another server sde table. The rule executes fine in pro but it does not execute in field maps. When executing in field maps, I get the following error message: 'Unable to execute attribute rule <name>. Table cannot be found. I have tried toggling "Exclude from application evaluation" to see if that would fix the issue but to no avail. Has anyone else encountered similar issues when working with views created in sde? ... View more

Hi, I was wondering it would be possible to enable advanced editing/modifying of the html properties in the dashboards to enable users to flex the formatting of table designs. Or if it would be possible to implement an Excel like table in Dashboards as to create more intricate designs for the layout of tabular information. I created a calendar using the basic modifiable html that currently exists within dashboards, but it is rather tedious to constantly adjust. This table is also comprised of an arcade expression to get the days and shift values that is then referenced in the table as expression values.   Here is the code that is used below in conjunction with the arcade <table border="1" cellpadding="5" cellspacing="0" style="background-color:#d9e1f2; border-collapse:collapse; width:100%"> <tbody> <tr> <th colspan="14" style="border: 3px solid black; background-color:{expression/W}"><span style="font-size:42px"><span style="color:#ffffff"><strong>{expression/M}</strong></span></span></th> </tr> <tr> <th colspan="2" style="border: 3px solid black;width:Calc(100%/14);background-color:{expression/W}"><span style="font-size:28px"><span style="color:#ffffff"><strong>Sunday</strong></span></span></th> <th colspan="2" style="border: 3px solid black;width:Calc(100%/14);background-color:{expression/W}"><span style="font-size:28px"><span style="color:#ffffff"><strong>Monday</strong></span></span></th> <th colspan="2" style="border: 3px solid black;width:Calc(100%/14);background-color:{expression/W}"><span style="font-size:28px"><span style="color:#ffffff"><strong>Tuesday</strong></span></span></th> <th colspan="2" style="border: 3px solid black;width:Calc(100%/14);background-color:{expression/W}"><span style="font-size:28px"><span style="color:#ffffff"><strong>Wednesday</strong></span></span></th> <th colspan="2" style="border: 3px solid black;width:Calc(100%/14);background-color:{expression/W}"><span style="font-size:28px"><span style="color:#ffffff"><strong>Thursday</strong></span></span></th> <th colspan="2" style="border: 3px solid black;width:Calc(100%/14);background-color:{expression/W}"><span style="font-size:28px"><span style="color:#ffffff"><strong>Friday</strong></span></span></th> <th colspan="2" style="border: 3px solid black;width:Calc(100%/14);background-color:{expression/W}"><span style="font-size:28px"><span style="color:#ffffff"><strong>Saturday</strong></span></span></th> </tr> <tr> <th rowspan="4" style="background-color:{expression/0T}; border-color:black; border-style:solid; border-width:1px; width:Calc(100%/7)"> <p style="text-align:center"><span style="font-size:32px"><strong>{D0}</strong></span></p> </th> <td style="background-color:{expression/0T}"> <p style="text-align:center"><span style="font-size:10"><strong>Inspections</strong></span></p> </td> <td rowspan="4" style="background-color:{expression/1T}; border-color:black; border-style:solid; border-width:1px; width:Calc(100%/7)"> <p style="text-align:center"><span style="font-size:32px"><strong>{D1}</strong></span></p> </td> <td style="background-color:{expression/1T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Inspections</strong></span></p> </td> <td rowspan="4" style="background-color:{expression/2T}; border-color:black; border-style:solid; border-width:1px; width:Calc(100%/7)"> <p style="text-align:center"><span style="font-size:32px"><strong>{D2}</strong></span></p> </td> <td style="background-color:{expression/2T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Inspections</strong></span></p> </td> <td rowspan="4" style="background-color:{expression/3T}; border-color:black; border-style:solid; border-width:1px; width:Calc(100%/7)"> <p style="text-align:center"><span style="font-size:32px"><strong>{D3}</strong></span></p> </td> <td style="background-color:{expression/3T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Inspections</strong></span></p> </td> <td rowspan="4" style="background-color:{expression/4T}; border-color:black; border-style:solid; border-width:1px; width:Calc(100%/7)"> <p style="text-align:center"><span style="font-size:32px"><strong>{D4}</strong></span></p> </td> <td style="background-color:{expression/4T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Inspections</strong></span></p> </td> <td rowspan="4" style="background-color:{expression/5T}; border-color:black; border-style:solid; border-width:1px; width:Calc(100%/7)"> <p style="text-align:center"><span style="font-size:32px"><strong>{D5}</strong></span></p> </td> <td style="background-color:{expression/5T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Inspections</strong></span></p> </td> <td rowspan="4" style="background-color:{expression/6T}; border-color:black; border-style:solid; border-width:1px; width:Calc(100%/7)"> <p style="text-align:center"><span style="font-size:32px"><strong>{D6}</strong></span></p> </td> <td style="background-color:{expression/6T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Inspections</strong></span></p> </td> </tr> <tr> <td></td> <td style="background-color:{expression/0T}; border-color:black; border-style:solid; border-width:1px; width:.25%"> <p style="text-align:center"><strong>{C0}</strong></p> </td> <td style="background-color:{expression/1T}; border-color:black; border-style:solid; border-width:1px"> <p style="text-align:center"><strong>{C1}</strong></p> </td> <td style="background-color:{expression/2T}; border-color:black; border-style:solid; border-width:1px"> <p style="text-align:center"><strong>{C2}</strong></p> </td> <td style="background-color:{expression/3T}; border-color:black; border-style:solid; border-width:1px"> <p style="text-align:center"><strong>{C3}</strong></p> </td> <td style="background-color:{expression/4T}; border-color:black; border-style:solid; border-width:1px"> <p style="text-align:center"><strong>{C4}</strong></p> </td> <td style="background-color:{expression/5T}; border-color:black; border-style:solid; border-width:1px"> <p style="text-align:center"><strong>{C5}</strong></p> </td> <td style="background-color:{expression/6T}; border-color:black; border-style:solid; border-width:1px"> <p style="text-align:center"><strong>{C6}</strong></p> </td> </tr> <tr> <td style="background-color:{expression/0T}; border-color:black; border-style:solid; border-width:1px; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Shift</strong></span></p> </td> <td style="background-color:{expression/1T}; border-color:black; border-style:solid; border-width:1px; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Shift</strong></span></p> </td> <td style="background-color:{expression/2T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Shift</strong></span></p> </td> <td style="background-color:{expression/3T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Shift</strong></span></p> </td> <td style="background-color:{expression/4T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Shift</strong></span></p> </td> <td style="background-color:{expression/5T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Shift</strong></span></p> </td> <td style="background-color:{expression/6T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Shift</strong></span></p> </td> </tr> <tr> <td style="background-color:{expression/0T}; width:.25%"> <p style="text-align:center"><span style="font-size:12"><strong>{expression/0A}</strong></span></p> </td> <td style="background-color:{expression/1T}; width:.25%"> <p style="text-align:center"><span style="font-size:12"><strong>{expression/1A}</strong></span></p> </td> <td style="background-color:{expression/2T}; width:.25%"> <p style="text-align:center"><span style="font-size:12"><strong>{expression/2A}</strong></span></p> </td> <td style="background-color:{expression/3T}; width:.25%"> <p style="text-align:center"><span style="font-size:12"><strong>{expression/3A}</strong></span></p> </td> <td style="background-color:{expression/4T}; width:.25%"> <p style="text-align:center"><span style="font-size:12"><strong>{expression/4A}</strong></span></p> </td> <td style="background-color:{expression/5T}; width:.25%"> <p style="text-align:center"><span style="font-size:12"><strong>{expression/5A}</strong></span></p> </td> <td style="background-color:{expression/6T}; width:.25%"> <p style="text-align:center"><span style="font-size:12"><strong>{expression/6A}</strong></span></p> </td> </tr> <tr> <td rowspan="4" style="background-color:{expression/7T}; border-color:black; border-style:solid; border-width:1px; width:Calc(100%/7)"> <p style="text-align:center"><span style="font-size:32px"><strong>{D7}</strong></span></p> </td> <td style="background-color:{expression/7T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Inspections</strong></span></p> </td> <td rowspan="4" style="background-color:{expression/8T}; border-color:black; border-style:solid; border-width:1px; width:Calc(100%/7)"> <p style="text-align:center"><span style="font-size:32px"><strong>{D8}</strong></span></p> </td> <td style="background-color:{expression/8T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Inspections</strong></span></p> </td> <td rowspan="4" style="background-color:{expression/9T}; border-color:black; border-style:solid; border-width:1px; width:Calc(100%/7)"> <p style="text-align:center"><span style="font-size:32px"><strong>{D9}</strong></span></p> </td> <td style="background-color:{expression/9T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Inspections</strong></span></p> </td> <td rowspan="4" style="background-color:{expression/10T}; border-color:black; border-style:solid; border-width:1px; width:Calc(100%/7)"> <p style="text-align:center"><span style="font-size:32px"><strong>{D10}</strong></span></p> </td> <td style="background-color:{expression/10T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Inspections</strong></span></p> </td> <td rowspan="4" style="background-color:{expression/11T}; border-color:black; border-style:solid; border-width:1px; width:Calc(100%/7)"> <p style="text-align:center"><span style="font-size:32px"><strong>{D11}</strong></span></p> </td> <td style="background-color:{expression/11T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Inspections</strong></span></p> </td> <td rowspan="4" style="background-color:{expression/12T}; border-color:black; border-style:solid; border-width:1px; width:Calc(100%/7)"> <p style="text-align:center"><span style="font-size:32px"><strong>{D12}</strong></span></p> </td> <td style="background-color:{expression/12T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Inspections</strong></span></p> </td> <td rowspan="4" style="background-color:{expression/13T}; border-color:black; border-style:solid; border-width:1px; width:Calc(100%/7)"> <p style="text-align:center"><span style="font-size:32px"><strong>{D13}</strong></span></p> </td> <td style="background-color:{expression/13T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Inspections</strong></span></p> </td> </tr> <tr> <td style="background-color:{expression/7T}; width:.25%"> <p style="text-align:center"><strong>{C7}</strong></p> </td> <td style="background-color:{expression/8T}; width:.25%"> <p style="text-align:center"><strong>{C8}</strong></p> </td> <td style="background-color:{expression/9T}; width:.25%"> <p style="text-align:center"><strong>{C9}</strong></p> </td> <td style="background-color:{expression/10T}; width:.25%"> <p style="text-align:center"><strong>{C10}</strong></p> </td> <td style="background-color:{expression/11T}; width:.25%"> <p style="text-align:center"><strong>{C11}</strong></p> </td> <td style="background-color:{expression/12T}; width:.25%"> <p style="text-align:center"><strong>{C12}</strong></p> </td> <td style="background-color:{expression/13T}; width:.25%"> <p style="text-align:center"><strong>{C13}</strong></p> </td> </tr> <tr> <td style="background-color:{expression/7T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Shift</strong></span></p> </td> <td style="background-color:{expression/8T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Shift</strong></span></p> </td> <td style="background-color:{expression/9T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Shift</strong></span></p> </td> <td style="background-color:{expression/10T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Shift</strong></span></p> </td> <td style="background-color:{expression/11T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Shift</strong></span></p> </td> <td style="background-color:{expression/12T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Shift</strong></span></p> </td> <td style="background-color:{expression/13T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Shift</strong></span></p> </td> </tr> <tr> <td style="background-color:{expression/7T}; width:.25%"> <p style="text-align:center"><span style="font-size:12"><strong>{expression/7A}</strong></span></p> </td> <td style="background-color:{expression/8T}; width:.25%"> <p style="text-align:center"><span style="font-size:12"><strong>{expression/8A}</strong></span></p> </td> <td style="background-color:{expression/9T}; width:.25%"> <p style="text-align:center"><span style="font-size:12"><strong>{expression/9A}</strong></span></p> </td> <td style="background-color:{expression/10T}; width:.25%"> <p style="text-align:center"><span style="font-size:12"><strong>{expression/10A}</strong></span></p> </td> <td style="background-color:{expression/11T}; width:.25%"> <p style="text-align:center"><span style="font-size:12"><strong>{expression/11A}</strong></span></p> </td> <td style="background-color:{expression/12T}; width:.25%"> <p style="text-align:center"><span style="font-size:12"><strong>{expression/12A}</strong></span></p> </td> <td style="background-color:{expression/13T}; width:.25%"> <p style="text-align:center"><span style="font-size:12"><strong>{expression/13A}</strong></span></p> </td> </tr> <tr> <td rowspan="4" style="background-color:{expression/14T}; border-color:black; border-style:solid; border-width:1px; width:Calc(100%/7)"> <p style="text-align:center"><span style="font-size:32px"><strong>{D14}</strong></span></p> </td> <td style="background-color:{expression/14T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Inspections</strong></span></p> </td> <td rowspan="4" style="background-color:{expression/15T}; border-color:black; border-style:solid; border-width:1px; width:Calc(100%/7)"> <p style="text-align:center"><span style="font-size:32px"><strong>{D15}</strong></span></p> </td> <td style="background-color:{expression/15T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Inspections</strong></span></p> </td> <td rowspan="4" style="background-color:{expression/16T}; border-color:black; border-style:solid; border-width:1px; width:Calc(100%/7)"> <p style="text-align:center"><span style="font-size:32px"><strong>{D16}</strong></span></p> </td> <td style="background-color:{expression/16T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Inspections</strong></span></p> </td> <td rowspan="4" style="background-color:{expression/17T}; border-color:black; border-style:solid; border-width:1px; width:Calc(100%/7)"> <p style="text-align:center"><span style="font-size:32px"><strong>{D17}</strong></span></p> </td> <td style="background-color:{expression/17T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Inspections</strong></span></p> </td> <td rowspan="4" style="background-color:{expression/18T}; border-color:black; border-style:solid; border-width:1px; width:Calc(100%/7)"> <p style="text-align:center"><span style="font-size:32px"><strong>{D18}</strong></span></p> </td> <td style="background-color:{expression/18T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Inspections</strong></span></p> </td> <td rowspan="4" style="background-color:{expression/19T}; border-color:black; border-style:solid; border-width:1px; width:Calc(100%/7)"> <p style="text-align:center"><span style="font-size:32px"><strong>{D19}</strong></span></p> </td> <td style="background-color:{expression/19T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Inspections</strong></span></p> </td> <td rowspan="4" style="background-color:{expression/20T}; border-color:black; border-style:solid; border-width:1px; width:Calc(100%/7)"> <p style="text-align:center"><span style="font-size:32px"><strong>{D20}</strong></span></p> </td> <td style="background-color:{expression/20T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Inspections</strong></span></p> </td> </tr> <tr> <td> <p style="text-align:center"><strong>{C14}</strong></p> </td> <td> <p style="text-align:center"><strong>{C15}</strong></p> </td> <td> <p style="text-align:center"><strong>{C16}</strong></p> </td> <td> <p style="text-align:center"><strong>{C17}</strong></p> </td> <td> <p style="text-align:center"><strong>{C18}</strong></p> </td> <td> <p style="text-align:center"><strong>{C19}</strong></p> </td> <td> <p style="text-align:center"><strong>{C20}</strong></p> </td> </tr> <tr> <td> <p style="text-align:center"><span style="font-size:10"><strong>Shift</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:10"><strong>Shift</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:10"><strong>Shift</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:10"><strong>Shift</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:10"><strong>Shift</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:10"><strong>Shift</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:10"><strong>Shift</strong></span></p> </td> </tr> <tr> <td> <p style="text-align:center"><span style="font-size:12"><strong>{expression/14A}</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:12"><strong>{expression/15A}</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:12"><strong>{expression/16A}</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:12"><strong>{expression/17A}</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:12"><strong>{expression/18A}</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:12"><strong>{expression/19A}</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:12"><strong>{expression/20A}</strong></span></p> </td> </tr> <tr> <td rowspan="4" style="background-color:{expression/21T}; border-color:black; border-style:solid; border-width:1px; width:Calc(100%/7)"> <p style="text-align:center"><span style="font-size:32px"><strong>{D21}</strong></span></p> </td> <td style="background-color:{expression/21T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Inspections</strong></span></p> </td> <td rowspan="4" style="background-color:{expression/22T}; border-color:black; border-style:solid; border-width:1px; width:Calc(100%/7)"> <p style="text-align:center"><span style="font-size:32px"><strong>{D22}</strong></span></p> </td> <td style="background-color:{expression/22T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Inspections</strong></span></p> </td> <td rowspan="4" style="background-color:{expression/23T}; border-color:black; border-style:solid; border-width:1px; width:Calc(100%/7)"> <p style="text-align:center"><span style="font-size:32px"><strong>{D23}</strong></span></p> </td> <td style="background-color:{expression/23T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Inspections</strong></span></p> </td> <td rowspan="4" style="background-color:{expression/24T}; border-color:black; border-style:solid; border-width:1px; width:Calc(100%/7)"> <p style="text-align:center"><span style="font-size:32px"><strong>{D24}</strong></span></p> </td> <td style="background-color:{expression/24T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Inspections</strong></span></p> </td> <td rowspan="4" style="background-color:{expression/25T}; border-color:black; border-style:solid; border-width:1px; width:Calc(100%/7)"> <p style="text-align:center"><span style="font-size:32px"><strong>{D25}</strong></span></p> </td> <td style="background-color:{expression/25T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Inspections</strong></span></p> </td> <td rowspan="4" style="background-color:{expression/26T}; border-color:black; border-style:solid; border-width:1px; width:Calc(100%/7)"> <p style="text-align:center"><span style="font-size:32px"><strong>{D26}</strong></span></p> </td> <td style="background-color:{expression/26T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Inspections</strong></span></p> </td> <td rowspan="4" style="background-color:{expression/27T}; border-color:black; border-style:solid; border-width:1px; width:Calc(100%/7)"> <p style="text-align:center"><span style="font-size:32px"><strong>{D27}</strong></span></p> </td> <td style="background-color:{expression/27T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Inspections</strong></span></p> </td> </tr> <tr> <td> <p style="text-align:center"><strong>{C21}</strong></p> </td> <td> <p style="text-align:center"><strong>{C22}</strong></p> </td> <td> <p style="text-align:center"><strong>{C23}</strong></p> </td> <td> <p style="text-align:center"><strong>{C24}</strong></p> </td> <td> <p style="text-align:center"><strong>{C25}</strong></p> </td> <td> <p style="text-align:center"><strong>{C26}</strong></p> </td> <td> <p style="text-align:center"><strong>{C27}</strong></p> </td> </tr> <tr> <td> <p style="text-align:center"><span style="font-size:10"><strong>Shift</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:10"><strong>Shift</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:10"><strong>Shift</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:10"><strong>Shift</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:10"><strong>Shift</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:10"><strong>Shift</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:10"><strong>Shift</strong></span></p> </td> </tr> <tr> <td> <p style="text-align:center"><span style="font-size:12"><strong>{expression/21A}</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:12"><strong>{expression/22A}</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:12"><strong>{expression/23A}</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:12"><strong>{expression/24A}</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:12"><strong>{expression/25A}</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:12"><strong>{expression/26A}</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:12"><strong>{expression/27A}</strong></span></p> </td> </tr> <tr> <td rowspan="4" style="background-color:{expression/28T}; border-color:black; border-style:solid; border-width:1px; width:Calc(100%/7)"> <p style="text-align:center"><span style="font-size:32px"><strong>{D28}</strong></span></p> </td> <td style="background-color:{expression/28T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Inspections</strong></span></p> </td> <td rowspan="4" style="background-color:{expression/29T}; border-color:black; border-style:solid; border-width:1px; width:Calc(100%/7)"> <p style="text-align:center"><span style="font-size:32px"><strong>{D29}</strong></span></p> </td> <td style="background-color:{expression/29T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Inspections</strong></span></p> </td> <td rowspan="4" style="background-color:{expression/30T}; border-color:black; border-style:solid; border-width:1px; width:Calc(100%/7)"> <p style="text-align:center"><span style="font-size:32px"><strong>{D30}</strong></span></p> </td> <td style="background-color:{expression/30T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Inspections</strong></span></p> </td> <td rowspan="4" style="background-color:{expression/31T}; border-color:black; border-style:solid; border-width:1px; width:Calc(100%/7)"> <p style="text-align:center"><span style="font-size:32px"><strong>{D31}</strong></span></p> </td> <td style="background-color:{expression/31T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Inspections</strong></span></p> </td> <td rowspan="4" style="background-color:{expression/32T}; border-color:black; border-style:solid; border-width:1px; width:Calc(100%/7)"> <p style="text-align:center"><span style="font-size:32px"><strong>{D32}</strong></span></p> </td> <td style="background-color:{expression/32T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Inspections</strong></span></p> </td> <td rowspan="4" style="background-color:{expression/33T}; border-color:black; border-style:solid; border-width:1px; width:Calc(100%/7)"> <p style="text-align:center"><span style="font-size:32px"><strong>{D33}</strong></span></p> </td> <td style="background-color:{expression/33T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Inspections</strong></span></p> </td> <td rowspan="4" style="background-color:{expression/34T}; border-color:black; border-style:solid; border-width:1px; width:Calc(100%/7)"> <p style="text-align:center"><span style="font-size:32px"><strong>{D34}</strong></span></p> </td> <td style="background-color:{expression/34T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Inspections</strong></span></p> </td> </tr> <tr> <td> <p style="text-align:center"><strong>{C28}</strong></p> </td> <td> <p style="text-align:center"><strong>{C29}</strong></p> </td> <td> <p style="text-align:center"><strong>{C30}</strong></p> </td> <td> <p style="text-align:center"><strong>{C31}</strong></p> </td> <td> <p style="text-align:center"><strong>{C32}</strong></p> </td> <td> <p style="text-align:center"><strong>{C33}</strong></p> </td> <td> <p style="text-align:center"><strong>{C34}</strong></p> </td> </tr> <tr> <td> <p style="text-align:center"><span style="font-size:10"><strong>Shift</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:10"><strong>Shift</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:10"><strong>Shift</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:10"><strong>Shift</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:10"><strong>Shift</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:10"><strong>Shift</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:10"><strong>Shift</strong></span></p> </td> </tr> <tr> <td> <p style="text-align:center"><span style="font-size:12"><strong>{expression/28A}</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:12"><strong>{expression/29A}</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:12"><strong>{expression/30A}</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:12"><strong>{expression/31A}</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:12"><strong>{expression/32A}</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:12"><strong>{expression/33A}</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:12"><strong>{expression/34A}</strong></span></p> </td> </tr> <tr> <td rowspan="4" style="background-color:{expression/35T}; border-color:black; border-style:solid; border-width:1px; width:Calc(100%/7)"> <p style="text-align:center"><span style="font-size:32px"><strong>{D35}</strong></span></p> </td> <td style="background-color:{expression/35T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Inspections</strong></span></p> </td> <td rowspan="4" style="background-color:{expression/36T}; border-color:black; border-style:solid; border-width:1px; width:Calc(100%/7)"> <p style="text-align:center"><span style="font-size:32px"><strong>{D36}</strong></span></p> </td> <td style="background-color:{expression/36T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Inspections</strong></span></p> </td> <td rowspan="4" style="background-color:{expression/37T}; border-color:black; border-style:solid; border-width:1px; width:Calc(100%/7)"> <p style="text-align:center"><span style="font-size:32px"><strong>{D37}</strong></span></p> </td> <td style="background-color:{expression/37T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Inspections</strong></span></p> </td> <td rowspan="4" style="background-color:{expression/38T}; border-color:black; border-style:solid; border-width:1px; width:Calc(100%/7)"> <p style="text-align:center"><span style="font-size:32px"><strong>{D38}</strong></span></p> </td> <td style="background-color:{expression/38T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Inspections</strong></span></p> </td> <td rowspan="4" style="background-color:{expression/39T}; border-color:black; border-style:solid; border-width:1px; width:Calc(100%/7)"> <p style="text-align:center"><span style="font-size:32px"><strong>{D39}</strong></span></p> </td> <td style="background-color:{expression/39T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Inspections</strong></span></p> </td> <td rowspan="4" style="background-color:{expression/40T}; border-color:black; border-style:solid; border-width:1px; width:Calc(100%/7)"> <p style="text-align:center"><span style="font-size:32px"><strong>{D40}</strong></span></p> </td> <td style="background-color:{expression/40T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Inspections</strong></span></p> </td> <td rowspan="4" style="background-color:{expression/41T}; border-color:black; border-style:solid; border-width:1px; width:Calc(100%/7)"> <p style="text-align:center"><span style="font-size:32px"><strong>{D41}</strong></span></p> </td> <td style="background-color:{expression/41T}; width:.25%"> <p style="text-align:center"><span style="font-size:10"><strong>Inspections</strong></span></p> </td> </tr> <tr> <td> <p style="text-align:center"><strong>{C35}</strong></p> </td> <td> <p style="text-align:center"><strong>{C36}</strong></p> </td> <td> <p style="text-align:center"><strong>{C37}</strong></p> </td> <td> <p style="text-align:center"><strong>{C38}</strong></p> </td> <td> <p style="text-align:center"><strong>{C39}</strong></p> </td> <td> <p style="text-align:center"><strong>{C40}</strong></p> </td> <td> <p style="text-align:center"><strong>{C41}</strong></p> </td> </tr> <tr> <td> <p style="text-align:center"><span style="font-size:10"><strong>Shift</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:10"><strong>Shift</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:10"><strong>Shift</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:10"><strong>Shift</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:10"><strong>Shift</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:10"><strong>Shift</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:10"><strong>Shift</strong></span></p> </td> </tr> <tr> <td> <p style="text-align:center"><span style="font-size:12"><strong>{expression/35A}</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:12"><strong>{expression/36A}</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:12"><strong>{expression/37A}</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:12"><strong>{expression/38A}</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:12"><strong>{expression/39A}</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:12"><strong>{expression/40A}</strong></span></p> </td> <td> <p style="text-align:center"><span style="font-size:12"><strong>{expression/41A}</strong></span></p> </td> </tr> </tbody> </table>  Arcade script: var N = TextFormatting.NewLine var T = Today() var Shifts = {'0':'A','1':'B','2':'C'} var NShift = {'A':'B','B':'C','C':'A'} var StartMDay = Date(Year(T),Month(T),1) var LastMDay = DateAdd(StartMDay,1,'Month') LastMDay = DateAdd(LastMDay,-1,'day') var CS = DateAdd(StartMDay,-WeekDay(StartMDay),'day') var CE = DateAdd(LastMDay,6-WeekDay(LastMDay),'day') var S = Shifts[Text(Day(CS)%3)] var Calendar = {} for(var i = 0; i<42;i++){ var CD = DateAdd(CS,i,'day') var A = 'D'+Text(i) Calendar[A] = Text(CD,'D') if(Month(CD)==Month(T)&&Day(CD)==Day(T)){ Calendar[Concatenate(i,'T')]='#6d8fcf' } else if (Month(CD)==Month(T)){ Calendar[Concatenate(i,'T')]='#a8bbe2' } Calendar[Concatenate(i,'A')]=S S=NShift[S] } Calendar['M'] = Text(T,'MMMM Y') Calendar['W'] = '#4472C4' return { textColor: 'Black', backgroundColor: '', separatorColor:'', selectionColor: '', selectionTextColor: '', attributes: Calendar } ... View more

Hi, I have tried to fix the error that keeps occurring with the code that I am using below. I have tried researching and trying to find a solution but all of my attempts have yielded the same result. I would greatly appreciate any help with this arcade expression. function CalendarSE(){ var StartMDay = Date(Year(Today()),Month(Today()),1) var LastMDay = DateAdd(StartMDay,1,'Month') LastMDay = DateAdd(LastMDay,-1,'day') var CS = Date(DateAdd(StartMDay,-WeekDay(StartMDay),'day')) var CE = Date(DateAdd(LastMDay,6-WeekDay(LastMDay),'day')) return {'Start' : CS , 'End':CE } } var CS = CalendarSE()['Start'] var CE = CalendarSE()['End'] var DateField = '<dateField>' var P = Portal('<portal>') var Item = Filter(FeatureSetByPortalItem(P,'<itemID>',0,[DateField],False),DateField + ' Between @cs AND @CE') var DF = 'Y-MM-DD' var Weekdays = { '0':'Sunday', '1':'Monday', '2':'Tuesday', '3':'Wednesday', '4':'Thursday', '5':'Friday', '6':'Saturday' } var CalendarFields = [] for( var i = 0 ; i < 7 ; i++ ){ Push(CalendarFields,{'name': Weekdays[Text(i)] , 'type':'esriFieldTypeDate'}) Push(CalendarFields,{'name': Weekdays[Text(i)]+'Count' , 'type':'esriFieldTypeInteger'}) } Console(CalendarFields) var CalendarTable = { 'fields': CalendarFields, 'geometry' : Null, 'features' : [] } var DCLimit = {} for(var i = 0; i < 43; i++){ var T = DateAdd(CS,i,'days') var CD = DateAdd(T,i+1,'days') var Cnt = Count(Filter(Item, DateField + ' Between @T AND @CD')) var W = Weekdays[Text(i%7)] DCLimit[W] = Date(T) DCLimit[W+'Count']=Cnt if( i % 7 == 6 ){ Push( CalendarTable.features , {'attributes': DCLimit } ) DCLimit = {} } } CalendarTable = Featureset( Text(CalendarTable) ) return CalendarTable Any help on this would be greatly appreciated. I would also like to know if there is a simpler way for write this than what I have now.  ... View more

Hi, I am trying to filter data to the best of my abilities, but I cannot seem to find a way to filter dates to filter the first day of the month, beginning week of the month, first day of the week, specific days (Friday, Saturday,etc.) or even enable arcade filters for specific criteria. The reasoning for this is I am trying to create a dynamic calendar var N = TextFormatting.NewLine var T = Today() var StartMDay = Date(Year(T),Month(T),1) var LastMDay = DateAdd(StartMDay,1,'Month') LastMDay = DateAdd(LastMDay,-1,'day') var CS = DateAdd(StartMDay,-WeekDay(StartMDay),'day') var CE = DateAdd(LastMDay,6-WeekDay(LastMDay),'day') var InspDate = $datapoint.InspectionDate var InspCnt = $datapoint.InspectCount var Calendar = { '0': Day(CS) } for(var i = 1; i<42;i++){ var CD = Day(DateAdd(CS,i,'day')) if(CD==Day(T)){ Calendar[Concatenate(i,'T')]='#92a9db' } Calendar[Text(i)] = CD } Calendar['M'] = Text(T,'MMMM') Calendar['W'] = '#4472C4' return { textColor: 'Black', backgroundColor: '', separatorColor:'', selectionColor: '', selectionTextColor: '', attributes: Calendar } Html/css code <table border="1" cellpadding="12%" cellspacing="1" style="background-color:#4472c4; width:100%"> <tbody> <tr> <td style="text-align:center"><span style="font-size:36px"><span style="color:#ffffff"><strong>{expression/M}</strong></span></span></td> </tr> </tbody> </table> <table border="1" cellpadding="30%" cellspacing="0" style="background-color:#d9e1f2; border-collapse:collapse; width:100%"> <tbody> <tr> <th style="background-color:{expression/W}"><strong>Sunday</strong></th> <th style="background-color:{expression/W}"><strong>Monday</strong></th> <th style="background-color:{expression/W}"><strong>Tuesday</strong></th> <th style="background-color:{expression/W}"><strong>Wednesday</strong></th> <th style="background-color:{expression/W}"><strong>Thursday</strong></th> <th style="background-color:{expression/W}"><strong>Friday</strong></th> <th style="background-color:{expression/W}"><strong>Saurday</strong></th> </tr> </tbody> <tbody> <tr> <td style="background-color:{expression/0T}; text-align:center"> <p><strong>{expression/0}</strong></p> </td> <td style="background-color:{expression/1T}; text-align:center"> <p><strong>{expression/1}</strong></p> </td> <td style="background-color:{expression/2T}; text-align:center"> <p><strong>{expression/2}</strong></p> </td> <td style="background-color:{expression/3T}; text-align:center"> <p><strong>{expression/3}</strong></p> </td> <td style="background-color:{expression/4T}; text-align:center"> <p><strong>{expression/4}</strong></p> </td> <td style="background-color:{expression/5T}; text-align:center"> <p><strong>{expression/5}</strong></p> </td> <td style="background-color:{expression/6T}; text-align:center"> <p><strong>{expression/6}</strong></p> </td> </tr> <tr> <td style="background-color:{expression/7T}; text-align:center"> <p><strong>{expression/7}</strong></p> </td> <td style="background-color:{expression/8T}; text-align:center"> <p><strong>{expression/8}</strong></p> </td> <td style="background-color:{expression/9T}; text-align:center"> <p><strong>{expression/9}</strong></p> </td> <td style="background-color:{expression/10T}; text-align:center"> <p><strong>{expression/10}</strong></p> </td> <td style="background-color:{expression/11T}; text-align:center"> <p><strong>{expression/11}</strong></p> </td> <td style="background-color:{expression/12T}; text-align:center"> <p><strong>{expression/12}</strong></p> </td> <td style="background-color:{expression/3T}; text-align:center"> <p><strong>{expression/13}</strong></p> </td> </tr> <tr> <td style="background-color:{expression/14T}; text-align:center"> <p><strong>{expression/14}</strong></p> </td> <td style="background-color:{expression/15T}; text-align:center"> <p><strong>{expression/15}</strong></p> </td> <td style="background-color:{expression/16T}; text-align:center"> <p><strong>{expression/16}</strong></p> </td> <td style="background-color:{expression/17T}; text-align:center"> <p><strong>{expression/17}</strong></p> </td> <td style="background-color:{expression/18T}; text-align:center"> <p><strong>{expression/18}</strong></p> </td> <td style="background-color:{expression/19T}; text-align:center"> <p><strong>{expression/19}</strong></p> </td> <td style="background-color:{expression/20T}; text-align:center"> <p><strong>{expression/20}</strong></p> </td> </tr> <tr> <td style="background-color:{expression/21T}; text-align:center"> <p><strong>{expression/21}</strong></p> </td> <td style="background-color:{expression/22T}; text-align:center"> <p><strong>{expression/22}</strong></p> </td> <td style="background-color:{expression/23T}; text-align:center"> <p><strong>{expression/23}</strong></p> </td> <td style="background-color:{expression/24T}; text-align:center"> <p><strong>{expression/24}</strong></p> </td> <td style="background-color:{expression/25T}; text-align:center"> <p><strong>{expression/25}</strong></p> </td> <td style="background-color:{expression/26T}; text-align:center"> <p><strong>{expression/26}</strong></p> </td> <td style="background-color:{expression/27T}; text-align:center"> <p><strong>{expression/27}</strong></p> </td> </tr> <tr> <td style="background-color:{expression/28T}; text-align:center"> <p><strong>{expression/28}</strong></p> </td> <td style="background-color:{expression/29T}; text-align:center"> <p><strong>{expression/29}</strong></p> </td> <td style="background-color:{expression/30T}; text-align:center"> <p><strong>{expression/30}</strong></p> </td> <td style="background-color:{expression/31T}; text-align:center"> <p><strong>{expression/31}</strong></p> </td> <td style="background-color:{expression/32T}; text-align:center"> <p><strong>{expression/32}</strong></p> </td> <td style="background-color:{expression/33T}; text-align:center"> <p><strong>{expression/33}</strong></p> </td> <td style="background-color:{expression/34T}; text-align:center"> <p><strong>{expression/34}</strong></p> </td> </tr> <tr> <td style="background-color:{expression/35T}; text-align:center"> <p><strong>{expression/35}</strong></p> </td> <td style="background-color:{expression/36T}; text-align:center"> <p><strong>{expression/36}</strong></p> </td> <td style="background-color:{expression/37T}; text-align:center"> <p><strong>{expression/37}</strong></p> </td> <td style="background-color:{expression/38T}; text-align:center"> <p><strong>{expression/38}</strong></p> </td> <td style="background-color:{expression/39T}; text-align:center"> <p><strong>{expression/39}</strong></p> </td> <td style="background-color:{expression/40T}; text-align:center"> <p><strong>{expression/40}</strong></p> </td> <td style="background-color:{expression/41T}; text-align:center"> <p><strong>{expression/41}</strong></p> </td> </tr> </tbody> </table> I would like for the ability to filter the data as dynamically as possible which would open up a lot more opportunities. ... View more