Rockaway - Uncaught TypeError (Id) in my Snippet

  • 1
  • Problem
  • Updated 3 years ago
Hey guys,

I have a JS mass action that worked great until I installed Rockaway.

The console is saying: Uncaught TypeError: Cannot read property 'Id' of undefined
The source marks the error on this line of code: var CaseID = proto.Case__r.Id;

I read Irvin's message about a similar error, and the resolution had to do with add a trivial sub condition to a subquery. Is that the same error we have here? Also, how do I actually do that?

Full snippet:
var params = arguments[0];var step = params.step;var $ = skuid.$;
var models =;
var protoAppt = models.protoAppt;
var newAppts = models.newAppts;
var proto = protoAppt.getFirstRow();
// GET conditions
var caseCondition = newAppts.getConditionByName('Case');
var userCondition = newAppts.getConditionByName('User');
var recurrencetotalCondition = newAppts.getConditionByName('RecurrenceTotal');
var recurrencestarttimeCondition = newAppts.getConditionByName('RecurrenceStartTime');
var recurrenceendtimeCondition = newAppts.getConditionByName('RecurrenceEndTime');
var recurrenceapptidCondition = newAppts.getConditionByName('RecurrenceApptID');
var recurrenceisrecurrenceCondition = newAppts.getConditionByName('RecurrenceIsRecurrence');
// SET conditions
// SET loop vars
var CaseID = proto.Case__r.Id; //ERROR CAUSED BY THIS LINE
var CaseName = proto.Case__r.Name;
var UserID = proto.User__r.Id;
var UserName = proto.User__r.Name;
var loopRecurrenceNumber = 1;
var loopRecurrenceNumberTotal = protoAppt.getFieldValue(proto,'RecurrenceNumberTotal__c');
var loopStartDateTime = protoAppt.getFieldValue(proto,'StartDateTime__c');
var jsloopStartDateTime = skuid.time.parseSFDateTime(loopStartDateTime);
var loopEndDateTime = protoAppt.getFieldValue(proto,'EndDateTime__c');
var jsloopEndDateTime = skuid.time.parseSFDateTime(loopEndDateTime);
var loopDate = protoAppt.getFieldValue(proto,'Date__c');
var jsloopDate = skuid.time.parseSFDate(loopDate);
// ACTION CODE - loop and set non default values
var i=1;
while(i < 54){
var row = newAppts.createRow({
additionalConditions: [
{field: 'RecurrenceNumber__c', value: i},
{field: 'Case__c', value: CaseID, operator: '=', nameFieldValue: CaseName},
{field: 'User__c', value: UserID, operator: '=', nameFieldValue: UserName},
{field: 'RecurrenceIsRecurrence__c', value: 'True'},
{field: 'Date__c', value: loopDate},
{field: 'Start_Time__c', value: protoAppt.getFieldValue(proto,'Start_Time__c')},
{field: 'End_Time__c', value: protoAppt.getFieldValue(proto,'End_Time__c')},
{field: 'Subject__c', value: protoAppt.getFieldValue(proto,'Subject__c')},
{field: 'Type__c', value: protoAppt.getFieldValue(proto,'Type__c')}
var jsloopStartDateTime = skuid.time.parseSFDateTime(loopStartDateTime);
jsloopStartDateTime.setDate(jsloopStartDateTime.getDate() + 7);
var loopStartDateTime = skuid.time.getSFDateTime(jsloopStartDateTime);
var jsloopEndDateTime = skuid.time.parseSFDateTime(loopEndDateTime);
var loopEndDateTime = skuid.time.getSFDateTime(jsloopEndDateTime);
var jsloopDate = skuid.time.parseSFDate(loopDate);
var loopDate = skuid.time.getSFDate(jsloopDate);
//loopRecurrenceNumber = loopRecurrenceNumber + 1;
Photo of Griffin Brown

Griffin Brown

  • 2,798 Points 2k badge 2x thumb

Posted 3 years ago

  • 1
Photo of Griffin Brown

Griffin Brown

  • 2,798 Points 2k badge 2x thumb
Photo of J.

J., Official Rep

  • 7,826 Points 5k badge 2x thumb
That's a standard JavaScript error when you try to access properties of undefined. In this case, the row returned by protoAppt.getFirstRow(); doesn't have any related Case data (or the user running the page doesn't have permission to access the Case record). If you use protoAppt.getFieldValue(proto,'Case__r.Id') instead, we work around it for you. It still might not make the snippet work the way you expect, but that should at least make the error go away.

I'm not immediately seeing how a Rockaway update would have caused this issue since the error wasn't coming from one of our APIs. I'd start by switching to getFieldValue in your snippet, and confirming that a Case record does exist for that record and that the User can access it.
Photo of Griffin Brown

Griffin Brown

  • 2,798 Points 2k badge 2x thumb
Hey J. That definitely resolved that issue, and a new one came up. It's saying

Uncaught TypeError: jsloopStartDateTime.getDate is not a function

from this line:
var jsloopStartDateTime = skuid.time.parseSFDateTime(loopStartDateTime);
jsloopStartDateTime.setDate(jsloopStartDateTime.getDate() + 7);

Any tips?