Record is not saving and displaying on the pagelayout

  • 1
  • Problem
  • Updated 10 months ago
  • In Progress
Hi,

Hope you are doing great !!!!

I have setup Skuid with salesforce.

I am using Skuid page for post time. While I have filled record details on the edit page and after that, i have click on the save button. Now, this time record is disappearing. It is not visible on the detail page.

Note: It issue is coming at 11:00 AM to 2:00 PM (EST) time zone. And I am facing this issue with only 2 users.

Please let me know. why it is happening at the record saving time.


My contact details.
Arvind Kumar
arvind.twopirconsulting@gmail.com
+91 9665086466
Photo of Arvind Kumar

Arvind Kumar

  • 222 Points 100 badge 2x thumb
  • Confused

Posted 1 year ago

  • 1
Photo of Arvind Kumar

Arvind Kumar

  • 222 Points 100 badge 2x thumb
Hi,

Please help me. It issue coming again & again. At my end, I could not find the issue.


Thanks,
Arvind Kumar
Photo of Arvind Kumar

Arvind Kumar

  • 222 Points 100 badge 2x thumb
Hi,

Please reply me. I am getting confused.

It is a very urgent task.


Thanks,
Arvind Kumar
Photo of Stephen Sells

Stephen Sells, Official Rep

  • 16,856 Points 10k badge 2x thumb
I'm sorry you're having such trouble. I do have two questions for you:
1.) What skuid version are you using?
2.) Can you copy and paste the XML of the broken page here? Preferably one that does not have custom objects or fields that reproduces the issue.
Photo of Arvind Kumar

Arvind Kumar

  • 222 Points 100 badge 2x thumb
Hi Stephen,

1.) Skuid Version: 10.0.6

2.) XML file. We are using post time page for updating the time related to the matter.

