How to Use WPS Multidimensional Date Field on Windows

Use the Multidimensional Date Field with 4 how-to topics, including creating a field, setting the date format, setting default values, and entering dates.

How-to Index

How-to Guide

1. Create a date field

Entry: Click the + button on the right side of the header, then choose Date.

1. Click the + button on the right side of the table header.
2. Select Date from the field type list.
3. Enter a field name.
4. Click OK to finish.

Success Criteria

• Interface result: A new date-type column appears in the table.
• Next action: You can open field settings and continue with format or default value changes.

Tips While Using

• Common mistake: If you choose another field type instead of Date, the new column will not behave as expected.
• Permissions: You need edit permission for the current table.

2. Set the date format

Entry: Right-click the field title, then open Field Settings and find the date format area.

1. Right-click the date field title.
2. Select Field Settings.
3. Turn on Show weekday if needed.
4. Turn on Show time if needed.
5. Turn on Mark rest days if needed.

Success Criteria

• Interface result: The field displays dates with the selected weekday or time options.
• Next action: You can enter dates and review the updated display style.

Tips While Using

• Common mistake: After changing the format, users may forget to check existing records to confirm the display result.
• Suggestion: For scheduling tables, using Show time together with Mark rest days can make the timeline easier to review.

3. Set default values

Entry: Right-click the field title, then open Field Settings and find Default Value.

1. Right-click the date field title.
2. Select Field Settings.
3. In Default Value, choose None, Specified date, or Date this record is added.
4. Close the settings panel or continue editing other field options.

Success Criteria

• Interface result: New records follow the selected default rule or stay blank.
• Next action: Add a new record to confirm that the default value works as expected.

Tips While Using

• Common mistake: If you choose Specified date, make sure the fixed date fits future records.
• Suggestion: If you want each new row to carry the current date automatically, use Date this record is added.

4. Enter a date

Entry: Click the target cell to open the date picker.

1. Click the target date cell.
2. Select the required date in the date picker.
3. If the field is set to show time, enter the exact time as well.
4. Return to the table and review the result.

Success Criteria

• Interface result: The cell shows the selected date and, when enabled, the selected time.
• Next action: You can edit the value again or continue filling other records.

Tips While Using

• Common mistake: If time display is not enabled, users may expect time details to appear automatically.
• Suggestion: Confirm the field format before entering values to reduce repeated adjustments later.