WPS Advanced Field Types on macOS FAQ

Common questions about Advanced Field Types mainly focus on field entry, link setup, automatic record fields, and automation settings, with 5 frequent question types.

FAQ

Why can’t I see Advanced Fields in the field list?

1. Make sure you are working in a multidimensional table instead of a standard document or spreadsheet file.
2. Click + to add a field, then open the Field Type drop-down list.
3. Check whether you have permission to edit fields or table structure.
4. If the section still does not appear, update to the latest version of WPS Office for Mac and try again.

Why does the Lookup field return no content?

1. Make sure the current table already has a usable link field.
2. Check whether the Lookup field is using the correct source link.
3. Check whether the target field already has actual values in the related records.
4. Save the settings and review the record again.

Can I edit the Created By and Last Modified By fields manually?

1. These fields are used to record people information automatically.
2. Created By records who created the record.
3. Last Modified By updates after the record is edited.
4. If you need a manual note for people information, add a normal text or member field separately.

What is the difference between Created Time and Last Modified Time?

1. Created Time records when the record was first created.
2. Last Modified Time records the most recent time the record was updated.
3. Created Time is useful for tracing record origin.
4. Last Modified Time is useful for tracking the latest update point.

What should I check if Automation does not run?

1. Check whether the trigger conditions are set correctly, such as field value changes or reminder time.
2. Check whether the action settings were fully saved.
3. Check whether the related record actually meets the trigger conditions.
4. If notifications or online collaboration are involved, confirm that the network connection is working normally.

Glossary