Thought I'd share a Skuid page I made to help view results of the "Field Trip" app.
Field Trip is a (really useful) free app exchange app that helps admin analyze the usage of fields. https://appexchange.salesforce.com/listingDetail?listingId=a0N30000003HSXEEA4 One drawback is that for objects with many fields you need to copy and paste to excel to really work with the data. Skuid fixes that with sortable columns and a search bar!
If you use this page, the only change you'll need to make is to change the "Field Trip Tab" link in the navigation component to point to the correct link for your org.
**Note: this was built on Skuid version 8.15.8
<skuidpage unsavedchangeswarning="yes" personalizationmode="server" showsidebar="true" showheader="true">
<models>
<model id="AllFieldTrips" limit="20" query="true" createrowifnonefound="false" adapter="salesforce" type="" sobject="Field_Trip__Object_Analysis__c">
<fields>
<field id="Name"/>
<field id="Field_Trip__Object_Name__c"/>
<field id="Id"/>
</fields>
<conditions/>
<actions/>
</model>
<model id="FieldtripObject" limit="20" query="true" createrowifnonefound="false" adapter="salesforce" type="" sobject="Field_Trip__Object_Analysis__c">
<fields>
<field id="Id"/>
<field id="Name"/>
<field id="Field_Trip__Last_Analyzed__c"/>
</fields>
<conditions>
<condition type="fieldvalue" value="a0I1600000zZQJbEAO" enclosevalueinquotes="true" field="Id" state="filterableon" inactive="false" name="Id"/>
</conditions>
<actions/>
</model>
<model id="FieldTripFields" limit="" query="true" createrowifnonefound="false" adapter="salesforce" type="" sobject="Field_Trip__Field_Analysis__c">
<fields>
<field id="Field_Trip__Object_Analysis__c"/>
<field id="Field_Trip__Object_Analysis__r.Name"/>
<field id="Name"/>
<field id="Field_Trip__Label__c"/>
<field id="Field_Trip__Populated_On__c"/>
<field id="Field_Trip__Populated_On_Percent__c"/>
<field id="Field_Trip__Type__c"/>
<field id="Field_Trip__isRequired__c"/>
<field id="Field_Trip__isCustom__c"/>
</fields>
<conditions>
<condition type="modelmerge" value="" field="Field_Trip__Object_Analysis__c" operator="=" model="FieldtripObject" enclosevalueinquotes="true" mergefield="Id" novaluebehavior="noquery"/>
</conditions>
<actions/>
</model>
</models>
<components>
<grid uniqueid="sk-3C5r_3-155" columngutter="20px">
<divisions>
<division behavior="specified" verticalalign="top" width="30em">
<components>
<wrapper uniqueid="sk-3C6mX3-244">
<components>
<navigation uniqueid="sk-3C6yYA-255">
<navigationitems>
<navigationitem label="Field Trip Tab" icon="fa-arrow-circle-right">
<actions>
<action type="redirect" window="blank" url="/a0I/o"/>
</actions>
<renderconditions logictype="and"/>
</navigationitem>
</navigationitems>
</navigation>
</components>
<styles>
<styleitem type="background"/>
<styleitem type="border" padding="bottom,top,">
<styles>
<styleitem property="padding-top" value="10px"/>
<styleitem property="padding-bottom" value="15px"/>
<styleitem property="box-sizing" value="border-box"/>
</styles>
</styleitem>
<styleitem type="size"/>
</styles>
</wrapper>
<queue tagrendertype="template" querystring="id={{Id}}" defaultitemparameter="id" clickactiontype="multi" searchbox="true" tokenizesearch="true" model="AllFieldTrips" uniqueid="sk-3C5z32-175" title="All Field Trips">
<rendertemplate>{{{Name}}}</rendertemplate>
<actions>
<action type="setCondition" model="FieldtripObject" condition="Id" value="{{Id}}"/>
<action type="requeryModel" model="FieldtripObject" behavior="standard"/>
<action type="requeryModel" model="FieldTripFields" behavior="standard"/>
</actions>
</queue>
</components>
</division>
<division behavior="flex" verticalalign="top" minwidth="100px" ratio="1">
<components>
<pagetitle model="FieldtripObject" uniqueid="sk-3C6QqC-231">
<maintitle>
<template>{{Name}}</template>
</maintitle>
<actions/>
<subtitle>Last Analyzed {{Field_Trip__Last_Analyzed__c}}</subtitle>
</pagetitle>
<skootable showconditions="true" showsavecancel="false" showerrorsinline="true" searchmethod="server" searchbox="true" showexportbuttons="false" pagesize="all" createrecords="false" model="FieldTripFields" buttonposition="" mode="readonly" uniqueid="sk-23mmcm-174">
<fields>
<field type="COMBO" valuehalign="">
<label>Field Name</label>
<template>{{{Name}}}</template>
</field>
<field id="Field_Trip__Label__c" valuehalign="" type="" allowordering="true"/>
<field id="Field_Trip__Populated_On__c" decimalplaces="" valuehalign="" type="" allowordering="true"/>
<field id="Field_Trip__Populated_On_Percent__c" decimalplaces="" valuehalign="" type="" allowordering="true"/>
<field id="Field_Trip__isRequired__c" type="" valuehalign="" allowordering="true"/>
<field id="Field_Trip__Type__c" valuehalign="" type="" allowordering="true"/>
<field id="Field_Trip__isCustom__c" type="" valuehalign="" allowordering="true"/>
</fields>
<rowactions/>
<massactions usefirstitemasdefault="true"/>
<views>
<view type="standard"/>
</views>
<searchfields/>
</skootable>
</components>
</division>
</divisions>
<styles>
<styleitem type="background" bgtype="none"/>
<styleitem property="padding-top" value="10px"/>
</styles>
</grid>
</components>
<resources>
<labels/>
<javascript/>
<css>
<cssitem location="inline" name="newcss" cachelocation="false">.nx-skootable>.nx-editor-header{
margin: 0px;
}</cssitem>
</css>
</resources>
<styles>
<styleitem type="background" bgtype="none"/>
</styles>
</skuidpage>
Field Trip is a (really useful) free app exchange app that helps admin analyze the usage of fields. https://appexchange.salesforce.com/listingDetail?listingId=a0N30000003HSXEEA4 One drawback is that for objects with many fields you need to copy and paste to excel to really work with the data. Skuid fixes that with sortable columns and a search bar!
If you use this page, the only change you'll need to make is to change the "Field Trip Tab" link in the navigation component to point to the correct link for your org.
**Note: this was built on Skuid version 8.15.8
<skuidpage unsavedchangeswarning="yes" personalizationmode="server" showsidebar="true" showheader="true">
<models>
<model id="AllFieldTrips" limit="20" query="true" createrowifnonefound="false" adapter="salesforce" type="" sobject="Field_Trip__Object_Analysis__c">
<fields>
<field id="Name"/>
<field id="Field_Trip__Object_Name__c"/>
<field id="Id"/>
</fields>
<conditions/>
<actions/>
</model>
<model id="FieldtripObject" limit="20" query="true" createrowifnonefound="false" adapter="salesforce" type="" sobject="Field_Trip__Object_Analysis__c">
<fields>
<field id="Id"/>
<field id="Name"/>
<field id="Field_Trip__Last_Analyzed__c"/>
</fields>
<conditions>
<condition type="fieldvalue" value="a0I1600000zZQJbEAO" enclosevalueinquotes="true" field="Id" state="filterableon" inactive="false" name="Id"/>
</conditions>
<actions/>
</model>
<model id="FieldTripFields" limit="" query="true" createrowifnonefound="false" adapter="salesforce" type="" sobject="Field_Trip__Field_Analysis__c">
<fields>
<field id="Field_Trip__Object_Analysis__c"/>
<field id="Field_Trip__Object_Analysis__r.Name"/>
<field id="Name"/>
<field id="Field_Trip__Label__c"/>
<field id="Field_Trip__Populated_On__c"/>
<field id="Field_Trip__Populated_On_Percent__c"/>
<field id="Field_Trip__Type__c"/>
<field id="Field_Trip__isRequired__c"/>
<field id="Field_Trip__isCustom__c"/>
</fields>
<conditions>
<condition type="modelmerge" value="" field="Field_Trip__Object_Analysis__c" operator="=" model="FieldtripObject" enclosevalueinquotes="true" mergefield="Id" novaluebehavior="noquery"/>
</conditions>
<actions/>
</model>
</models>
<components>
<grid uniqueid="sk-3C5r_3-155" columngutter="20px">
<divisions>
<division behavior="specified" verticalalign="top" width="30em">
<components>
<wrapper uniqueid="sk-3C6mX3-244">
<components>
<navigation uniqueid="sk-3C6yYA-255">
<navigationitems>
<navigationitem label="Field Trip Tab" icon="fa-arrow-circle-right">
<actions>
<action type="redirect" window="blank" url="/a0I/o"/>
</actions>
<renderconditions logictype="and"/>
</navigationitem>
</navigationitems>
</navigation>
</components>
<styles>
<styleitem type="background"/>
<styleitem type="border" padding="bottom,top,">
<styles>
<styleitem property="padding-top" value="10px"/>
<styleitem property="padding-bottom" value="15px"/>
<styleitem property="box-sizing" value="border-box"/>
</styles>
</styleitem>
<styleitem type="size"/>
</styles>
</wrapper>
<queue tagrendertype="template" querystring="id={{Id}}" defaultitemparameter="id" clickactiontype="multi" searchbox="true" tokenizesearch="true" model="AllFieldTrips" uniqueid="sk-3C5z32-175" title="All Field Trips">
<rendertemplate>{{{Name}}}</rendertemplate>
<actions>
<action type="setCondition" model="FieldtripObject" condition="Id" value="{{Id}}"/>
<action type="requeryModel" model="FieldtripObject" behavior="standard"/>
<action type="requeryModel" model="FieldTripFields" behavior="standard"/>
</actions>
</queue>
</components>
</division>
<division behavior="flex" verticalalign="top" minwidth="100px" ratio="1">
<components>
<pagetitle model="FieldtripObject" uniqueid="sk-3C6QqC-231">
<maintitle>
<template>{{Name}}</template>
</maintitle>
<actions/>
<subtitle>Last Analyzed {{Field_Trip__Last_Analyzed__c}}</subtitle>
</pagetitle>
<skootable showconditions="true" showsavecancel="false" showerrorsinline="true" searchmethod="server" searchbox="true" showexportbuttons="false" pagesize="all" createrecords="false" model="FieldTripFields" buttonposition="" mode="readonly" uniqueid="sk-23mmcm-174">
<fields>
<field type="COMBO" valuehalign="">
<label>Field Name</label>
<template>{{{Name}}}</template>
</field>
<field id="Field_Trip__Label__c" valuehalign="" type="" allowordering="true"/>
<field id="Field_Trip__Populated_On__c" decimalplaces="" valuehalign="" type="" allowordering="true"/>
<field id="Field_Trip__Populated_On_Percent__c" decimalplaces="" valuehalign="" type="" allowordering="true"/>
<field id="Field_Trip__isRequired__c" type="" valuehalign="" allowordering="true"/>
<field id="Field_Trip__Type__c" valuehalign="" type="" allowordering="true"/>
<field id="Field_Trip__isCustom__c" type="" valuehalign="" allowordering="true"/>
</fields>
<rowactions/>
<massactions usefirstitemasdefault="true"/>
<views>
<view type="standard"/>
</views>
<searchfields/>
</skootable>
</components>
</division>
</divisions>
<styles>
<styleitem type="background" bgtype="none"/>
<styleitem property="padding-top" value="10px"/>
</styles>
</grid>
</components>
<resources>
<labels/>
<javascript/>
<css>
<cssitem location="inline" name="newcss" cachelocation="false">.nx-skootable>.nx-editor-header{
margin: 0px;
}</cssitem>
</css>
</resources>
<styles>
<styleitem type="background" bgtype="none"/>
</styles>
</skuidpage>
-
354 Points
- helpful
Posted 2 years ago
mB Pat Vachon, Champion
-
42,926 Points
