I know from this discussion (https://community.gainsight.com/conversations/date-field-gainsight-survey-5bc73e0ce4b04588aaf86072) we don't have the option for a date response from surveys today. We have a 'next filing date' field in Salesforce that we are really hoping to populate based on responses to a survey question. IF the participant responds in a standard MM/DD/YYYY format, is there a way we can convert this to be able to use a rule to populate a date field?
Page 1 / 1
Hi Katie,
Since you are loading to salesforce, one option would be to create the target field as string field and create a new formula field to parse that string value to date format. (or use some trigger to populate a normal date field)
https://success.salesforce.com/answers?id=9063A0000019UiAQAU
If you need to do it with rule itself, you will have to use 2 rules. One rule to load the data to S3 bucket and then another to read the csv file from S3. While reading, you can configure the field as date and define the format.
Since you are loading to salesforce, one option would be to create the target field as string field and create a new formula field to parse that string value to date format. (or use some trigger to populate a normal date field)
https://success.salesforce.com/answers?id=9063A0000019UiAQAU
If you need to do it with rule itself, you will have to use 2 rules. One rule to load the data to S3 bucket and then another to read the csv file from S3. While reading, you can configure the field as date and define the format.
Thanks, I think I'll be getting our SF team involved in this one.
Reply
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.