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
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.