Adobe Campaign Survey - Save Variables into Database

I had a scenario where I need to show some questions depending on the answers of a previous question.
For example, the below test scenario
So I created the Archive field for all the questions including the Radio button and Drop down one which will be used for the dynamic criteria. I had setup the visibility of the field using the Archive Field. But while previewing I realized that the questions are getting shown or hidden depending on selection (example below).

So I created two new variables for the survey with names as How_was_your_last_hopital_visit and Was_your_out_of_pocket_expenses_over_budget_.
Then changed the visibility criteria to use the variables. Now it is working perfectly. But when I saved the survey, it doesn't save the data of those variables. But I need those selections as well.
So I added a javascript task before the Storage activity and set the tables fields from the variables so that when it is in the storage activity, it column value is populated from the variable already

Here is the js activity code
var How_was_your_last_hopital_visit = ctx.vars.How_was_your_last_hopital_visit;
var Was_your_out_of_pocket_expenses_over_budget_ = ctx.vars.Was_your_out_of_pocket_expenses_over_budget_;

logInfo("How_was_your_last_hopital_visit:" + How_was_your_last_hopital_visit);
logInfo("Was_your_out_of_pocket_expenses_over_budget_:" + Was_your_out_of_pocket_expenses_over_budget_);

ctx.webAppLogRecipientData.How_was_your_last_hopital_visit = How_was_your_last_hopital_visit;
ctx.webAppLogRecipientData.Was_your_out_of_pocket_expenses_over_budget_ = Was_your_out_of_pocket_expenses_over_budget_;

Note: ctx.webAppLogRecipientData part will be as per the table you selected into your survey. Enable the debug in preview to get the actual name of the table

And here is the workflow

So, here is the summary
  • Create the variable in survey properties
  • Use the variable inside workflow
  • Create Archive field to store the variables
  • Add a Script activity before Storage Activity 
  • Update the ctx.surveyResponsetableName.ArchiveField=ctx.vars.VariableName

Comments

Post a Comment

Popular posts from this blog

Avoid Proxy for HttpClientRequest - IOB-090007 Network error (send(), errno=10054: an existing connection was forcibly closed by the remote host

This is Friday night 8:10 PM and I was frustratingly stuck with an annoying issue on something that I have done so many times, but still unable to figure out what is wrong since last night. Finally it was a silly mistake and I found that. So wanted to capture it so that I don't need to spend another day and half just to figure out why the same thing is not working I was making a call to Silverpop XMLAPI to get the jessionid via the login method. And the code is something like below, very basic one var http = new HttpClientRequest ( "http://api2.ibmmarketingcloud.com/XMLAPI" ); try { http . method = 'POST' ; http . header [ "ClientId_Internal" ] = "XYZABCD" ; http . header [ "ClientSecret_Internal" ] = "DSFDSOFNJSDF" ; http . header [ "Content-Type" ] = "application/x-www-form-urlencoded" ; var reqestBody = "xml=" + encodeURIComponent ( "<
Read more

Adobe Campaign: Call Java Script from Input Form

I came across a scenario where I need to do some custom auditing when some fields are  changed via an input form. So for that I had to call javascript functions from an input form. I have custom schema as cus:Preference with 1:1 join with nms:Recipient. And audit was required to capture who is making change to the preference page if any. Step 1: Create an entry in the input form for the soapCall.  <form>   <container > <!--Enter the form fields here-->   </container>   <leave> <!--servi = "name of the schema where the method is declared"-->     <soapCall name=" auditPreference " service=" cus:Preference ">       <param exprIn="[@id]" type="int"/>       <param exprIn="[@recipientId]" type="int"/>       <param exprIn="[@prefAllCommunications]" type="boolean"/>       <param exprIn="[@prefAllCommunicationsModifiedDat
Read more

Broadlog Resequencing in Adobe Campaign Classic

 As we all know, the max value for any auto primary key field in Adobe is limited by the max of int which is 2.15B [[+/-) 2,147,483,647]]. As ACC doesn't support bigint as the auto pk column data type, you have to recycle the number every time it reaches near to that 2.14B mark.  Now Broadlog tables being the most heavily used table in ACC, we observe the issue often with this table but this can happen with other tables as well like Tracking and so on. It is not difficult to recycle the value of the sequence in ACC, but most of the time the BL and TL data is shared with downstream systems. So, once you reset the sequence, you have to make sure the downstream system knows about it and handle it properly without overwriting the existing historical records. And that is where these types of challenges are faced How do we inform downstream when ACC is resetting its sequence If downstream is managing the uniqueness of the records, then they have to prefix something to make sure it is uni
Read more