This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.
I'm trying to do the following.
After a new sale, pick a serial number from a Google Sheet and send this serial number and the buyer as an email including that serial number.
I'm stuck at “lookup value” .. I'm not able to choose the value which is serial number from Google Sheet.
I have two columns in Google Sheet, serial numbers and used yes or no.
Can someone help me to do this setup? Basically, a new sale, pick a serial number from these, mark it as used, send this as an email to the customer.
