Insert Callback in Advanced Relationship Query

MC_Soria
Kilo Expert

I'm using list edit on an embedded list on a form to allow users to insert records into the child table  when the record is inserted for the parent table. The form is a Change Request records which has an embedded list called "Approvers". I requirement is to allow users to add more approvers using the embedded list:

find_real_file.png

Can use the insert callback field on the relationship for the embedded list to set a reference field on the child table (Approvers) to capture the parent record?

find_real_file.png

I'm trying to find information and examples on what the insert callback field does and how to use it.

find_real_file.png

Does anyone have any ideas on how I might accomplish this?

Thanks.

1 ACCEPTED SOLUTION

Yeah, my experience is that you're not going to make anybody happy with embedded lists.  They're really way too much trouble to work with in my opinion for anything other than a simple display of data.  I've implemented change management successfully dozens of times...and never done it with an embedded approvers list.  I'd guide them to a standard related list and make everyone's lives simpler. šŸ™‚

View solution in original post

5 REPLIES 5

Mark Stanger
Giga Sage

I don't think you need an insert callback.  You can just use an 'after insert' business rule on the 'sysapproval_approver' table with conditions that specifically match that approval.  You'll need to have some way of identifying that doc record from your script though so the script knows which doc record to access and update.

Thanks Mark - but that's my dilemma. How do I get the doc id of the parent record in order to put it on the child record (in the embedded list) when they are being submitted at the same time?

This is why I avoid embedded related lists at all costs.  You'll have a much easier time if your approvers are just in a standard related list.

Yes - I agree. Just trying to make the client happy - famous last words! Thanks for at least trying to help me out.