I'm very close to finishing the build out of our customer survey. I have the custom record, online form with custom html template, a saved search to select the recipients, and a couple of workflows to send the email template and populate dates and checkboxes.
I'm just struggling with 2 things.
1. the URL parameters in the email template for the survey send don't seem to be fully working. the URL renders correctly:
https://4351677.extforms.netsuite.com/app/site/crm/externalcustrecordpage.nl?compid=4351677&formid=6&h=AACffht_zlvjhtgO4QaSYQuk3omUWGpHqWQ&custrecord_customer=471964&custrecord_recentorderlink=1402937
but the "recentorderlink" field does not get populated, while the customer does. I made it a free text field to test and still nothing populates that field
2. I need a way to tell the search to skip the send if the customer already received a survey in the past 6 months. Since the emails are being sent from the transaction, and the search is a transaction search, I need a STORED value field on the customer that shows the "Date last survey send". I can get that on the transaction the email was sent from, but I can't figure out how to get that date back to a standard custom field on the customer, so I can use it as a search filter.
I suppose I could send the email from the customer record but I like the idea of tying the transaction to the survey too (even though as in step 1, that isn't working yet either)
any ideas?