Hi Guys,
This might be a long shot. My team needs a way for our sheet to automatically assign an ID to a web form entry based on some pre-existing set of meaningful ID numbers.
e.g. a handyman was called out to the customer's house to do maintenance work. we have a reference number for that particular job callout (say, #101). the customer is given a link to submit feedback on that callout. when they submit their feedback, their entry is automatically assigned the reference number of the callout on the back end of the sheet. That is, their row already has a column with #101 on it.
Any help on this would be greatly appreciated! I would love to be able to find a solution within smartsheet - rather than have to move this to survey monkey.
Thank you
