I am setting up a google form for an upcoming auction. As bidders arrive at the auction, we will have them fill out a basic google form (i.e. name, address, ID) and a a 'Bidder ID' is auto generated based on the row number in the response spreadsheet.
What I would like to happen is once the form is submitted, the confirmation message includes their 'Bidder ID'. The spreadsheet is setup to put the Bidder ID in Column J. Is this possible at all? Please let me know if more information is required.
Many thanks. Ben