I am creating a google form for an upcoming auction. When bidders arrive at the auction, we will ask them to fill out the basic google form (that is, name, address, identifier), and the "bidder identifier" will be automatically generated based on the line number in the response spreadsheet.
What I would like to do is, as soon as the form is submitted, the confirmation message contains their βBidder IDβ. The spreadsheet is designed to set the bidder ID in column J. Is this even possible? Please let me know if further information is required.
Many thanks. Ben
source
share