Auto-completing after a specific page

This procedure sets up Experience Cloud for Automatically completing surveys that survey takers abandoned, but where they navigated off a specific page.

To set up automatic completion:

  1. Create a Feedback field to identify records ready to be exported upon survey expiration.

    FieldValueNotes
    NameAuto-complete eligibility
    Field IDq_company_autocomplete_ready_ynWhere company is the company name.
    Data typeChoice set (Yes/No)
    Used for Duplicate CheckingSelected
  2. Create an Event field to track if the record was automatically completed. This is useful as Filter and Responses List column.

    FieldValue
    NameAuto-completed record
    Field IDe_company_auto_complete_yn
    Data typeChoice set (Yes/No)
    Short nameAuto-completed record
  3. Create an Event field to track when the record was automatically completed.

    FieldValue
    NameAuto-completed date
    Field IDe_company_auto_complete_date
    Data typeDate
    ShortAuto-completed date
  4. For every survey to be automatically completed:

    1. Determine the completion page by asking the company after which survey page the survey can be considered complete.

    2. On Survey editor, add a Hidden field to the first page of the survey. On the Advanced tab, set the following:

      • Question ID — Enter the Field ID from the Auto-complete eligibility Feedback field created above.

      • Internal name — Hidden Auto-complete eligibility.

        Hidden field with Field ID "Auto Complete Eligibility".

    3. On the survey page that the company identified as the completion page, click its Logic tab, select Add validation with JavaScript, and enter the following script:

      function setAutocomplete() {
       fields.set('q_[company]_autocomplete_ready_yn','1');
      }
      setAutocomplete();
      Use the Feedback field created above. This script sets the field to Yes when the survey taker navigates off this page (clicks Next) and stores the value in the field.
      Tip: If the survey is a Flex survey, take the flex behavior into account when determining the completion page.

      Logic tab with Add validation with JavaScript and code snippet.

  5. Create an Importer to perform the update that automatically completes the exported surveys. For more information, see Auto-complete import/update specification. Customize the template as you see fit.

  6. Create an Exporter:

    Export details tab

    FieldValueNotes
    Name Auto-completion Daily export
    File nameAuto-completion Daily export
    Fields
    • Survey ID (a_surveyid)
    • Last page seen (a_last_seen_page_name)
    • Creation date (e_creationdate)
    • Invitation date (e_invitationdate)

    • Survey status (e_status)

    • Any fields needed for alert processing.

    The only required field is Survey ID. The other listed fields are all optional.
    Time periodExport records since last export
    Time fieldExpiration date (e_expirationdate)
    Survey condition a_survey_is_partial in {1}Optional. Records excluded are not be marked as completed as part of the auto-completion process. Otherwise, records that excluded are set again to completed.
    Filtering conditionRecords must match all fields (AND condition)See step 7 for conditions
    Exclude partially completed invite (non-feedless) surveysUnselected (for Personalized invitation surveys)
    Exclude partially completed feedless surveysUnselected (for Anonymous surveys)

    Schedule & Destination tab

    SectionFieldValueNotes
    ScheduleCheckmark icon
    Frequency byDays of the week

    Every day of the week

    TimeOnce a day
    Run03:00
    TimezoneDefault (PST)
    ConnectionManual
    Notification email
    Success email report to your.email@example.com It is important to read these emails every day
    Failure email report to your.email@example.comIt is important to read these emails every day
  7. Add these Filtering conditions to the export:

    Field nameField IDOperatorValueNotesExample
    Auto-complete eligibilityq_company_autocomplete_ready_ynEquals11=YesAuto-complete eligibility = Yes
    Programe_program_altEqualsXA condition (flag) that identifies the survey program to limit the export to this program only.Program= Sales
    Statuse_statusNot equals{0,1,4,24}A condition to limit the export to surveys that do not have status COMPLETION PENDING (0), COMPLETED (1), EXCLUDED (4), and AUTO EXCLUDED (24). Status != {0,1,4,24}
    Not auto-completede_company_auto_complete_ynNot equals including nullYesField created in step 2. Auto-completed record != Yes
    Note: Expired surveys are hard to determine when the survey is ready to be flagged for auto-completion (the Survey status 16: Expired is only set when the survey taker tries to take an expired survey).
  8. Optionally (but recommended), on Responses Form, add an element that indicates when the record was automatically completed so the user is aware of this date if they close the loop with the respondent. Use the Auto-completed date field.

The survey completion process should now run once a day.