Save to child list from EditForm

Forums vLooup for SharePoint Save to child list from EditForm

This topic contains 1 reply, has 2 voices, and was last updated by  Alexander Bautz 4 months ago.

  • Author
    Posts
  • #21399

    Patrice
    Participant

    I have some fields that are not populated until the EditForm is completed in an approval process. These fields are null in the NewForm but I would like these fields to populate the child list when the form is approved to update a status and decision. I don’t want the user to have to manually edit each child record since they will all be the same as the parent, so have configured these fields in the Prefill values in child section but they do not update the child list. What am I missing?

  • #21427

    Alexander Bautz
    Keymaster

    Sorry for the late reply – I’m currently on holiday and have limited access to Email / Internet.

    The settings for Prefill values in child only applies to the first creation of a child record. To achieve what you want, you must use a custom script that runs on edit of the parent record. I have made some example scripts that you can find for example here: http://spjsblog.com/forums/topic/vlookup-update-child-when-parent-is-updated/#post-19728

    Alexander

You must be logged in to reply to this topic.