<skuidpage unsavedchangeswarning="yes" showsidebar="true" showheader="true">
    <models>
        <model id="Time" limit="200" query="true" createrowifnonefound="false" sobject="Transaction__c" doclone="" type="" orderby="Matter__c">
            <fields>
                <field id="Date__c"/>
                <field id="CreatedById"/>
                <field id="CreatedBy.Name"/>
                <field id="Client__c"/>
                <field id="Description__c"/>
                <field id="Employee__c"/>
                <field id="Employee__r.Name"/>
                <field id="Hours__c"/>
                <field id="LastModifiedDate"/>
                <field id="LastModifiedById"/>
                <field id="LastModifiedBy.Name"/>
                <field id="Matter__c"/>
                <field id="Matter__r.Name"/>
                <field id="Rate_Unit_Value__c"/>
                <field id="RecordTypeId"/>
                <field id="RecordType.Name"/>
                <field id="Status__c"/>
                <field id="Type__c"/>
                <field id="Total__c"/>
                <field id="Name"/>
                <field id="You_are_sure_you_want_to_proceed__c"/>
                <field id="Alias__c"/>
            </fields>
            <conditions>
                <condition type="fieldvalue" value="012j0000000lq8H" enclosevalueinquotes="true" field="RecordTypeId"/>
                <condition type="fieldvalue" value="TODAY" enclosevalueinquotes="false" field="Date__c" state="filterableon" inactive="false" name="Date__c_Is_Today"/>
                <condition type="fieldvalue" value="Unposted" enclosevalueinquotes="true" field="Status__c"/>
                <condition type="userinfo" value="" field="Employee__c" operator="=" enclosevalueinquotes="true" userinfotype="userid" state="filterableon" inactive="false" name="Employee__c"/>
            </conditions>
            <actions/>
        </model>
        <model id="RunningUser" limit="1" query="true" createrowifnonefound="false" sobject="User" doclone="" type="" orderby="id">
            <fields>
                <field id="Id"/>
                <field id="Name"/>
                <field id="Type__c"/>
            </fields>
            <conditions>
                <condition type="userinfo" value="" field="Id" operator="=" enclosevalueinquotes="true" userinfotype="userid"/>
            </conditions>
            <actions/>
        </model>
        <model id="AllTime" limit="" query="true" createrowifnonefound="false" sobject="Transaction__c" doclone="" type="" orderby="Date__c DESC">
            <fields>
                <field id="Alias__c"/>
                <field id="CreatedDate"/>
                <field id="Date__c"/>
                <field id="Hours__c"/>
                <field id="Status__c"/>
                <field id="Matter__c"/>
                <field id="Matter__r.Name"/>
                <field id="Description__c"/>
                <field id="CreatedById"/>
                <field id="CreatedBy.Name"/>
                <field id="Type__c"/>
            </fields>
            <conditions>
                <condition type="fieldvalue" value="012j0000000lq8H" enclosevalueinquotes="true" field="RecordTypeId"/>
                <condition type="userinfo" value="" field="Employee__c" operator="=" enclosevalueinquotes="true" userinfotype="userid"/>
                <condition type="fieldvalue" value="LAST_N_DAYS:30" enclosevalueinquotes="false" field="Date__c"/>
            </conditions>
            <actions/>
        </model>
    </models>
    <components>
        <pagetitle model="Time">
            <maintitle>Post Time</maintitle>
            <actions>
                <action type="redirect" label="Unposted Time Report" window="self" url="/00Oj0000004d7vV" icon="ui-silk-report"/>
            </actions>
        </pagetitle>
        <skootable showconditions="true" showsavecancel="true" searchmethod="server" searchbox="true" showexportbuttons="true" pagesize="10" createrecords="true" model="Time" buttonposition="" mode="read" emptysearchbehavior="query">
            <fields>
                <field id="Matter__c" valuehalign="" type="" readonly="false" allowordering="true" optionsource="" columnwidth="100">
                    <searchfields>
                        <searchfield query="true" return="true" show="true" field="Name" operator="contains"/>
                        <searchfield query="true" return="true" show="true" field="Owner.Alias" operator="contains"/>
                        <searchfield query="true" return="true" show="true" field="Type__c" operator="contains"/>
                        <searchfield query="true" return="true" show="true" field="Client_Name__c" operator="contains"/>
                    </searchfields>
                    <filters>
                        <filter type="fieldvalue" operator="=" enclosevalueinquotes="true" field="Status__c" value="Active"/>
                    </filters>
                </field>
                <field id="Date__c" valuehalign="" type="" required="true" allowordering="true" columnwidth="100"/>
                <field id="Employee__c" valuehalign="" type="" required="true" optionsource="" allowordering="true" columnwidth="100">
                    <searchfields>
                        <searchfield query="true" return="true" show="true" field="First_Name__c" operator="contains"/>
                        <searchfield query="true" return="true" show="true" field="Last_Name__c" operator="contains"/>
                        <searchfield query="true" return="true" show="true" field="Type__c" operator="contains"/>
                        <searchfield query="true" return="true" show="true" field="Office__c" operator="contains"/>
                    </searchfields>
                </field>
                <field id="Hours__c" decimalplaces="" valuehalign="" type="" required="true" allowordering="true" columnwidth="50">
                    <summaries>
                        <summary>sum</summary>
                    </summaries>
                </field>
                <field id="Type__c" valuehalign="" type="" required="true" addnoneoption="false" allowordering="true"/>
                <field id="Description__c" valuehalign="" type="" required="true" allowordering="true" columnwidth="400"/>
                <field id="Status__c" valuehalign="" type="" readonly="false" required="true" addnoneoption="true" allowordering="true"/>
                <field id="You_are_sure_you_want_to_proceed__c" type="" valuehalign="" allowordering="true">
                    <label>Proceed?</label>
                </field>
                <field id="CreatedById" valuehalign="" type="" readonly="true" allowordering="true">
                    <label>Created By</label>
                </field>
            </fields>
            <rowactions>
                <action type="edit"/>
                <action type="delete"/>
            </rowactions>
            <massactions usefirstitemasdefault="true">
                <action type="multi" label="Post Time" icon="ui-silk-clock">
                    <actions>
                        <action type="updateRow" fieldmodel="Time" field="Status__c" enclosevalueinquotes="true" value="Posted"/>
                        <action type="save" rollbackonanyerror="true">
                            <models>
                                <model>Time</model>
                            </models>
                        </action>
                        <action type="requeryModel" model="Time" behavior="standard">
                            <onerroractions>
                                <action type="blockUI" message="There was an error. Please refresh and try again." timeout="3000"/>
                            </onerroractions>
                        </action>
                    </actions>
                </action>
            </massactions>
            <views>
                <view type="standard"/>
            </views>
            <filters>
                <filter type="select" filteroffoptionlabel="Today" createfilteroffoption="true" affectcookies="true" autocompthreshold="25" conditionsource="manual" labelmode="no">
                    <sources>
                        <source type="manual" effectsbehavior="justdefault">
                            <options>
                                <option label="All Dates" type="complex">
                                    <effects>
                                        <effect action="deactivate" value="" condition="Date__c_Is_Today"/>
                                    </effects>
                                </option>
                            </options>
                        </source>
                    </sources>
                </filter>
                <filter type="select" filteroffoptionlabel="Me" createfilteroffoption="true" affectcookies="true" autocompthreshold="25" conditionsource="manual" labelmode="no">
                    <sources>
                        <source type="manual" effectsbehavior="justdefault">
                            <options>
                                <option label="All Employees" type="complex">
                                    <effects>
                                        <effect action="deactivate" value="" condition="Employee__c"/>
                                    </effects>
                                </option>
                            </options>
                        </source>
                    </sources>
                </filter>
            </filters>
            <searchfields usesosl="false" soslfields="Name Fields">
                <searchfield return="false" field="Matter__r.Name" operator="contains"/>
                <searchfield return="false" field="Employee__r.Name" operator="contains"/>
            </searchfields>
            <exportproperties usetablecolumns="true"/>
        </skootable>
        <skuidvis__chart model="AllTime" maintitle="Time Chart" type="column" subtitle="Last 30 Days | Billed, Posted &amp; Unposted" stacking="true">
            <dataaxes>
                <axis id="axis1" title="Hours"/>
            </dataaxes>
            <categoryaxes>
                <axis id="categories" categorytype="field" field="Date__c" title="Date" fillvals="true" dategranularity="day">
                    <allowedgranularities>
                        <type>calweek</type>
                        <type>calmonth</type>
                    </allowedgranularities>
                </axis>
            </categoryaxes>
            <serieslist>
                <series valuefield="Hours__c" splittype="field" modelId="AllTime" categoryField="Date__c" aggfunction="sum" splitfield="Status__c"/>
            </serieslist>
            <colors>
                <value>#ffe082</value>
                <value>#d81b60</value>
                <value>#91a7ff</value>
                <value>#e51c23</value>
                <value>#ffb74d</value>
                <value>#7b1fa2</value>
                <value>#4527a0</value>
                <value>#9fa8da</value>
                <value>#ff7043</value>
                <value>#29b6f6</value>
                <value>#00bcd4</value>
                <value>#00897b</value>
                <value>#0a7e07</value>
                <value>#558b2f</value>
            </colors>
            <legend layout="vertical" halign="right" valign="middle"/>
            <allowedtypes>
                <type>areaspline</type>
                <type>bar</type>
            </allowedtypes>
            <renderconditions logictype="and">
                <rendercondition type="multiple" operator="in" fieldmodel="RunningUser" sourcetype="fieldvalue" nosourcerowbehavior="deactivate" field="Type__c" value="" enclosevalueinquotes="true">
                    <values>
                        <value>Attorney</value>
                        <value>Paralegal</value>
                    </values>
                </rendercondition>
            </renderconditions>
        </skuidvis__chart>
        <skootable showconditions="true" showsavecancel="false" searchmethod="server" searchbox="true" showexportbuttons="true" pagesize="10" createrecords="false" model="AllTime" buttonposition="" mode="readonly">
            <fields>
                <field id="Matter__c" valuehalign="" type="" allowordering="true"/>
                <field id="Date__c" valuehalign="" type="" allowordering="true"/>
                <field id="Alias__c" valuehalign="" type="" allowordering="true"/>
                <field id="Hours__c" decimalplaces="" valuehalign="" type="" allowordering="true"/>
                <field id="Type__c" valuehalign="" type="" allowordering="true"/>
                <field id="Description__c" valuehalign="" type="" allowordering="true"/>
                <field id="Status__c" valuehalign="" type="" allowordering="true"/>
                <field id="CreatedById" valuehalign="" type="" allowordering="true">
                    <label>Created By</label>
                </field>
            </fields>
            <rowactions/>
            <massactions usefirstitemasdefault="true"/>
            <views>
                <view type="standard"/>
            </views>
            <exportproperties usetablecolumns="true"/>
        </skootable>
    </components>
    <resources>
        <labels/>
        <javascript>
            <jsitem location="inlinesnippet" name="newSnippet" cachelocation="false">var params = arguments[0],
