Built on Bubble
Built on Bubble
Tables:
1. validation_cache
- email (text, unique)
- phone (text)
- validation_result (text, JSON)
- last_validated (date)
- service_type (text)
2. api_usage_log
- service_name (text)
- date (date)
- calls_count (number)
- user (User)
3. security_events
- event_type (text)
- ip_address (text)
- country (text)
- user (User)
- timestamp (date)
- details (text, JSON)
| Element | State | Type | Purpose |
|---|---|---|---|
| Page | email_validation_result | text | Store complete result |
| Page | phone_validation_result | text | Store complete result |
| Page | current_location | text | Geolocation information |
| Page | security_level | text | Calculated security level |
| Input Email | is_validating | yes/no | Validation state control |
| Input Phone | is_validating | yes/no | Validation state control |
Required elements:
- Input "email_input" (type: email)
- Button "validate_email" (initially disabled)
- Group "email_result" (initially invisible)
- Text "email_status" (inside group)
- Icon "email_icon" (for visual feedback)
- Text "email_details" (additional information)
Workflow: "Validate Email Complete"
Trigger: When Button "validate_email" is clicked
Condition: Input email_input's value is not empty
Step 1: Set state email_input "is_validating"
- Value: yes
Step 2: Show loading indicator
- Set Icon email_icon: loading spinner
Step 3: Validate Email (Smart Identity Validator Suite)
- email: Input email_input's value
- auto_correct: yes
Step 4: Set state "email_validation_result"
- Value: Smart Identity Validator Suite's formatted as JSON
Step 5: Determine validation status
- Set Text email_status's text:
- If deliverability = "DELIVERABLE": "✅ Valid email"
- If deliverability = "UNDELIVERABLE": "❌ Invalid email"
- If deliverability = "UNKNOWN": "⚠️ Unknown status"
Step 6: Show detailed information
- Set Text email_details's text:
"Quality: " + Smart Identity Validator Suite's quality_score + "/1.0" +
"Free provider: " + Smart Identity Validator Suite's is_free_email +
"Disposable email: " + Smart Identity Validator Suite's is_disposable_email
Step 7: Update icon based on result
- Set Icon email_icon:
- Green check if deliverability = "DELIVERABLE"
- Red X if deliverability = "UNDELIVERABLE"
- Yellow warning if deliverability = "UNKNOWN"
Step 8: Show result group
- Show Group email_result
Step 9: Set state email_input "is_validating"
- Value: no
Step 10: Log validation event
- Create api_usage_log:
- service_name: "email_validation"
- date: current date
- calls_count: 1
- user: current user
Workflow: "Auto Validate Email"
Trigger: When Input email_input's value changes
Condition: Input email_input's value contains "@" AND Input email_input's value contains "."
Wait: 2 seconds (only when current step hasn't been canceled)
Step 1: Search in validation_cache
- email = Input email_input's value
- last_validated > current date/time - days(7)
Step 2: Use cached result if exists
- Only when: Search result is not empty
- Set state "email_validation_result": Search result's validation_result
- Show cached feedback
Step 3: Perform new validation if not cached
- Only when: Search result is empty
- Run workflow "Validate Email Complete"
Step 4: Cache new result
- Only when: Search result is empty AND no error from validation
- Create validation_cache:
- email: Input email_input's value
- validation_result: Smart Identity Validator Suite's formatted as JSON
- last_validated: current date/time
- service_type: "email_validation"
Required elements:
- Input "phone_input" (type: tel)
- Text "phone_country" (show detected country)
- Text "phone_carrier" (show carrier)
- Text "phone_type" (mobile/landline)
- Group "phone_result" (initially invisible)
- Button "format_phone" (optional)
Workflow: "Clean Phone Number"
Trigger: When Input phone_input's value changes
Condition: Input phone_input's value's length > 5
Step 1: Clean input format
- Set Input phone_input's value:
Input phone_input's value:find & replace "-" → "":find & replace " " → "":find & replace "(" → "":find & replace ")" → "":find & replace "." → ""
Step 2: Add country prefix if missing
- If Input phone_input's value doesn't start with "+"
- Set Input phone_input's value: "+" + Input phone_input's value
Workflow: "Validate and Format Phone"
Trigger: When Input phone_input's value changes
Condition: Input phone_input's value's length > 8
Wait: 3 seconds
Step 1: Set validating state
- Set state phone_input "is_validating": yes
Step 2: Validate Phone (Smart Identity Validator Suite)
- phone: Input phone_input's value
Step 3: Update with international format
- Only when: Smart Identity Validator Suite's valid = "yes"
- Set Input phone_input's value: Smart Identity Validator Suite's format_international
Step 4: Display country information
- Set Text phone_country: Smart Identity Validator Suite's country_name + " (" + Smart Identity Validator Suite's country_code + ")"
Step 5: Display carrier information
- Set Text phone_carrier: Smart Identity Validator Suite's carrier
Step 6: Display line type
- Set Text phone_type:
- If line_type = "mobile": "📱 Mobile"
- If line_type = "landline": "☎️ Landline"
- If line_type = "toll_free": "🆓 Toll Free"
Step 7: Visual feedback
- Set Input phone_input's border color:
- Green if valid = "yes"
- Red if valid = "no"
Step 8: Show result group
- Show Group phone_result
- Only when: Smart Identity Validator Suite's valid = "yes"
Step 9: Set validating state
- Set state phone_input "is_validating": no
Required elements:
- Input "vat_input" (placeholder: "e.g.: ES12345678Z")
- Text "company_name"
- Text "company_address"
- Text "company_country"
- Checkbox "vat_registered" (disabled)
- Group "company_info" (invisible)
- Button "load_company_data"
Workflow: "Load Company from VAT"
Trigger: When Button "load_company_data" is clicked OR When Input vat_input loses focus
Condition: Input vat_input's value's length > 8
Step 1: Validate VAT (Smart Identity Validator Suite)
- vat_number: Input vat_input's value
Step 2: Populate company information
- Only when: Smart Identity Validator Suite's valid = "yes"
- Set Text company_name: Smart Identity Validator Suite's company_name
- Set Text company_address: Smart Identity Validator Suite's company_address
- Set Text company_country: Smart Identity Validator Suite's company_country
Step 3: Update VAT status
- Set Checkbox vat_registered:
- Checked: Smart Identity Validator Suite's vat_registered = "yes"
- Disabled: yes (read-only)
Step 4: Show company information
- Show Group company_info
- Only when: Smart Identity Validator Suite's valid = "yes"
Step 5: Calculate tax implications
- Set custom state "tax_rate":
- 21% if company_country = current app country
- 0% if company_country is EU but different
- Show manual entry if outside EU
Step 6: Enable/disable business features
- Enable B2B workflows if VAT is valid
- Show business-specific UI elements
Required elements:
- IP Geolocation element (invisible on page)
- Group "security_info"
- Text "current_location"
- Text "isp_info"
- Text "security_warnings"
- Image "country_flag"
- Map element (optional)
Workflow: "Load Security Information"
Trigger: When page is loaded
Step 1: Initialize IP Geolocation
- Element IP Geolocation loads automatically
Workflow: "Process Geolocation Data"
Trigger: When IP Geolocation data is loaded
Step 1: Store location data
- Set state "current_location": IP Geolocation's formatted as JSON
Step 2: Display location information
- Set Text current_location: IP Geolocation's city + ", " + IP Geolocation's region + ", " + IP Geolocation's country
Step 3: Display ISP information
- Set Text isp_info: IP Geolocation's connection_isp_name + " (" + IP Geolocation's connection_connection_type + ")"
Step 4: Security analysis
- Set Text security_warnings:
- If security_is_vpn = "yes": "⚠️ VPN connection detected"
- If country not in allowed list: "🚨 Access from restricted country"
- Otherwise: "✅ Secure connection"
Step 5: Display country flag
- Set Image country_flag: IP Geolocation's flag_png
Step 6: Log security event
- Create security_events:
- event_type: "page_access"
- ip_address: IP Geolocation's ip_address
- country: IP Geolocation's country
- user: current user
- timestamp: current date/time
- details: IP Geolocation's formatted as JSON
Step 7: Trigger security checks
- If IP Geolocation's country in restricted list:
- Send alert to admin
- Log high-priority security event
- Show additional verification UI
Required elements:
- Input "user_name"
- Dropdown "avatar_size" (values: 64, 128, 256, 512)
- Input "background_color" (type: color)
- Input "font_color" (type: color)
- Checkbox "is_rounded"
- Image "avatar_preview"
- Button "generate_avatar"
- Button "save_avatar"
Workflow: "Generate Dynamic Avatar"
Trigger: When Input user_name's value changes OR any customization option changes
Condition: Input user_name's value's length > 1
Wait: 1 second
Step 1: Generate Avatar (Smart Identity Validator Suite)
- name: Input user_name's value
- image_size: Dropdown avatar_size's value
- background_color: Input background_color's value (without #)
- font_color: Input font_color's value (without #)
- is_rounded: Checkbox is_rounded's value
Step 2: Update preview
- Set Image avatar_preview: Smart Identity Validator Suite's avatar_url
Step 3: Enable save button
- Set Button save_avatar disabled: no
Step 4: Store avatar URL in state
- Set state "generated_avatar_url": Smart Identity Validator Suite's avatar_url
Workflow: "Save Avatar to Profile"
Trigger: When Button "save_avatar" is clicked
Step 1: Update user profile
- Make changes to Current User:
- Profile Picture: state "generated_avatar_url"
- Avatar Settings: JSON with customization options
Step 2: Show success message
- Show alert: "Avatar updated successfully"
Step 3: Update all profile displays
- Refresh any profile image elements on page
Registration Page Elements:
├── Input: full_name
├── Input: email_address
├── Input: phone_number
├── Input: vat_number (conditional, for business)
├── Dropdown: account_type (personal/business)
├── Image: avatar_preview
├── Group: email_validation_feedback
├── Group: phone_validation_feedback
├── Group: company_info (conditional)
├── IP Geolocation element (invisible)
├── Button: register_account (disabled initially)
└── Group: terms_and_conditions
Workflow: "Complete Registration Process"
Trigger: When Button "register_account" is clicked
Condition: All validations passed
Step 1: Start registration process
- Show loading overlay
- Disable all inputs
Step 2: Generate user avatar
- Generate Avatar:
- name: Input full_name's value
- is_rounded: yes
- image_size: 256
Step 3: Gather location data
- Use IP Geolocation data (already loaded)
Step 4: Create user account
- Sign the user up:
- Email: Input email_address's value
- Password: (from password input)
- Full Name: Input full_name's value
- Phone: state "validated_phone_international"
- Avatar URL: Smart Identity Validator Suite's avatar_url
- Registration Country: IP Geolocation's country
- Registration City: IP Geolocation's city
- Registration IP: IP Geolocation's ip_address
- Account Type: Dropdown account_type's value
Step 5: Add company information (if business)
- Only when: Dropdown account_type's value = "business"
- Create Company:
- Owner: Created user
- VAT Number: Input vat_number's value
- Company Name: state "company_name"
- Address: state "company_address"
- Country: state "company_country"
Step 6: Log registration event
- Create security_events:
- event_type: "user_registration"
- ip_address: IP Geolocation's ip_address
- country: IP Geolocation's country
- user: Created user
- details: Complete registration data as JSON
Step 7: Send welcome communication
- Schedule API Workflow "Send Welcome Email":
- User: Created user
- Avatar URL: Smart Identity Validator Suite's avatar_url
Step 8: Navigate to dashboard
- Navigate to dashboard page
- Pass user data
Workflow: "Security Monitor Dashboard"
Trigger: When page is loaded (admin dashboard)
Step 1: Load current session data
- IP Geolocation auto-loads
Step 2: Query recent security events
- Search security_events:
- timestamp > current date/time - days(7)
- Order by timestamp descending
Step 3: Analyze patterns
- Count events by country
- Identify suspicious IP addresses
- Calculate security score
Step 4: Display security metrics
- Set Text "active_sessions": Count of current sessions
- Set Text "countries_today": Unique countries from today
- Set Text "vpn_connections": Count where VPN detected
Step 5: Real-time threat detection
- If unusual patterns detected:
- Send alert to security team
- Log high-priority event
- Show security warning
Workflow: "Real-time Email Security Check"
Trigger: When Button "check_email_security" is clicked
Step 1: Validate email structure
- Validate Email: Input security_email's value
Step 2: Check reputation data
- Check Email Reputation: Input security_email's value
Step 3: Comprehensive security analysis
- Set state "security_analysis":
{
"email_valid": Validate Email result,
"reputation_data": Email Reputation result,
"risk_score": calculated risk (0-100),
"recommendation": "allow/block/review"
}
Step 4: Display security report
- Show detailed security breakdown
- Color-code risk levels
- Provide actionable recommendations
Step 5: Auto-block if high risk
- If risk_score > 80:
- Add to blacklist
- Send admin notification
- Log security action
Workflow: "Smart Checkout Validation"
Trigger: When user proceeds to checkout
Step 1: Validate shipping information
- Validate Phone: Shipping phone number
- IP Geolocation: Check shipping region consistency
Step 2: Business customer detection
- If VAT number provided:
- Validate VAT
- Enable B2B pricing
- Apply business tax rules
Step 3: Fraud prevention
- Check Email Reputation: Customer email
- Analyze location consistency:
- IP location vs shipping address
- Phone country vs shipping country
Step 4: Dynamic security measures
- If fraud indicators detected:
- Require additional verification
- Limit payment methods
- Flag order for manual review
Step 5: Personalization
- Generate Avatar for new customers
- Customize experience based on location
- Apply regional preferences
Workflow: "KYC Verification Process"
Trigger: When customer submits KYC form
Step 1: Identity verification
- Validate Email: Primary email
- Check Email Reputation: Security analysis
- Validate Phone: Mobile verification
Step 2: Business verification (if applicable)
- Validate VAT: Company registration
- Cross-reference company data
- Verify business address
Step 3: Geographic compliance
- IP Geolocation: Current location
- Check against restricted countries
- Verify location consistency
Step 4: Risk assessment
- Calculate composite risk score
- Flag high-risk profiles
- Apply appropriate verification levels
Step 5: Compliance reporting
- Generate KYC report
- Store verification results
- Schedule compliance reviews
Workflow: "Educational Onboarding"
Trigger: When user completes registration form
Step 1: Academic email verification
- Validate Email: Check format and deliverability
- Check domain reputation for academic institutions
- Verify .edu or academic domain patterns
Step 2: Geographic analysis
- IP Geolocation: Determine location
- Apply regional content and language
- Check for institutional IP ranges
Step 3: Profile personalization
- Generate Avatar: Custom educational theme
- Set default preferences by region
- Apply appropriate content filters
Step 4: Institutional integration
- If institutional email detected:
- Enable SSO options
- Apply institutional policies
- Set up class/group memberships
Step 5: Communication setup
- Format phone for SMS notifications
- Set up regional communication preferences
- Configure timezone-appropriate scheduling
| Test Case | Input | Expected Result | Validation Points |
|---|---|---|---|
| Valid Email | [email protected] | DELIVERABLE | is_valid_format=yes, quality_score>0.7 |
| Invalid Format | invalid-email | Error or format warning | is_valid_format=no |
| Disposable Email | [email protected] | DELIVERABLE but flagged | is_disposable_email=yes |
| Business Email | [email protected] | DELIVERABLE | is_free_email=no |
| Non-existent Domain | [email protected] | UNDELIVERABLE | is_mx_found=no |
| Test Case | Input | Expected Result | Validation Points |
|---|---|---|---|
| US Mobile | +1234567890 | valid=yes | line_type=mobile, country_code=US |
| International | +34123456789 | valid=yes | country_name=Spain |
| Invalid Format | 123 | valid=no | Error handling |
| Landline | +12125551234 | valid=yes | line_type=landline |
Workflow: "Run Automated Tests"
Trigger: Schedule - daily at 3 AM
Step 1: Test email validation
- For each test case in test_emails database:
- Run Validate Email
- Compare results with expected
- Log discrepancies
Step 2: Test phone validation
- For each test case in test_phones database:
- Run Validate Phone
- Verify formatting and validity
- Log any failures
Step 3: Test IP geolocation
- Test with known IP addresses
- Verify location accuracy
- Check security detection
Step 4: Test VAT validation
- Use sample VAT numbers
- Verify company data retrieval
- Check validation accuracy
Step 5: Generate test report
- Compile all test results
- Calculate success rates
- Send report to development team
- Alert if critical failures detected
Workflow: "Monitor API Performance"
Trigger: After each API call (any service)
Step 1: Record performance metrics
- Create performance_log:
- service_name: Current service
- response_time: Calculated duration
- success: yes/no
- timestamp: current date/time
- user: current user
Step 2: Check rate limits
- Query today's usage for current service
- If approaching limit (>80%):
- Show warning to admin
- Consider caching optimization
Step 3: Error tracking
- If API call failed:
- Log detailed error information
- Increment error counter
- Send alert if error rate > 5%
Step 4: Generate insights
- Calculate average response times
- Identify peak usage periods
- Optimize based on patterns
Dashboard Page Structure:
├── Group: API Usage Overview
│ ├── Chart: Daily API calls by service
│ ├── Text: Current month usage
│ ├── Progress bars: Usage vs limits
│ └── Alerts: Approaching limits
├── Group: Performance Metrics
│ ├── Chart: Average response times
│ ├── Text: Success rate percentage
│ ├── Table: Slowest operations
│ └── Error rate trends
├── Group: Security Monitor
│ ├── Map: Geographic access patterns
│ ├── Table: Recent security events
│ ├── Alerts: Suspicious activities
│ └── VPN usage statistics
└── Group: Business Intelligence
├── Chart: Validation success rates
├── Table: Most validated domains
├── Regional usage patterns
└── Revenue impact metrics
Workflow: "Real-time Dashboard Updates"
Trigger: Every 30 seconds (scheduled)
Step 1: Aggregate current metrics
- Query api_usage_log for last 24 hours
- Calculate current success rates
- Check for error spikes
Step 2: Update dashboard displays
- Refresh usage charts
- Update performance indicators
- Show current API quotas
Step 3: Security monitoring
- Check for unusual access patterns
- Monitor failed validation attempts
- Track geographic anomalies
Step 4: Automated alerting
- If error rate > threshold: Send admin alert
- If usage approaches limit: Notify stakeholders
- If security event detected: Trigger investigation
Step 5: Business metrics
- Calculate revenue attribution
- Track conversion impact
- Monitor user engagement
| Frequency | Task | Purpose |
|---|---|---|
| Daily | Check API quota usage | Prevent service interruption |
| Daily | Review error logs | Identify and fix issues quickly |
| Weekly | Clean validation cache | Remove old cached data |
| Weekly | Performance review | Optimize slow operations |
| Monthly | Security audit | Review access patterns and threats |
| Monthly | Usage analysis | Plan capacity and features |
| Day | Tasks | Deliverables |
|---|---|---|
| 1-2 | Environment setup, API key configuration | Working plugin installation |
| 3-4 | Email and Phone validation implementation | Basic validation workflows |
| 5 | VAT validation and IP geolocation | Complete service coverage |
| Day | Tasks | Deliverables |
|---|---|---|
| 6-7 | Avatar generation and advanced workflows | Complete user experience |
| 8-9 | Security implementation and monitoring | Production-ready security |
| 10 | Testing, optimization, and deployment | Live production system |