I have a sheet called 'Farmer Access Survey' which will contain the current data we hold on record for 130 farmers. I have created a form, which I want to send to each farmer to confirm the current data we hold, and collect additional information from them.
Can I send a link to the Form to each individual in an Outlook email, and when they click on the form link, have the form open up pre-populated with the data we already have on file for them?
I don't want the farmers to have to populate a blank form when we already have a lot of their data. I do not want to send an update request, as the form looks much more professional and I need the descriptions.
I have seen a number of references to using the following URL query formula and others similar to it (which refers to the first two columns I'd like to pre-populate) like this: =https://app.smartsheet.com/b/form/06a1e7297b1a4d6a80a9796e06d7062b?Shareholder&20Name="+SUBSTITUTE([Shareholder Name]@row," ","%20") ;Property&20Name="+SUBSTITUTE([Property Name]@row," ","%20")
I cannot get this to work. Is what I want to do is actually possible?
What is the correct formula to use? My sheet has multiple columns but the first few I would want to pre-populate for each farmer is Shareholder Name, Property Name, Contact 1 Name, Contact 1 Position, Contact 1 Telephone.
We planned on copying the link from each row into the individual farmers' emails in Outlook (as we have another item to attach and a cover email to explain the form). Will it still pre-populate with the row information from that email? If not, what would be the best way to share the link to each farmer?
I've attached images of the sheet and the form. The sheet only has one line of placeholder data in it at the moment.
Thanks so much for any assistance.