Record eForm submissions results into an Excel document in SharePoint list/library

Comments

3 comments

  • Avatar
    Scott Bennett

    I think I was looking into this and would like to know what a design Time template looks like vs. a Runtime Template looks like and how they work together for the finished product.

    2
    Comment actions Permalink
  • Avatar
    Cindy Xiong

    Thanks for the Excel Write (Document) Activity documentation link. Unfortunately, the documentation isn't helpful. While AP provides instructions on how to configure the activity, AP provides very little context information outside the configuration procedure. Thanks, anyway.

    1
    Comment actions Permalink
  • Avatar
    Cindy Xiong

    I'm with Scott, I'd like to know more about the difference between a Design and Runtime Template, besides that one is used in a dev enviroment and the other in a production environment. The screenshots that are provided in the Excel Write (SharePoint Activity don't explain why they selected two different Excel documents for the Design and Runtime file paths or why the template file names on the "Write Excel Documentation Configuration" screen shows completely different Excel documents. It's difficult to put together the activity building process - probably why I'm having issues loading the Excel fields. I don't think I can use the same Excel template in Design or Runtime. 

    What I'd like to do is have one master Excel spreadsheet that AP will load every eForm submission variables into, rather than individual Excel documents. My client would like to have one spreadsheet where they can track all eForm submission, versus having to open individual documents to review the submission details. I've started looking for an alternative to the Excel activity...maybe I can create a SharePoint list and update that list every time there's an eForm submission - then export the list (when I need to) to Excel. 

    1
    Comment actions Permalink

Please sign in to leave a comment.