OmniDocHow to edit and filter online collaboration forms with multiple people
Explain clearly how to divide the work when multiple people modify a table at the same time, how to avoid overwriting each other, and how to filter shared tables without affecting others. Including the practice of using UniCell tables on the OmniDoc desktop, there are also general methods that do not rely on specific software.
Key points of this article
- Before multiple people modify the table at the same time, split the table into areas or worksheets that each person is responsible for, which can greatly reduce mutual coverage.
- Shared files should be placed in a location that everyone can access, and file names and version rules should be agreed upon to avoid multiple "final versions".
- Filtering in a shared sheet will change what everyone sees, so you should use a copy or filtered view when viewing it yourself.
- Compare version records and key figures before each summary, and manually check them again, which saves time compared with subsequent tracing.
The tables of many teams are messed up in this way: three people open the same file at the same time, someone changes the numbers, someone deletes a row, and someone leaves the filtering conditions in the table. When others open it, they think half of the data is missing. The online editing form for document collaboration seems simple, but the real trouble is "who changed what, which version was changed, and whether what others saw was what I saw."
This article is written for people who need to maintain budget tables, project schedules, registration lists or data ledgers with colleagues on the computer. After reading, you will know how to divide the work before multi-person editing, how to operate the UniCell table on the OmniDoc desktop, how to filter the shared table so as not to affect others, and what method to use to check after aggregation. Mobile phone operation is beyond the scope of this article.
If multiple people modify the table together, how can they divide the work so as not to overwrite each other? One sentence conclusion
Let me start with the conclusion: Let everyone be responsible for only their own area, store the files in a unified manner, and then merge them when summarizing. Editing the same cell at the same time will almost always cause problems, regardless of which tool is used.
| your situation | Recommended practices | reason |
|---|---|---|
| Several people fill in their own data | Divide areas or worksheets according to people and change their respective areas | No cross-modification, not easy to overwrite |
| It requires multiple people to watch it at the same time and occasionally make a few changes. | Use online forms that support real-time collaboration and set editing permissions | Modifications can be seen immediately, and permissions can limit accidental modifications. |
| Forms require back-and-forth review and finalization | Save the version according to the round, and each person will pass it to the next person after making changes. | Each version is traceable and responsibilities are clear |
| The original material is a PDF report | First export to Excel in the PDF editor, then divide the editing work | Turn static content into editable tables |
| Only one person is ultimately responsible for the form | Others submit modification opinions, which will be entered uniformly by the person in charge. | Single data source, reducing conflicting versions |
Before you start: Confirm these points first
Before starting to divide the work, take a few minutes to confirm the following things, and the subsequent operations will be much smoother.
- Who can change where. List the rows, columns, or worksheets that each person is responsible for. The more specific the scope is, the less likely it is to conflict. For example, "Jackson is responsible for the amounts from 1 to 20 lines, and John is responsible for the amounts from 21 to 40 lines."
- What the table is used for. If you are just summarizing numbers, you can fill them in separately; if you want to filter and make statistics, you must ensure that the field names, date formats and number formats are consistent, otherwise the filtering results will miss data.
- Where to put the files. Do not forward copies one by one through chat software. Put it in a shared location that the team can access, and agree on a file name, such as "Project Progress_June 2024_Responsible Person".
- Whether modification records need to be kept. If you want to trace who changed which number at what time, you must choose a method that supports historical versions; if you only rely on manual saving, you can only retain the "version at a certain moment".
- Whether it contains formulas and hidden data. If the range referenced by the formula is accidentally deleted by others, a silent error will occur. Before you start, write down the key formulas and hidden rows and columns for easy checking.
Steps to use UniCell table to divide work among multiple people on OmniDoc desktop
UniCell tables are available in the OmniDoc desktop client. The following steps are applicable to creating a new form on the computer and dividing the labor for maintenance. Teams that need true simultaneous online editing should choose an online form tool that supports real-time collaboration, and the general approach in this article also applies to that scenario.
- Visit download.omnidoc.top, download and install the desktop client suitable for your system (supports Windows, macOS and Linux).
- Open the client, create a new UniCell table, and save it named by the project name and date.
- Divide the areas by people in the table. You can use different worksheets to correspond to different people in charge, or you can use the table header to indicate the person in charge of each area.
- Place the table file in a location shared by the team, and clearly write down the file name, storage path, and the scope of each person's responsibility in the group.
- Everyone only modifies the area they are responsible for. When you need to change someone else's area, leave a message to let them know first, rather than taking action directly.
- After each person makes changes, save another copy, with the date and name added to the file name, such as "Project Progress_0620_Wang Min" to avoid overwriting other people's versions.
- When summarizing, copy the data of each person's version to the master table according to the specified area, and indicate the source version in the master table.
- If the other party provides a PDF report, you can export it to Excel in OmniDoc's PDF editor, and then edit according to the above process.
How to filter the shared form so as not to affect others?
Screening is where this article tends to go wrong. The filtering conditions in many table tools will be saved with the file. The filtering status you set will also be the filtered results that others see when they open it. This is a common reason why "the data in the table suddenly disappeared by half".
There are three common methods, choose according to the situation:
- Use filtered view (if tool supports it). In some online form tools, you can save a filtered view that only takes effect for you, without changing what others see. This is the ideal way to share tables.
- Make a copy first and then filter. If the tool does not support an independent filter view, save the table as a copy, filter, sort, and view it in the copy. After completion, manually record the conclusions back to the shared table.
- Marked with auxiliary columns, leaving original filtering unchanged. Add a new column on the right side of the table, such as "Whether to be followed up", fill in "Yes" or "No", everyone will view it in this column, and there is no need to change the original filtering status.
No matter which method you use, you should check after completing the filtering: whether your filtering conditions are still left in the table, and whether all the data is displayed after the shared file is opened.
Check each item after completion
After summarizing or finalizing, do not send it directly to others. Check it according to the table below and deal with any problems promptly.
| Check items | How to see it | What should you do if there's a problem? |
|---|---|---|
| Whether the data is complete | Compare the number of rows and key sums for each version | Find the missing line and return to the corresponding version to supplement |
| Did anyone make mistakes? | Check version records or compare the differences between the two versions | Restore using the historical version and inform the relevant responsible persons |
| Is the formula correct? | Spot check several aggregate and reference cells | Check whether the reference range has been deleted or moved, correct it, and recalculate |
| Check if the screening status remains | Open the file and see if all data is displayed | Clear the filter before saving and notify the team |
| Whether the format is unified | Check the date, amount, and decimal places | Unified format, replaced and corrected with search if necessary |
| Check whether the file name and version are clear | Check if the filename contains a date, name, or version number | Rename and move the old version into the archive folder |
If the table contains numbers recognized by OCR or machine-translated text, be sure to verify each item against the original; do not use it directly.
📊 Core Comparison
There are three common ways to maintain multi-person forms, each suitable for different scenarios.
| Method | Advantages | Disadvantages | Suitable for the scene |
|---|---|---|---|
| Consolidate by region, with unified consolidation | Conflicts are less likely, responsibilities are clear | Manual summarization is required | Reporting, ledger, and task lists assigned by person |
| Online forms for real-time collaboration | Changes are instantly visible, with low communication costs | Requires a network, and incorrect permission settings can easily lead to accidental changes | Tables viewed by multiple people simultaneously and frequently edited |
| Alternate editing and handover by version | Each page is traceable and suitable for review | Long wait times and multiple versions can easily cause confusion | A form that requires step-by-step review and finalization |
❓ Frequently Asked Questions (FAQ)
1. If multiple people edit the same table at the same time, will it overwrite each other?
Yes. When two people modify the same cell simultaneously, the later saved content may overwrite the first saved content. The safer approach is to divide tasks by region, with each person only changing their own responsibilities.
2. How to choose a free online form tool?
When choosing, pay attention to file size limits, whether to add watermarks to tables, data storage and privacy policies, post-export layout, and whether formulas are retained. Different tools have very different limitations; test with a sample table first before deciding.
3. If someone else has altered their data, how can it be recovered?
If the tool has saved historical versions, you can go back to the previous version before the mistake was modified to restore it. Without historical versions, you can only rely on your previously saved dungeons for comparison, so developing the habit of "saving after editing" is very important.
4. Can I participate in editing on my phone?
You can check them, but large pieces of data and complex formulas are not easy to verify on your phone. If you need to modify a large amount of data, it is recommended to do so on a computer.
📝 Summary
The key to multi-person collaboration spreadsheets is to divide tasks in advance, unify file locations, and avoid altering what others see during filtering and summarizing. On the OmniDoc desktop, UniCell tables can be edited by region, with version naming and item-by-item verification to keep the mess of collaborative online table editing within a manageable range.