$ = skuid.$;
</jsitem>
        </javascript>
        <css/>
    </resources>
</skuidpage>











Thanks,
Arvind Kumar 
Photo of Bill McCullough

Bill McCullough, Champion

  • 12,436 Points 10k badge 2x thumb
Arvind,

When are you having trouble saving?  Is it when you edit a row in your table or when you run your Mass Action?

Thanks,

Bill
Photo of Arvind Kumar

Arvind Kumar

  • 222 Points 100 badge 2x thumb
Hi Bill,

When I am making a new record through the table. When I have put fields details on the row and I am attempting to save the record. At the time, the record is disappearing from the row of a table.

Please provide the best solution.

Thanks,
Arvind Kumar 
Photo of Bill McCullough

Bill McCullough, Champion

  • 12,436 Points 10k badge 2x thumb
Arvind,

You have the table filtering on a condition on the Running User Id.  This is the condition that I am referring to:

<condition type="userinfo" value="" field="Employee__c" operator="=" enclosevalueinquotes="true" userinfotype="userid" state="filterableon" inactive="false" name="Employee__c"/>

While using the Running User Id works for queries, I have not seen it work for a condition when creating a new record.  I think your new 'Time' records are saving with the Employee__c field as 'empty or null'.  This is why they disappear from your table after saving.  Your Time model is only showing 'time records' for the current user.  Since the Employee__c field is empty on the saved time record, it does not show in the table.

