Javascript: Create new row and set Lookup field to reference an unsaved object (SKUID Temp ID, not S

Ah it looks like on further inspection the row does get created with the skuid temp ID in the lookup field.

I guess my only question then is: is this the right approach? When I go to save will everything associate properly?

It looks like this is indeed not the right approach, as when you save you get an error “Invalid Reference Id”

How do I go about setting the Lookup field on the child objects I create in Javascript with the temporary ID of the parent in such a way so that when these save they relate properly?

I’ve found a workaround to make this happen. I’ve taken the approach of overwriting the “ParentLookup__c” field in all of the child models with the ID of the Parent object in the UI editor prior to saving all my models. (Model: Update Rows - All Rows : ParentLookup__c = Field From Another Model: ParentModel:Id)

Setting the lookups this way in the UI Editor causes the new rows to save with the proper ID associated. I just wish there were a more straightforward way to achieve this when creating a new row / associating a Lookup to an unsaved parent in javascript.

Still very curious as to how to make this happen without having to find an indirect and not always applicable workaround using the SKUID Editor interface.

Does anyone have any idea if it is possible / how to assign in Javascript a lookup relationship between 2 objects that have not yet saved to the database in such a way that it will save properly when the models are saved together?

Currently it seems if you just set the Lookup of the child to the ID of the parent in Javascript, it will set it as the SKUID temporary Id, and when you try to save  it will give an invalid ID error thinking that the SKUID Temporary ID should be the Salesforce ID rather than intelligently relating the objects together as it does when setting unsaved object lookups in the SKUID Editor.

Hi Mark, glad you were able to find a workaround for now.

In general, when creating new records and their children this is what we recommend:

1. Have the child model use “field from another model” condition to be linked to the first model. (Eg. If you are creating an Account and Contacts related to it, set up a condition on the New Contacts model where AccountId = field from another model > New Account Model > Id).
   
2. When saving, you can configure a button to run multiple actions via the action framework.  If your parent model (e.g. Account) is listed before your child model (e.g. Contacts) in the list, you should not encounter any errors since it will be saved before the other model.  If you do run into difficulties, you can add two discrete actions, one to Save the parent record, and, if this action succeeds another to save the child record.

• https://docs.skuid.com/latest/v1/en/skuid/models/conditions/
  
• https://docs.skuid.com/latest/v1/en/skuid/action-framework/
  

Hi Anna,

Thanks for the information but this is not helpful for my situation. The problem occurs when you are working with rows in javascript and setting the lookup relationship in javascript.

For instance:

//parentModel is unsaved (the row has a skuid temporary ID)
//parentRow is first row in model (unsaved, has a SKUID temporary ID)
childModel.createRow({doAppend: true, additionalConditions: [
{field: ‘LookupField1__c’, value: parentModel.getFieldValue(parentRow,‘Id’,true)},
]
});

Hi Mark, I agree it sounds like there should be a way to accomplish this. We’ll do some research and get back to you.

In the meantime, can you share more about your specific use case?  It sounds like you may be trying to create multiple parent records and their children at the same time.  If you can share more about the specifics, it will help us know how to direct you more effectively.

Thanks!

Further example:

I have just created a list of parent objects (not yet saved). For each parent object in that list I want to create any number different child objects (of a different object type) and associate a lookup relationship between each parent object in the list and its child objects via a lookup relationship on the child object to the parent object. I then want to do a save all at once, erroring / rolling back changes if anything fails. Since I’m running through loops here the only way I can see to do this is in javascript; however setting lookup relationships in javascript between unsaved objects that have SKUID temporary IDs doesn’t work the same way it would in the UI editor via “field from another model”, when saving it will give an invalid ID on lookup field error.

Hi Mark, thanks for the details of your use case. Here’s what we recommend:

1. Set up your parent and child object models declaratively in Skuid using the process outlined above with the field from another model condition on the lookup field.
2. Then, you can create the new records and their children via the action framework or JS.  You must save the parents and the children at the same time. In the Action Framework you can also handle which messages to show and which actions to run if there are errors with the save.

• https://docs.skuid.com/latest/en/skuid/api/skuid_model_model.html
  https://docs.skuid.com/latest/v1/en/skuid/action-framework/action-list/
  

Hi Anna,

I’m not sure that I follow here. How do I loop through the parent objects and create a child object for each parent object (each related specifically to its own parent object) in the UI editor (without javascript)? There doesn’t appear to be a way to do this.

Hi Mark, based on our understanding of what you’re trying to accomplish, it sounds like these specific model APIs may be helpful:

• https://docs.skuid.com/latest/en/skuid/api/skuid_model_model.html#skuid.model.Model.getRows - for getting rows in a model (i.e. getting the parent rows)
• https://docs.skuid.com/latest/en/skuid/api/skuid_model_model.html#skuid.model.Model.createRow - for creating records (i.e. the rows in the child model)
• https://docs.skuid.com/latest/en/skuid/api/skuid_model.html#skuid.model.save - be sure to save both models in the same transaction so that Skuid can resolve the temporary IDs server side
  
  

Hi Anna,

So you’re saying that if I use skuid.model.save(ArrayOfBothModelsToSaveSimultaneously) it won’t give the invalid ID error?

I’ve run through a test of this and it appears to work!!

var params = arguments[0], $ = skuid.$;
var am = skuid.model.getModel('AccountModel');<br>var cm = skuid.model.getModel('ContactModel');
var models = [];
models.push(am);<br>models.push(cm);
$.when(am.createRow({doAppend: true, additionalConditions: [<br>{field: 'Name', value: 'TEMPVARTESTACCOUNT'}<br>]<br>})).done(function(){<br>&nbsp; &nbsp; var amRow = am.getFirstRow();<br>&nbsp; &nbsp;&nbsp;<br>$.when(cm.createRow({doAppend: true, additionalConditions: [<br>&nbsp; &nbsp; {field: 'LastName', value: 'TEMPVARTESTER'},<br>&nbsp; &nbsp; {field: 'AccountId', value: am.getFieldValue(amRow,'Id',true)}<br>&nbsp; &nbsp; ]<br>&nbsp; &nbsp; })).done(function(){<br>&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<br>&nbsp; &nbsp; skuid.model.save(models, {rollbackOnAnyError: true,callback: function(result){<br>&nbsp; &nbsp; &nbsp; &nbsp; console.log('SAVE RESULTS:');<br>&nbsp; &nbsp; &nbsp; &nbsp; console.log(result); //Success!!<br>&nbsp; &nbsp; }});<br>&nbsp; &nbsp; });<br>});

It also appears that if I run an action sequence (UI editor) based save on both models simultaneously that is working as well. This is very strange though because I was using an action sequence based save on all models simultaneously before when I first created this forum thread and it was giving me the invalid Id error; now that I try coding it out in my test example it seems to not be having that problem. Very peculiar. It’s been a while since I had this error in my original code and I’ve since reworked it using a different strategy for saving / relating items. I’ll let you know if I can reproduce my original issue as we’re coding our new project up and do some more testing around it, otherwise it appears this strategy works! Thanks!

Thanks for the update, Mark, sounds good.