GoSpotChat: Your AI Assistant for Advanced Logic
Transform complex logic into simple conversations
GoSpotChat is an AI-powered chatbot designed to help GoSpotCheck Admins easily create Advanced Logic statements in sqlite, making it simple to build dynamic Missions that update in real-time based on users’ mobile responses. Instead of wrestling with complex SQL-like syntax, simply tell GoSpotChat what you want your mission to do, and it will generate the appropriate logic rules for you.
What is Advanced Logic?
Advanced Logic allows you to create dynamic, intelligent missions that adapt based on how mobile users respond. For example:
- Show different questions based on previous answers
- Calculate scores and display results automatically
- Filter product catalogs based on user selections
- Hide irrelevant sections to streamline the user experience
How GoSpotChat Helps
The Old Way vs. The New Way
Before GoSpotChat:
IF T1 IN ('BrandA', 'BrandB', 'BrandC') THEN SHOW T2-5 ON RESPONSEWith GoSpotChat: "Show the beverage questions only when BrandA, BrandB, or BrandC is selected"
GoSpotChat transforms your plain English request into the proper Advanced Logic syntax automatically.
How to Use GoSpotChat
Getting Started with AI Conversation
GoSpotChat is designed for comfort and ease of use—even for new or non-technical Admins:
- Begin by typing a plain-English description of your desired outcome (e.g., “Hide task 5 if the user selects ‘No’ in task 1”).
- Ask GoSpotChat to review, validate, or explain an existing rule, and get instant suggestions for corrections.
- If uncertain, request an example (“Show me logic for dynamically filtering catalog items by property type”).
- For each response, GoSpotChat offers not just the statement, but also a short explanation—helping Admins build confidence and understanding over time.
- There’s no risk—ask follow-up questions or try different phrasing to get help tailored to your Mission’s needs.
Practical Examples
Example 1: Conditional Question Display
Your request: "Only show the competitor pricing section when the store carries our product"
What GoSpotChat creates:
/* Show competitor section based on product availability */ IF T2 = 'Yes' THEN SHOW SB ON RESPONSE
Example 2: Dynamic Scoring
Your request: "Calculate the total audit score from all the compliance questions and show it at the end"
What GoSpotChat creates:
/* Calculate and display total compliance score */ IF ALWAYS THEN SET VALUE total_compliance TO SCORE(SC) ON RESPONSE IF ALWAYS THEN SET VALUE compliance_percentage TO (SCORE(SC) / MAX_SCORE(SC)) * 100 ON RESPONSE
Example 3: Smart Product Filtering
Your request: "When someone selects Coca-Cola brands, only show Coca-Cola products in the inventory task"
What GoSpotChat creates:
/* Filter inventory to selected brand family */ IF SA.T1 = 'Coca-Cola' THEN FILTER SB.T3 TO items.brand_family = 'Coca-Cola' ON RESPONSE
Example 4: Date-Based Logic
Your request: "Show the weekend checklist only on Saturdays and Sundays"
What GoSpotChat creates:
/* Weekend-specific tasks */
IF STRFTIME('%w', 'now') IN ('0', '6') THEN SHOW weekend_section ON START
Example 5: Complex Calculations
Your request: "Calculate the weighted score where shelf presence is worth 40%, pricing is 30%, and promotion compliance is 30%"
What GoSpotChat creates:
/* Weighted scoring calculation */ IF ALWAYS THEN SET VALUE weighted_total TO (SCORE(SA) * 0.4) + (SCORE(SB) * 0.3) + (SCORE(SC) * 0.3) ON RESPONSE
Tips for Success
Common Use Cases
Product Presence Missions
- Filter product catalogs based on brand selection
- Show different compliance checklists per category
- Calculate availability percentages by brand
Audit Missions
- Progressive question display based on compliance levels
- Weighted scoring for different audit categories
- Automatic pass/fail determination
Competitive Intelligence
- Show competitor sections only when competitors are present
- Dynamic pricing comparisons based on product availability
- Territory-specific question sets
Promotional Compliance
- Date-based promotional material checks
- Display size-specific compliance questions
- Calculate compliance scores with custom weighting
Getting Help
If you're not getting the results you want:
- Be more specific: Add details about when, where, and how the logic should work
- Reference your mission structure: Use section names and task descriptions GoSpotChat can understand
- Ask for alternatives: "Is there another way to do this?" or "What other options do I have?"
- Request step-by-step help: "Can you break this down into simpler rules?"
Remember: GoSpotChat learns from each interaction in your conversation. If the first attempt isn't perfect, simply describe what needs to change, and it will adjust accordingly.
GoSpotChat makes Advanced Logic accessible to everyone, regardless of technical background. Focus on describing your business logic clearly, and let the AI handle the technical implementation.
GoSpotChat is available as an extension to all customers with Advanced Logic enabled. Reach out to your Account Manager for details.