I’ve encountered an unusual scenario where running the full query retrieves around 1,000 records. However, when I manually filter by EID (e.g., EID = xxxxx) with the same additional filters, the records qualify in the preview tab but do not appear when I run the query activity. Specifically, Record ...

Hi there,  I’m trying to understand how the incremental query handles exclusions. Suppose there were 5 records created yesterday with values for EID, VIN, and FEATURE_NAME. Today, when the incremental query runs, 2 new records are created with the same EID and VIN but different FEATURE_NAME values. ...

Hi everyone I have a requirement where, based on the value of targetdata.column1 (e.g., value1), the HTML email template should render only the top 3 blocks.To provide more context:The HTML template contains multiple rows that are arranged in order of priority, such as:Row 1Row 2Row 3Row4If targetda...

Preloading ActivityCan I use the preloading activity to check if a user has already submitted a response in the custom schema I’ve created, and then redirect them to a "Thank You" page?To achieve this:Should I be using the Preloading activity, Test activity, or JS activity?In my schema, I have the c...

Hi @isahore , Could you please provide further clarification on the suggestion you mentioned below:You mentioned that it's possible to check during preloading whether a recipient's response already exists in the responses table. If a response is found, the recipient can be redirected to the thank yo...

Hi @_Manoj_Kumar_ , I have a follow-up question. Could you please guide me on how to check if a response has already been logged for a customer, and if so, how to redirect them to the 'Thank you' page?  I am trying to use a JavaScript activity just before the Page 4 activity, but I’m unsure whether ...

Hi @ashish1212 , Thank you for your response. I currently have both questions on the same page activity, allowing users to respond. However, is it possible to achieve this using a JavaScript activity before the page activity? For example, I want to check if the email address and featurename1 exist i...

Hi there, Is it possible to retrieve parameters from the URL and check whether a response has already been submitted in the custom schema I created? I want to perform this check when a user clicks on the WebApp Survey link in the email. I’ve defined variables and set them as parameters under the Web...

Hi @_Manoj_Kumar_ , Thank you for your assistance. The code below successfully enabled me to decrypt the email string and store it in the corresponding schema column.. ctx.vars.key256Bytes = "fFKwuLzAsmMYoY6f1lxpMKuFSTWLCgdc"; ctx.vars.Email_Address = ctx.vars.Email_Address.toString(); ctx.FOD_Surve...

Update: @_Manoj_Kumar_ I have used the following JavaScript code, but while the survey responses are being captured in the schema, the email address is not being recorded. Could you please provide some suggestions? Thank you in advance. ctx.vars.key32Bytes = "fFKwuLzAsmMYoY6f1lxpMKuFSTWLCgdc"; ctx.v...