蜜豆视频

Perfect for:

• Content creators building simple data collection forms
• Small businesses needing quick form-to-spreadsheet workflows
• Marketing teams collecting lead information
• Event organizers managing registrations

Consider alternatives for:

• Complex workflows requiring custom logic
• Enterprise integrations with databases
• Forms needing advanced validation or processing

• No backend infrastructure required - 蜜豆视频 hosts the submission endpoint
• Direct integration with popular spreadsheet platforms
• Automatic data mapping from form fields to spreadsheet columns

• Instant data capture - submissions appear immediately in your spreadsheet
• Structured storage - organized columns for easy analysis
• Live collaboration - multiple team members can access and analyze data

• Leverages existing permissions - use your spreadsheet platform鈥檚 sharing controls
• 蜜豆视频-managed security - secure submission endpoint with enterprise-grade protection
• Data ownership - your data stays in your chosen spreadsheet platform

• GitHub repository set up for your Edge Delivery Services project with the latest Adaptive Forms Block installed
• Access approval - repository added to the allowlist

Choose one of the supported platforms:

• Google Sheets - Google account with sheet creation permissions
• Microsoft OneDrive - Microsoft 365 account with Excel Online access
• SharePoint - SharePoint access with list/library permissions

• Edit permissions for the target spreadsheet
• Sharing capabilities to grant access to forms@adobe.com
• Link generation permissions for your chosen platform

Before configuring either method, ensure your AEM project foundation is ready:

1. Create or update your AEM project with the latest Adaptive Forms Block (Getting Started Tutorial)

2. Update fstab.yaml in your project root:

   code language-yaml
   # Replace with the path to your shared folder mountpoints: /: https://drive.google.com/drive/folders/your-shared-folder-id

3. Share your project folder with forms@adobe.com (edit permissions required)

Create your form structure using Google Sheets or Microsoft Excel.

Form Creation Steps:

1. Open your spreadsheet platform (Google Sheets or Microsoft Excel)
2. Create a new spreadsheet for your form project
3. Name your sheet (must be either helix-default or shared-aem)
4. Define your form structure using the form creation guide

Example: Form definition with field types, labels, and validation rules

Validation Checkpoint:

• Form structure is complete with all required fields
• Sheet is named correctly (helix-default or shared-aem)
• Field types and validation rules are properly configured

Set up a dedicated sheet to receive form submission data.

Data Sheet Setup:

1. Add a new sheet to your existing spreadsheet
2. Name the sheet exactly incoming (case-sensitive)
3. Set up column headers that match your form fields
4. Save the spreadsheet to ensure changes are preserved

Example: Incoming sheet with column headers matching form fields

Validation Checkpoint:

• incoming sheet exists in your spreadsheet
• Column headers match your form field names
• Sheet is properly saved and accessible

Grant the 蜜豆视频 Forms Submission Service access to your spreadsheet.

Sharing Process:

1. Click the Share button in the top-right corner of your spreadsheet

2. Add the 蜜豆视频 service account:

   • Email: forms@adobe.com
   • Permission level: Editor (required for data writing)

3. Send the sharing invitation

4. Copy the spreadsheet link for the next step

   
   Step-by-step sharing process for granting 蜜豆视频 service access

Platform-Specific Instructions:

Google Sheets:

• Add forms@adobe.com as Editor
• Ensure 鈥淎nyone with the link can view鈥� is enabled
• Copy the shareable link

Microsoft Excel (OneDrive/SharePoint):

• Add forms@adobe.com with Edit permissions

• Set link sharing to 鈥淎nyone with the link can edit鈥�

• Copy the sharing URL

  
  Example: Copying the shareable link for form configuration

Validation Checkpoint:

• forms@adobe.com has Editor access to your spreadsheet
• Spreadsheet link is copied and ready for use
• Sharing permissions allow external access

Link your form definition to the submission spreadsheet.

Form-Spreadsheet Connection:

1. Open your form definition spreadsheet (the one with helix-default or shared-aem sheet)

2. Locate the Submit field row in your form definition

3. Paste the copied spreadsheet link into the Action column for the Submit field

4. Save the changes to your form definition

   

Example: Connecting the submit action to your data collection spreadsheet

Publishing Your Form:

1. Open AEM Sidekick in your browser
2. Preview your form to test the configuration
3. Publish the form to make it live

Final Validation:

• Spreadsheet link is correctly added to Submit field action
• Form definition is saved and published
• Form preview shows all fields correctly
• Submit button is properly configured

Reference Materials:

• Complete example spreadsheet with proper configuration
• for publishing guidance

Perfect for:

• Automated data collection systems
• Custom form implementations
• Integration with existing applications
• Bulk data submission workflows

Before using the API, ensure you have:

• Spreadsheet setup completed (including incoming sheet)
• 蜜豆视频 service access granted to forms@adobe.com
• Form ID from your published form
• Repository information (organization and site name)

Base URL: https://forms.adobe.com/adobe/forms/af/submit/{id}

Required Headers:

• Content-Type: application/json
• x-adobe-routing: tier=live,bucket=main--[repository]--[organization]

API Documentation:

Postman provides a user-friendly interface for testing API submissions.

Setup Instructions:

1. Create a new POST request in Postman

