Trigger "generate document" when the cell value (drop down) changes in a worksheet
Automation
- cell changes to APPROVED (it is a drop down selection) then
- generate a document.
The document is a docusign document.
Is there an issue with using a drop down selection to trigger an automation? The automation says it is successful but I don't receive a document to my email. Perhaps I need to re-look at the document mapping settings?
Best Answer
-
Hey,
When you go to Generate Document and you generate it manually (the option when it says Generate and Save as Attachment or Download) there should be this status bar showing if the document is really generated (does not matter if PDF or DocuSign) does it go till the end and is green?
I had issues with DocuSign and Smartsheet showing that document was generated but actually it was not because I used all the "tokens" for DocuSign - i think its worth checking.
The Real Smartsheet Enthusiast
Is there anything else we can help you with? - book your time!
MASA Consult - Your Aligned Smartsheet Partner
Find us on LinkedIn!
Answers
-
Hi @LAW,
I had something similar when generating a document and sending it activated by the same trigger, with no document being sent.
I got around it by adding a second automation to send once a document had been generated. My thinking was that the cell or row change triggering both the document creation and the sending of said document was that at the instance of the trigger being activated, there was no document to send.
I might be talking rubbish, but it worked for me.
Good luck
-
Hello,
the workflow looks legit.
I do not think the problem is the tirgger but more the docusign part.
Did you set it up on DocuSign to send the document for signature? Do you see in smartsheet that status changes to "Sent"
The Real Smartsheet Enthusiast
Is there anything else we can help you with? - book your time!
MASA Consult - Your Aligned Smartsheet Partner
Find us on LinkedIn!
-
Thank you. There must be something wrong with the mapping - SS says the automation was successful, but no document is received by the user and the status row is not updated.
When I generate the same document FROM docusign, the document sends fine, but still does not attach to the row or update status.
Any suggested next steps?
-
Hey,
When you go to Generate Document and you generate it manually (the option when it says Generate and Save as Attachment or Download) there should be this status bar showing if the document is really generated (does not matter if PDF or DocuSign) does it go till the end and is green?
I had issues with DocuSign and Smartsheet showing that document was generated but actually it was not because I used all the "tokens" for DocuSign - i think its worth checking.
The Real Smartsheet Enthusiast
Is there anything else we can help you with? - book your time!
MASA Consult - Your Aligned Smartsheet Partner
Find us on LinkedIn!
-
Thank you all for the help. I re-did the mapping, made sure the email field column was a contact list column and tried again. That seemed to work. Appreciate your quick responses.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives