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
Can I lookup a cell in google sheets? I want to lookup the same one each time
- Beginner
- 2 replies
Best answer by KelseyBratcherBest answer by KelseyBratcher
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.
1 person likes this
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
- Zapier Expert
- 5 replies
- 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.
15,000,000+ minutes saved and counting! https://zapier.com/productivity-calculator/
1 person likes this
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.