Add a model to get the current user's Id using the User object.  Then change the condition on your Time model on the Employee__c field to 'Field from another model' and reference the Id field for your 'current user' model.  Also make sure that the 'current user' model that you add is first in the list of models.

Thanks,

Bill
Photo of Arvind Kumar

Arvind Kumar

  • 222 Points 100 badge 2x thumb
Hi Bill,

I have changed in the Emplyee__c field on the skuid page. I have released the form for working.
The user is facing the issue again & again in the between of 11 AM to 2 PM EST time.

Thanks,
Arvind Kumar
+91 9665086466
Photo of Arvind Kumar

Arvind Kumar

  • 222 Points 100 badge 2x thumb
Hi Bill,

I will apply the logic which you have provided me.

And I will get back to you soon.


Thanks for your quick response !!!


Arvind Kumar
Photo of Arvind Kumar

Arvind Kumar

  • 222 Points 100 badge 2x thumb
Hi Bill,

I have changed in the Emplyee__c field on the skuid page. I have released the form for working.

But the user is getting the issue. When the user has filled the information in the row and clicked on the save button, at time row of the table has been disappeared. It issue coming in the 11 AM to 2 PM EST time zone.

The user is facing the issue again & again in the between of 11 AM to 2 PM EST time.

Note: I have made "Post time" skuid page for filling the time related to matter object records.

