How to Use WPS Multidimensional Date Field on macOS

Use WPS Multidimensional Date Field with 4 how-to topics, including field creation, format settings, default values, and date entry; 4 topics are available without membership and 0 are membership-related.

How-to Index

How-to Guide

1. Create a Date Field

Entry point: Click the + button on the right side of the table 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 creating the field.

Success Criteria

• Interface result: A new date field column appears in the table.
• Next step available: You can open field settings to adjust the format or default value.

Tips While Using

• Common mistake: If you are not working in the intended table, the field may be added to a different table.
• Environment note: You need edit permission for the current table.

2. Set the Date Format

Entry point: Right-click the field title, then open Field Settings and go to 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 date values with the selected weekday or time style.
• Next step available: You can enter dates and review the updated display format.

Tips While Using

• Common mistake: Changing the format may look like the value changed, but the main change is the display style.

3. Set a Default Value

Entry point: 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. Find the Default Value option.
4. Choose None, Specific date, or Date when this record is added.
5. Close the panel after saving the setting.

Success Criteria

• Interface result: New records use the selected default behavior or stay blank.
• Next step available: You can add a new record to verify the default value.

Tips While Using

• Common mistake: Specific date is a fixed value, while Date when this record is added uses the date of record creation.

4. Enter a Date

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

1. Click the date cell that you want to fill in.
2. Select the target date in the date picker.
3. If time display is enabled, add the hour and minute.
4. Confirm the entered value.

Success Criteria

• Interface result: The cell shows the selected date, and time appears when time display is enabled.
• Next step available: You can continue editing other records or adjust field settings.

Tips While Using

• Common mistake: If time display is not enabled, the cell will not show hour and minute details.