Skip to main content

    Filter by Idea status

    Filter by category

    1121 Ideas

    Recipient Activity Report Time formatting in ExcelParked

    Currently, when using the Recipient Activity Report, the formatting when downloading to Excel is not correct.When it opens in excel, it get automatically formatting in HH:MM:SS instead of DD:HH:MM as stated in the report on docusign, to get around this I have listed the step I have used to have it format correctly and display actionable information for use making graphs etc. Place  ‘  (Apostrophe) before the time in excel - E.G. '01:09:18In the next cell over, Copy this equation to extra the data from the cell holding the docusing data=INT(LEFT(G2, FIND(":", G2) - 1) * 24 + MID(G2, FIND(":", G2) + 1, FIND(":", G2, FIND(":", G2) + 1) - FIND(":", G2) - 1)) & " hours " & MID(G2, FIND(":", G2, FIND(":", G2) + 1) + 1, 2) & " minutes"in the cell over from this again, place the below equation. This will then turn the information into total minutes, which can be used to calculate total minutes/ average time for a task to pass through multiple signees et.=LEFT(H2, FIND(" hours", H2) - 1) * 60 + MID(H2, FIND(" hours", H2) + 7, FIND(" minutes", H2) - FIND(" hours", H2) - 7)I use this info to make this back into the format Docusign said it would be formatted in DD:HH:MM using th equation listed below =INT(I3/1440) & " days " & TEXT(INT(MOD(I3, 1440)/60), "00") & " hours " & TEXT(MOD(I3, 60), "00") & " minutes" Using all the info from these equations I personally create average time for a document to pass through multiple signees 

    Scott.Nieman
    Troubleshooter
    Scott.NiemanTroubleshooter

    Enhancement Request - allow a subset of envelope documents to be combined into one PDF by their documentId and sequence to add, while being able to download the remaining as individual documentsParked

    GET {{baseUrl}}/v2.1/accounts/{{accountId}}/envelopes/{{envelopeId}}/documents/combined is not working for us and we need enhancements.In our contracting process we want to assemble and reuse templates as much as possible.The boilerplate language of the agreement is a template with tabs.Our Exhibit A is a listing of arable fields that a farmer operates and may be eligible for a carbon program.  We generate and add this document via the APIExhibits B, C and D are reuseable templates.We may optionally add sensitive documents such as the IRS W-9 template, and our ACH enrollment forms.  These sensitive documents need to be captured and place in a secure Azure container, with only authorized individuals allowed to see (PII).  The business does NOT want to send multiple envelopes.  These are farmers, and sometimes the only computer they have is in the tractor cab or their cellphone.We need to add query parameters to the combine resource to specify [{“documentId”: “1”, “sequenceId”:”1”},{“documentId”: “2”, “sequenceId”:”2”},{“documentId”: “3”, “sequenceId”:”3”}, “documentId”: “4”, “sequenceId”:”4”}, {“documentId”: “5”, “sequenceId”:”5”}], and retrieve the remaining directly.The existing combine feature is too basic.  Support has suggested use this Idea platform.