Please let me know the best solution.

If you have any question please let me know. Below is my contact details.


Thanks,
Arvind Kumar
arvind.twopirconsulting@gmail.com
+91 9665086466
(Edited)
Photo of Bill McCullough

Bill McCullough, Champion

  • 12,436 Points 10k badge 2x thumb
Arvind,

I think you are saying that your user is testing the page and is still running into a problem where the 'time' entries are disappearing from the table.

Here is a sample page based on Tasks.  You should be able to install this in your org.  It demonstrates the setup of the page that I think you are after.  It shows tasks for Today only.  You can enter new tasks.  As long as you keep the date to 'today', the tasks will remain in view after saving.
<skuidpage unsavedchangeswarning="yes" personalizationmode="server" useviewportmeta="true" showsidebar="true" showheader="true" tabtooverride="Task">
    <models>
        <model id="CurrentUser" limit="1" query="true" createrowifnonefound="false" datasource="salesforce" type="" sobject="User">
            <fields>
                <field id="Name"/>
                <field id="Id"/>
            </fields>
            <conditions>
                <condition type="userinfo" value="" field="Id" state="" operator="=" enclosevalueinquotes="true" userinfotype="userid"/>
            </conditions>
            <actions/>
        </model>
        <model id="Task" limit="100" query="true" createrowifnonefound="false" datasource="salesforce" sobject="Task" type="" orderby="CreatedDate DESC">
            <fields>
                <field id="Subject"/>
                <field id="CreatedDate"/>
                <field id="OwnerId"/>
                <field id="Owner.Name"/>
                <field id="WhoId"/>
                <field id="Who.Name"/>
                <field id="WhatId"/>
                <field id="What.Name"/>
                <field id="ReminderDateTime"/>
                <field id="Type"/>
            </fields>
            <conditions>
                <condition type="fieldvalue" value="TODAY" enclosevalueinquotes="false" field="ReminderDateTime" operator="="/>
                <condition type="modelmerge" value="" field="OwnerId" fieldtargetobjects="User" operator="=" model="CurrentUser" enclosevalueinquotes="true" mergefield="Id" novaluebehavior="deactivate"/>
                <condition type="fieldvalue" value="Call" enclosevalueinquotes="true" field="Type"/>
            </conditions>
            <actions/>
        </model>
    </models>
    <components>
        <pagetitle model="Task" uniqueid="sk-2Zh3Jj-194">
            <maintitle>Today's Tasks</maintitle>
            <actions>
                <action type="savecancel" uniqueid="sk-2Zh3Jg-192"/>
            </actions>
        </pagetitle>
        <skootable showconditions="true" showsavecancel="false" searchmethod="server" searchbox="true" showexportbuttons="false" pagesize="10" createrecords="true" model="Task" mode="read" allowcolumnreordering="true" uniqueid="sk-2Zh3KI-208">
            <fields>
                <field id="Subject" hideable="true" allowordering="true" uniqueid="fi-2Zh2Y2-575"/>
                <field id="WhoId" hideable="true" uniqueid="fi-2ZhCHp-295"/>
                <field id="WhatId" hideable="true" uniqueid="fi-2ZhCHq-296"/>
                <field id="OwnerId" hideable="true" uniqueid="fi-2ZhCHp-294" valuehalign="" type=""/>
                <field id="ReminderDateTime" hideable="true" uniqueid="fi-2ZhOhe-364" valuehalign="" type=""/>
                <field id="Type" hideable="true" uniqueid="fi-2ZoW0O-256"/>
            </fields>
            <rowactions>
                <action type="edit"/>
                <action type="delete"/>
            </rowactions>
            <massactions usefirstitemasdefault="true">
                <action type="massupdate"/>
                <action type="massdelete"/>
            </massactions>
            <views>
                <view type="standard"/>
            </views>
            <actions defaultlabel="Global Actions" defaulticon="sk-icon-magic" usefirstitemasdefault="true">
                <action type="multi" label="New Task" icon="sk-icon-add">
                    <actions>
                        <action type="createRow" model="Task" appendorprepend="prepend" defaultmodefornewitems="edit" affectedrows="context"/>
                    </actions>
                </action>
            </actions>
        </skootable>
    </components>
    <resources>
        <labels/>
        <css/>
        <javascript/>
        <actionsequences uniqueid="sk-2ZhCHW-284"/>
    </resources>
    <styles>
        <styleitem type="background" bgtype="none"/>
    </styles>
