Save to child list from EditForm

Home Forums vLooup for SharePoint Save to child list from EditForm

Viewing 1 reply thread
  • 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: https://spjsblog.com/forums/topic/vlookup-update-child-when-parent-is-updated/#post-19728

          Alexander

      Viewing 1 reply thread
      • You must be logged in to reply to this topic.