Hi,
I've got a sheet (Deals) which tracks the status of various deals and when the Status of the deals is marked as "Complete" it triggers an automation to send the owner an alert. The alert tells the owner they need to add a record to a different tracker (Live Deals) and includes a link to a Form to capture data for this. I want to be able to pre-populate the "Deal Name" fields in this Form.
I've followed the guidance on URL Queries for Forms: https://help.smartsheet.com/articles/2478871-url-query-string-form-default-values
And I'm aware that in the Alert Someone workflow I can customize the message with placeholders in {{ }}, for example {{Deal Name}}
I've tried combining these two concepts by including the following url in my alert message:
https://app.smartsheet.com/b/form/xxxxxxxxxxxxx?Deal%20Name={{Deal Name}}
When I test this automation, the url I receive in the alert works OK if the value in the Deal Name column is one word, e.g. "Test", then this is populated as the default value in the form. Nice.
However, if the Deal Name is two or more words, e.g. "Test Deal", then only the first word is captured. I assume this is cos the Smartsheet automation doesn't automatically add %20 to replace spaces when its reading the {{Deal Name}} placeholder.
Is there a workaround for this?
Is there another approach for pre-populating a default value in a form that I've overlooked?