Skip to main content
“Hey DingTalk, collect everyone’s ID numbers and phone numbers.” “Hey DingTalk, collect feedback and suggestions about this year’s work.” “Hey DingTalk, …” In daily office work, data collection is a tedious yet vitally important task. You often need to gather sensitive information, and respondents should ideally not see each other’s submissions. First, you have to edit permissions one by one—time-consuming, exhausting, and hard on the eyes. Then, you face the daunting task of organizing a mountain of collected data. Is there a tool that can collect information while keeping respondents hidden from each other, and then automatically generate a summary spreadsheet from the collected data? Of course there is! Let us proudly introduce— The Spreadsheet “new assistant”—Collect Data Powered by smart forms, your data is automatically aggregated back into the spreadsheet. It saves time and effort, and won’t drain your energy. A must-have office “wellness supplement”!
🏅 Step-by-step tutorial:
First, you need to create a new Spreadsheet.1️⃣ In the upper-left Menu of the Spreadsheet, click Collaboration > Collect Data > Create Table with form.2️⃣ On the form editing page, drag the modules you need from the left question panel to build your form. When finished, click Complete to enter the publishing settings.3️⃣ On the settings page, configure fields such as “Who can respond,” “Number of submissions,” and “Who can view statistics” according to your needs. Once configured, click Publish in the upper-right corner to create the form.4️⃣ You can also share the form with multiple respondents through Chat, Link, or QR Code.5️⃣ Once respondents submit the form, their entries are automatically aggregated into the Spreadsheet originally created by the collector. You can then use the full power of Spreadsheet to analyze and summarize the data. Note: At this point, only the spreadsheet creator can view the collected data.If others need to view or edit the collected information or data, the spreadsheet creator can click Share > Manage permissions in the upper-right corner of the spreadsheet to add them.In addition, if the collector wants to continue editing or adjusting the form, click the arrow icon in the upper-right corner of the form Card to Open the Table with form. From the upper-right corner of the form page, you can access Share, view statistics, and More editing settings.Easy, right?🎉 Give it a try!