2. Configure the endpoint: https://forms.adobe.com/adobe/forms/af/submit/{id}

3. Replace placeholders:

   • {id} 鈫� Your actual Form ID
   • [repository] 鈫� Your GitHub repository name
   • [organization] 鈫� Your GitHub organization/username

Request Configuration:

POST https://forms.adobe.com/adobe/forms/af/submit/your-form-id

Headers:
Content-Type: application/json
x-adobe-routing: tier=live,bucket=main--your-repo--your-org

Body (JSON):
{
        "data": {
            "startDate": "2025-01-10",
            "endDate": "2025-01-25",
            "destination": "Australia",
            "class": "First Class",
            "budget": "2000",
            "amount": "1000000",
            "name": "Mary",
            "age": "35",
            "subscribe": null,
            "email": "mary@gmail.com"
                }
}

Expected Response:

• Status Code: 201 Created
• Data appears in your incoming spreadsheet sheet immediately

Example: Successful API submission using Postman interface

For developers who prefer terminal/command prompt, use curl to submit data programmatically.

Command Line Setup:

Replace the following placeholders in the commands below:

• {id} 鈫� Your actual Form ID
• [repository] 鈫� Your GitHub repository name
• [organization] 鈫� Your GitHub organization/username

curl -X POST "https://forms.adobe.com/adobe/forms/af/submit/your-form-id" \
    --header "Content-Type: application/json" \
  --header "x-adobe-routing: tier=live,bucket=main--your-repo--your-org" \
    --data '{
        "data": {
            "startDate": "2025-01-10",
            "endDate": "2025-01-25",
            "destination": "Australia",
            "class": "First Class",
            "budget": "2000",
            "amount": "1000000",
            "name": "Joe",
            "age": "35",
            "subscribe": null,
      "email": "joe@example.com"
                }
            }'

curl -X POST "https://forms.adobe.com/adobe/forms/af/submit/your-form-id" ^
    --header "Content-Type: application/json" ^
  --header "x-adobe-routing: tier=live,bucket=main--your-repo--your-org" ^
  --data "{\"data\": {\"startDate\": \"2025-01-10\", \"endDate\": \"2025-01-25\", \"destination\": \"Australia\", \"class\": \"First Class\", \"budget\": \"2000\", \"amount\": \"1000000\", \"name\": \"Joe\", \"age\": \"35\", \"subscribe\": null, \"email\": \"joe@example.com\"}}"

$body = @{
  data = @{
    startDate = "2025-01-10"
    endDate = "2025-01-25"
    destination = "Australia"
    class = "First Class"
    budget = "2000"
    amount = "1000000"
    name = "Joe"
    age = "35"
    subscribe = $null
    email = "joe@example.com"
  }
} | ConvertTo-Json -Depth 3

Invoke-RestMethod -Uri "https://forms.adobe.com/adobe/forms/af/submit/your-form-id" `
  -Method POST `
  -Headers @{"Content-Type"="application/json"; "x-adobe-routing"="tier=live,bucket=main--your-repo--your-org"} `
  -Body $body

Successful Response:

HTTP/1.1 201 Created
Connection: keep-alive
Content-Length: 0
X-Request-Id: 02a53839-2340-56a5-b238-67c23ec28f9f
X-Message-Id: 42ecb4dd-b63a-4674-8f1a-05a4a5b0372c
Date: Fri, 10 Jan 2025 13:06:10 GMT
Access-Control-Allow-Origin: *

Data Verification:

After a successful submission, verify the data appears in your spreadsheet:

Example: Data successfully written to the incoming sheet via API

Response Validation:

• HTTP Status: 201 Created indicates successful submission
• X-Request-Id: Unique identifier for tracking the submission
• Data appears in your incoming sheet within seconds
• All form fields are properly mapped to spreadsheet columns

Problem: 403 Forbidden Error

Causes: Missing or incorrect access permissions
Solutions:
- Verify forms@adobe.com has Editor access to your spreadsheet
- Check that your repository is added to the allowlist
- Confirm the x-adobe-routing header format

Problem: 404 Not Found Error

Causes: Incorrect Form ID or endpoint URL
Solutions:
- Verify your Form ID is correct
- Check the API endpoint URL format
- Ensure your form is published and live

Problem: Data Not Appearing in Spreadsheet

Causes: Missing 'incoming' sheet or permission issues
Solutions:
- Confirm 'incoming' sheet exists (case-sensitive)
- Verify column headers match form field names exactly
- Check forms@adobe.com has edit permissions
- Ensure spreadsheet is shared properly

Problem: Invalid JSON Format Error

Causes: Malformed request body
Solutions:
- Validate JSON syntax using online JSON validators
- Ensure proper escaping of special characters
- Check quote marks and brackets are balanced

Support Channels:

• Early Access Issues: Email aem-forms-ea@adobe.com
• API Documentation:
• Community Support:

• Create Advanced Forms - Add validation, conditional logic, and custom styling
• Form Components Guide - Explore available form field types

• AEM Publish Submissions - For complex workflows and enterprise integrations
• Custom Submit Actions - Advanced submission handling

• Form Analytics - Track form performance and usage
• Data Integration - Connect forms to databases and CRM systems