</skuidpage>

Thanks,

Bill
Photo of Arvind Kumar

Arvind Kumar

  • 222 Points 100 badge 2x thumb
Hi Bill,

Is that possible, you can do a meeting with us and try to solve our issue.


Thanks,
Arvind Kumar
Photo of Arvind Kumar

Arvind Kumar

  • 222 Points 100 badge 2x thumb
Hi Bill,

How are you?

I have applied your logic in my post time page. But it not working for as per expectation.

The row of record is disappearing from the table. Please solve my issue.


Thanks,
Arvind Kumar
Photo of Bill McCullough

Bill McCullough, Champion

  • 12,436 Points 10k badge 2x thumb
Rajat,

Khamla suggested that you create a copy of the model and the table you are using with the model conditions de-activated as a way to determine what condition is causing your issue.

If you add a record to a table with no conditions, do you still see the record after saving?  If not, then you will want to look at workflow, triggers; etc.  If you do see the record, then begin activating conditions one at a time and adding a record each time until you don't see the record.  This will identify which condition is causing the issue.

Please let us know which condition is causing the issue and post the XML for that condition.

Thanks,

Bill
Photo of Rajat Maheshwari

Rajat Maheshwari

  • 420 Points 250 badge 2x thumb
Hi Bill,

As we have discussed, It's a strange issue. This issue comes in specific time frames, not every time. 

If we do testing as per your approach, Issue will not be coming every time, only specific random time, It failed to works.

Could you please help us how to deal with such issue? As Client is also not happy with your new table approach. Please let us know some other approach to tackle such issue.

Thanks
Photo of Bill McCullough

Bill McCullough, Champion

  • 12,436 Points 10k badge 2x thumb
Rajat,

I was not trying to propose a final solution for you.  I only wanted to give you a process to identify what condition/filter causes the issue.

What condition/filter caused the records to be hidden or not show?

Thanks,

Bill
Photo of Rajat Maheshwari

Rajat Maheshwari

  • 420 Points 250 badge 2x thumb
Hi Bill,

Thanks for prompt response !!

Actually there is no any condition/filter to cause any issue. The users come and simple post new record by click button. Most times, It works perfectly but within some random time It doesn't. After some time, those user when try once again It works then.

Today client reported again issue that , One of the user was trying to post new record between 8:40 and 9:00 am, but The record did disappear and when he came after some time to replicate the same process, It then works.

In short, Record get disappear / Not created within random any time frame, later when they do same, It will create then.

Please let us know the approach to fix this strange issue.


Thanks
Photo of Bill McCullough

Bill McCullough, Champion

  • 12,436 Points 10k badge 2x thumb
Rajat,

I think you should be working in the same room where the users experience this problem.  Have your users let you know as soon as it happens and to not touch the keyboard or mouse.

You should open the developer console on the user's browser look for any errors.  If there are no errors then I would open the developer console and inspect the model to see if the record they added is there.  If it is, then I would use Workbench to try and find the record that the user just added.  If the records was saved in Salesforce, then it may be a problem with how the page re-renders the table to show changes.  If the record is not there, then it may be that the user thought they clicked the 'Save' button, but did not.  You may want to add a Show message and block UI to the save button to show that they have clicked the button.

Thanks,

Bill