Skip to main content

Edition Notes

1. Introduction

1.1 Feature Overview

Sync AI Table / OA Approval form data to bridge AI Table / OA Approval with YiDA, so users can reference AI Table / OA Approval data directly on the YiDA side.

1.2 Use Cases

  • Event organizers can use AI Table / OA Approval to manage every stage of an event — attendee sign-up, scheduling, logistics, and more. Participants can submit feedback and requests through forms.
  • Security managers can use AI Table sync forms to log safety inspection results, incident reports, and corrective actions. This helps prevent incidents and safeguard employee safety and well-being.

2. Steps

The steps are essentially the same for both types.

2.1 Create a Page — Pick a DingTalk AI Table / OA Approval Form

1

Step 1

Sign in to the YiDA Workbench. Select the target app and open its page management screen.
2

Step 2

Click the icon in the upper-left corner, and choose Sync DingTalk data to a form — DingTalk AI Table.

2.2 Pick the AI Table / OA Approval Form to Sync

2.3 Configure Sync Fields

IllustrationSettingDescription
Sync target form
  1. By default, syncs to a new regular form.
  2. If you pick Sync to an existing form, the dropdown lists forms that already exist in this app.

Configure sync fields
  1. Click [Add sync field] to add fields manually — select to add.


  1. Or click AI to match automatically.

2.4 Configure Sync Rules

IllustrationSettingDescription

Data sync modeA deduplication primary key must be set when syncing data. In general, use a unique ID — or a composite primary key of several fields — to identify duplicates.
Three sync modes are available:
  • Insert only: only sync records whose primary key does not yet exist in the current form.
  • Update only: only sync records whose primary key already exists in the current form.
  • Insert or update: if the primary key exists in the current form, update the record; otherwise, insert it.

Scheduled sync rulesSettings:
Sync time: defaults to the current time; editable manually.
Repeat rule
  1. Sync every 5 minutes


    1. Sync hourly


      1. Sync daily


        1. Sync on every workday


          1. Weekly (Friday) sync


            End time: when to stop syncing.
            Two options:
            1. Run count:
            2. Specific time: pick a date and time.

            Sync data range and SortEach sync currently pulls at most 10,000 records for a regular form and 300 records for a workflow form.
            When the data volume is large, use [filter conditions + Sort] to update a specific slice.

            Note: “regular form” and “workflow form” here refer to YiDA page types.
            When AI Table forms and OA Approval forms are first created in YiDA, they are all regular forms.
            A workflow form applies once a user manually converts a regular form via “Convert to workflow form in one click”.
            OtherChoose whether the data sync should trigger validation rules, business rules, integration & automation flows, message notifications, and third-party service callbacks.
            Once the settings above are in place, click [Save and sync] to run the first sync.
            [Note]When historical data exceeds 10,000 records and you want it all synced into the YiDA form during initialization, there are currently two workarounds:Option 1: Under “Sync rules” — “Sync data range and Sort”, set up “Filter conditions” and update across multiple manual sync passes.Option 2: After the form is created, bring the remaining data in all at once via “Bulk import” into the corresponding form.

            2.5 View the Data

            Once created, you will see a new “regular form” in the app, along with a data set of the same name and type generated at the same time. The first sync after creation may take a few minutes — if the data does not match the source, wait a moment. Click “Dataset sync” to view the sync log. See the illustration below: After creation, if you need to edit the sync rules or manually refresh the data, find the entry points in the form’s dropdown action bar as shown below.
            About the Sync data button:Free plan: only one click-to-sync per day.Paid editions: not unlimited — see the edition notes in section 1 for details.

            3. Format Support

            AI Table data sync — format support
            Field typeField nameAI Table data typeSync supported?Data type after syncNotes
            Common componentsTextText
            • Supported
            Text
            Multiselectarray
            • Supported
            Text
            The sync data type must be set to Text, otherwise data cannot be read. After sync, shows the option ID.
            grouparray
            • Supported
            Text
            After sync, shows the group ID.
            DateDate
            • Supported
            Date
            Checkboxboolean
            • Supported
            Text
            LinkLink
            • Supported
            Text
            FormulaFormula
            • Supported
            Text
            Data type must be set to Text, otherwise data cannot be read.
            LocationMap location
            • Supported
            Text
            Data type must be set to Text, otherwise data cannot be read.
            PhonePhone, with validation
            • Supported
            Text
            Data type must be set to Text, otherwise data cannot be read.
            RatingRating component
            • Supported
            Numerical
            MailText
            • Supported
            Text
            SignatureImage
            • Supported
            Text
            SelectText
            • Supported
            Text
            After sync, shows the option ID.
            UserUser
            • Supported
            Text
            The sync data type must be set to Text, otherwise data cannot be read. After sync, shows the user ID.
            DepartmentDepartment
            • Supported
            Text
            The sync data type must be set to Text, otherwise data cannot be read. After sync, shows the department ID.
            NumberNumber
            • Supported
            Numerical
            AttachmentAttachment
            • Supported
            Text
            Data type must be set to Text, otherwise data cannot be read.
            ProgressProgress bar
            • Supported
            Text
            Data type must be set to Text, otherwise data cannot be read.
            LookupSearch box
            • Supported
            Text
            BarcodeText
            • Supported
            Text
            AddressCascader
            • Supported
            Text
            Data type must be set to Text, otherwise data cannot be read.
            CurrencyNumber
            • Supported
            Numerical
            ID cardID card
            • Supported
            Text
            Premium componentsAutonumberNumber
            ❌ Not supported
            Neither Numerical nor Text is supported.
            One-way LinkAssociation component
            • Supported
            Text
            Related LookupAssociation component
            • Supported
            Text
            Last modified byUser❌ Not supportedText
            Last modified timeDate❌ Not supportedText
            Rich TextRich Text
            • Supported
            Text
            WorkflowWorkflow component
            • Supported
            Text
            Data type must be set to Text, otherwise data cannot be read. Shows the workflow ID.
            Both-way LinkText
            • Supported
            Text
            Created byUser❌ Not supportedTextData type must be set to Text, otherwise data cannot be read.
            Created timeDate❌ Not supportedTextData type must be set to Text, otherwise data cannot be read.
            ButtonButton component
            ❌ Not supported
            Neither Single-line text nor Multi-line text is supported.
            OA Approval form data sync — format support: