How to Ensure Each Record Can Be Selected Only Once in a Repeatable Table with an External Query (Salesforce) 📋 Use CaseYou have a repeatable product selection question group with a query, and need to prevent users from selecting the same record multiple times. ✅ Pre-RequisitesBefore you begin, confirm the following: Familiarity with SOQL External Query syntax. Knowledge of repeatable question groups. Unique value of the records that can be used as a filter 🧭 Step-by-Step Instructions1️⃣ Create a copy of the unique value in the Repeatable Group In your repeatable question group, add a Text question. Reference the unique value you want to exclude on the 2nd attempt, for example: QG1.DealHub_Subscription__cId_copy Include a comma and a single quote (' ) at the beginning (after the comma) and end. ,'%QG1.DealHub_Subscription__cId%' 2️⃣ Aggregate Ids Outside the Repeatable Group Outside the repeatable group, create a Text answer. Reference the Id copy field you created in Step 1 Add parentheses ( ) Add a dummy value (for null cases), to be first, make sure it is quoted ' '. (if i