I am having some issues creating what I thought would be a fairly simple rotating roster which tags users on Slack.
The Zapier looks something like this:
- Trigger: Every Week
- Get or Set a Value (Assigns a value to a key called “Week”)
- Lookup Spreadsheet Row in Google Sheets (Searches a “Week” column for a number matching the value stored in the “Week” Key from the previous step.)
- Send Channel Message in Slack (Tags the staff who are rostered on that week according to the spreadsheet)
- Increment Value (Increase the “Week” key by 1, so that when it triggers the following week it searches and tags the users for that week)
- Set Value If - This is my problem step.
Once the value of the key reaches 9 I want it to re-set the value to 1. This is because the rotating roster only accounts for 8 weeks before it needs to go back to the beginning and start over. However, in the Set Up Action step for this I have the “Previous Value - Only set the value if the stored value matches this” set to 9.
I can confirm that the stored value is definitely 9 by reviewing the output in the “Get or Set a Value Step”. I have also confirmed it by adding a Lookup Table step afterwards.
Despite all this I am still receiving an error saying:
The app returned `{"message":"Stored value does not match previous value."}
Please help!