Repeating Table Info Into E-mail - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Repeating Table Info Into E-mail

Last post 05-05-2020 09:34 AM by Stuart Shutts. 4 replies.
Page 1 of 1 (5 items)
Sort Posts: Previous Next
  • 03-19-2020 05:24 AM

    Repeating Table Info Into E-mail

     

    I have 3 columns in a repeating table (Agent ID, Location, Time Zone). Most forms will only have 1 or 2 entries (rows), but some may have 20. I imagine I’ll have to copy all of the information into another field (concatenated somehow) which I then promote to the document library and then somehow convert it using SP Designer so that it ends up looking like this in an e-mail:

     

    AB123C                 123 Somewhere, TX 77071                           Central

    12XYZZ                  456 Somewhere Else, ME 96999                 Eastern

     

    I found 2 other posts that discussed this, but didn't understand what was going on in either. I am not a programmer. Thank you for any assistance you can provide.

    Filed under: ,
  • 03-20-2020 08:28 AM In reply to

    Re: Repeating Table Info Into E-mail

    Have you seen this webinar video? It might help you, and has a link to a kit you can download that should have some additional materials: https://www.youtube.com/watch?v=Wof2n9RHU5w
    Hilary Stoupa

  • 03-27-2020 10:46 AM In reply to

    Re: Repeating Table Info Into E-mail

     Success! (screen shot of the table in the e-mail)

     

    I would like to make a couple of modifications though. The last column doesn't seem to separate the rows like the first 2 columns and I'd like some buffer space after the longest Location Address (to improve readability). Spacing is fine between the first 2 columns. I usually don't create header and body variables for e-mails, but I followed the example provided by Kaoru in her demo. Here are my results:

    Header variable: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"><html><head><style type="text/css"> h3,p,tr,td {font-family:'Verdana';line-height:1.25;} td { border-color:#e0e0e0; padding: 2px 5px;} th {background:rgb(231, 235, 240); border-color:#e0e0e0; border-bottom:1px solid #abb8bd; padding: 2px 5px; font-style:italic;} a { color:#b61234; text-decoration:none; } a:visited { color:#b10069; }</style></head><body>

     Detail variable: <p><b>Detail</b></p><table border="1" style="margin-left:20px;border-collapse:collapse;border:1px solid #e0e0e0"><tr><th>Agent ID</th><th>Location Address</th><th>Time Zone</th></tr>[HTMLstring]</table>

    Here is the properties String Builder for Body associated with the e-mail (screen shot):

    DAP 

  • 03-27-2020 03:29 PM In reply to

    Re: Repeating Table Info Into E-mail

    When I view source on the sample email that you sent me, I can see that the Time Zones aren't in td elements. So, I'd guess on your HTML String, you've missed an opening and closing (or maybe just one or the other?) td elements around the time zone fields. Can you check that?
    Hilary Stoupa

  • 05-05-2020 09:34 AM In reply to

    Re: Repeating Table Info Into E-mail

    (email below)

    The Weekly Productivity Tracker has been submitted for Stuart.Shutts@va.gov.

    The Dates covered are: 4/27/2020 to 5/1/2020.
     
    Total Hours reported is: 40.75
     
    Activity for the Period (format: Activity-Description-Time in Hours) is:
    No : Richmond SP Work - Remove Name from Conf room, then test why Diane F was getting weird emails - .5
    No : Richmond SP Work - Modify SOP - .25
    No : Richmond SP Work - Export/Delete files from HCHV site, prep for migration - 1
    No : VISN 6 Office SP Work - A3 Grading form Testing - 1.5
    No : VISN 6 Office SP Work - Grade Black Belt A3 - 1
    No : VISN 6 Office SP Work - Redo Visn 6 A3 WF Variables - 1
    No : Other Sharepoint Work - IAA Project Grading Form Work - 5
    No : Meetings/Conference Calls -  go over some basic SP Maintenance - 4
    No : Meetings/Conference Calls -  VISN 6 DLO Innovation site - .75
    No : Meetings/Conference Calls -  Wichita SR, discuss Veteran Transport Site - 1
    No : Meetings/Conference Calls -  SP Duties - 1
    No : Meetings/Conference Calls - MSFT SPO Meeting - 1
    No : Meetings/Conference Calls -  SPO Questions and PA WF issues - 2
    No : Meetings/Conference Calls -  Script Editor Banner Webpart Training - 1
    No : Meetings/Conference Calls - Go over her Data Connections - 1
    No : Meetings/Conference Calls - -skype-diagnose Fayetteville Infopath data connections - .5
    No : Meetings/Conference Calls - , Virtual YB Discussion - 1
    No : Meetings/Conference Calls -  Training SP - 4
    No : Meetings/Conference Calls - Person Redacted - .25
    No : Meetings/Conference Calls - , look at process moving to SPO and see what solutions could be presented - .75
    No : Meetings/Conference Calls -  Salsibury Infopath form broken upload, OT - .75
    No : Meetings/Conference Calls -  Salisbury, uploaded more recent CPR 2020 form from laptop - .5
    No : Meetings/Conference Calls - Review SOP layout - 1
    No : Meetings/Conference Calls -  IAA FY 21 Grading Form - 1
    No : Meetings/Conference Calls - SPO Overview - .5
    No : Meetings/Conference Calls - Discuss HCHV Migration to new Secure Site - .5
    No : Other - Answer emails/Phone/Skype - 4
    No : Other - Reboot/update computer during working hours - .5
    No : Leave - 4-27-20 1 hour of expiring travel comp time - 1
    No : Break - Break - 2.5


     i concat a field in the form like this: concat(Highlight, " : ", Activity, " - ", Activity_Details, " - ", Number_of_Hours)   [This is a hidden field on the repeating table and as such it acts like the email shown above]

    I create a multi-line text field on Sharepoint, promote it as a merged field, and then send the merged field in the email. 

     

     

     

Page 1 of 1 (5 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.