WPS Basic Field Types is a set of common field types for DBSheet on macOS; it includes 3 core tasks, with 3 available without membership and 0 membership-related items.
At a Glance
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 3 | Matches the number of rows in the How-to Index |
| Available without membership | 3 | Matches the number of Free rows in the index |
| Membership-related items | 0 | Matches the number of membership-related rows in the index |
| Version limits | None | Use it in the currently available version |
About This Feature
Overview
Basic Field Types is a built-in DBSheet feature in WPS Office for Mac that helps you add columns for different kinds of data. Available field types include text, number, single select, multi-select, date, contact, rich text, image and attachment, and time, so you can choose a more suitable structure for each record.
Key value includes:
- Create columns by data type for text, numbers, dates, contacts, and other common content.
- Improve input consistency with single-select and multi-select fields instead of free-form entry.
- Store richer record details with rich text, image and attachment fields.
System Requirements
| Item | Requirement |
|---|---|
| OS | A Mac device that can run WPS Office for Mac |
| App version | It is recommended to use the latest version of WPS Office |
| Network | No mandatory network connection is required for local field creation; for contact or attachment sync, keep the network available when possible |
| Other | You need access to a DBSheet table and permission to edit fields |
Download & Installation
| Item | Notes |
|---|---|
| Official Download | WPS Office Free Download |
| Post-install Check | Launch WPS Office for Mac, open DBSheet, and confirm that you can see Add Field and Field Type options |
Source: WPS download page
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | DBSheet supports basic field types such as text, number, single select, multi-select, date, contact, rich text, image and attachment, and time. | Microsoft Lists supports column types such as text, number, date and time, person, and attachments for list-based data entry and display. | Google Sheets supports dropdowns and data validation for structured input, plus date and checkbox rules, but it is not a native database field system. | Notion databases provide property types such as Text, Number, Select, Multi-select, Date, Person, and File for table-style information management. | Adobe Acrobat mainly provides PDF form field properties such as date, multi-line text, image fields, and calculated fields, which are oriented to PDF forms rather than database tables. |
| WPS Advantages | Advantage: multiple basic field types are available in one DBSheet table. Distinct: option fields, contacts, rich text, and attachments are covered in the same workflow. | Compared with WPS: it is more focused on list columns and form-style entry. | Compared with WPS: structured input relies more on cell rules and dropdown settings. | Compared with WPS: database properties are more closely tied to workspace pages and database collaboration. | Compared with WPS: it is mainly designed for PDF form creation, not multidimensional table field management. |
| Official Source | — | List and library column types and options | Create an in-cell dropdown list | Database properties | PDF form fields |
Overall Conclusion
WPS Basic Field Types is well suited to building structured fields in one DBSheet table. Compared with list tools, spreadsheets, workspace databases, and PDF form tools, it stays focused on everyday field setup and data entry inside a multidimensional table.
Use Cases
| # | Scenario | Target Users | Core Pain Point | Solution |
|---|---|---|---|---|
| 1 | Project task tracker | Project managers, team members | Status, owner, and due date fields are not consistent | Use single-select, contact, and date fields for standardized records |
| 2 | Asset and attachment management | Operations, design, and content teams | A record needs both notes and files | Use rich text plus image and attachment fields |
| 3 | Data collection table | Admin and business support teams | Mixed number, text, and time input becomes messy | Create separate number, text, and time fields by content type |
| 4 | Customer follow-up table | Sales and support teams | Contacts, time, and notes are scattered | Use contact, time, and rich text fields in one table |
| 5 | Schedule and shift records | Coordinators and team leads | Date and time details are hard to standardize | Use date and time fields for consistent entry |
Membership & Benefits
Free vs WPS Premium
| Feature | Free User | WPS Member |
|---|---|---|
| Basic use of Basic Field Types | ✅ Available | ✅ Available |
| PDF and advanced office tools | Some features available | More advanced features available |
| Cloud storage and added services | Basic quota | Higher quota and more added services |
| AI-related tools | Some capabilities are limited | More capabilities are available, usually with usage limits |
Source: WPS Office pricing page
Recommendations
| Use Case | Recommended Plan | Reason |
|---|---|---|
| Creating and maintaining basic fields in daily work | Free | This feature has no membership restriction and fits routine table setup |
| Needing more PDF tools, templates, cloud storage, or AI tools at the same time | WPS Premium | Suitable when you need broader office features beyond field management |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page