how to fetch records from a custom object and display it in a calender view.

Questions
,
8

Ritesh,

Here is a sample page that demonstrates what I suggested. It shows Salesforce Events with the Type field showing when the ActivityDate matches the ‘year’ formula for that column. This setup would only handle the Week1, Week2; etc. part of the view. If you want match the grouping by week then by quarter, I think you will have to develop a custom view for the table (see here).

Thanks,

Bill

<skuidpage unsavedchangeswarning="yes" personalizationmode="server" useviewportmeta="true" showsidebar="true" showheader="true" tabtooverride="Event">
    <models>
        <model id="Event" limit="100" query="true" createrowifnonefound="false" datasource="salesforce" sobject="Event">
            <fields>
                <field id="Subject"/>
                <field id="CreatedDate"/>
                <field id="ActivityDate"/>
                <field id="Type"/>
                <field id="Year1" uionly="true" displaytype="FORMULA" label="Year 1" ogdisplaytype="TEXT" readonly="true" returntype="TEXT">
                    <formula>IF(YEAR({{ActivityDate}})==2017,{{Type}},"")</formula>
                </field>
                <field id="Year2" uionly="true" displaytype="FORMULA" label="Year 2" ogdisplaytype="TEXT" readonly="true" returntype="TEXT">
                    <formula>IF(YEAR({{ActivityDate}})==2018,{{Type}},"")</formula>
                </field>
            </fields>
            <conditions/>
            <actions/>
        </model>
    </models>
    <components>
        <pagetitle model="Event" uniqueid="sk-3zEr-199">
            <maintitle>
                <template>{{Model.labelPlural}}</template>
            </maintitle>
            <subtitle>
                <template>Home</template>
            </subtitle>
            <actions>
                <action type="savecancel" uniqueid="sk-3zEr-197"/>
            </actions>
        </pagetitle>
        <skootable showconditions="true" showsavecancel="false" searchmethod="server" searchbox="true" showexportbuttons="false" pagesize="10" createrecords="true" model="Event" mode="read" allowcolumnreordering="true" uniqueid="sk-3zEr-213">
            <fields>
                <field id="Subject" hideable="true" allowordering="true" uniqueid="fi-3zEg-1128"/>
                <field id="Year1" hideable="true" uniqueid="fi-3zEr-933"/>
                <field id="Year2" hideable="true" uniqueid="fi-3zEr-1165"/>
            </fields>
            <rowactions>
                <action type="edit"/>
                <action type="delete"/>
            </rowactions>
            <massactions usefirstitemasdefault="true">
                <action type="massupdate"/>
                <action type="massdelete"/>
            </massactions>
            <views>
                <view type="standard"/>
            </views>
        </skootable>
    </components>
    <resources>
        <labels/>
        <css/>
        <javascript/>
        <actionsequences uniqueid="sk-3zEr-258"/>
    </resources>
    <styles>
        <styleitem type="background" bgtype="none"/>
    </styles>
</skuidpage>