Answered
AIMS System Administrator
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?
0
Comments
Please sign in to leave a comment.
So you need both the label (BV) and the number generated, right?
To get the labels going, I'd do a whole mess of hidden conditional fields. Basically, if the field where you're deciding to replace bad valves = Bad Valves, there would be a corresponding hidden field that said BV. That will allow you to map those into a column on the sheet through Zapier.
For the numbers, it looks like you CAN get the row # from Google Sheets:
So I'd just put that into the Dispatch as the column you've written that to from the hidden fields in the App then - then the row number.
Does that get you there, Keith?
There can never be a number 1, but yes, this works. Thanks Sara!
You're number 1, Keith :)