Have an app that logs information into a Google sheet with Zapier. Once the information is entered, I need to create a log/job reference number and send it on to another app in a dispatch.
I have a work request app where a person can choose what type of work needs to be done. Example.. We have to replace bad valves. When someone creates a work request to replace one of these bad valves, I would like it to log the request into a Bad Valve spreadsheet and return a job reference number. First one submitted BV-0001, BV-0002, etc.. on and on..
The number could be the same as the row number. Not sure how to get the row value to translate into data that I can use.
Anyone have any ideas or suggestions on how I could do this?