Update requests - Send 1 update request for multiple rows to the contact that is listed in sheet
Hi everyone,
Here is my issue. I have a sheet of sales people that are from multiple different companies that tracks their YTD sales numbers. I want to build an automation/workflow that sends one update request with a form to update ALL of that contact's producer with one click. So if one of my partners has 10 sales people they get 1 update request link that takes them to a page where they can enter them one by one. Last year I had to build a separate automation/workflow for each partner and in the actions section I had to specify their e-mail address. Since I track this quarterly I had to build 4 workflows for each partner. Now I have 24 partners with at lease 4 or 5 sales people each which means I'll have to build 96 workflows to accomplish this.
So I added a column in the sheet that specifies who their sales manager is, and built a workflow to send an update request to the contact listed in that column. The problem is that instead of each sales manager getting one email with a link to enter data for all of their sales people, the partner receives an email for every salesperson they manage and have to click each link and can only update that specific person. So a sales mgr that manages 10 people gets 10 emails (super annoying for them, even though it's less programming for me).
Any ideas would be most appreciated!
Answers
-
Update requests can be combined under only certain circumstances. Without the all the details of your automation, it would be hard to tell what is causing them to be sent separately, but this article might help:
Trigger blocks: When your workflow is executed | Smartsheet Learning Center
Other reasons why they may not be combined include if you are inserting references to the row data in the message or message header. I believe there is also a maximum number of update requests that can be combined.
Here is some additional info on that:
Placeholders in Alert someone or Update Requests actions in change-based workflows generate separate notifications if six or fewer rows are triggered simultaneously. If seven or more rows are triggered at once, the system removes the custom subject and body.
Customize the content of your alerts and requests | Smartsheet Learning Center
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives