Trying to do an incrementing number that doesn’t reset each zap and having the worst time. Any ideas about that or this question?
Best answer by KelseyBratcher
View original
Can I lookup a cell in google sheets? I want to lookup the same one each time
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
Userlevel 2
- Certified Zapier Expert
- 5 replies
-
19 August 2020
- Answer
Make a sheet with at least 2 columns and 1 row.
Column 1: ID (I make this 1)
Column 2: value you want to retrieve
Use a look up row action to find the row with the ID (1 in my example). Then it always fetches the same row with whatever the value is.
This makes it easy for a non-zapier user to change it if need be.
I built a case number generator for an attorney. Every now and then. the case number gets broken and needs to be reset. Rather than using storage, which is kind of cumbersome for this purpose, I used sheets so one of his team members could go and manually change the value to whatever the next case number should be.
After a case is generated I also had an action that would take that field and +1 to whatever the value is.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.