WPS Advanced Field Types on Windows FAQ

Common questions about Advanced Field Types usually focus on field access, relation prerequisites, lookup results, and auto-recorded information; this section covers 4 frequent questions.

FAQ

Why can’t I find the Advanced Fields area?

1. Make sure you opened an editable table instead of a read-only view.
2. Click + to add a field, then open the field type drop-down list.
3. If the area still does not appear, update WPS Office and reopen the multi-dimensional table.

Why is my lookup field not showing data?

1. Check whether the current table already has a relation field.
2. Confirm that the lookup field uses the correct relation source.
3. Make sure the target field in the related table already contains displayable values.

Why does the statistic field result look incorrect?

1. Check whether the related records used by the statistic field are complete.
2. Confirm that the selected summary method matches your current workflow.
3. If needed, review the record selections in the relation field first.

Can auto-record fields be edited manually?

1. ID fields can generate record numbers automatically based on field rules.
2. Created by, Last edited by, Created time, and Last edited time are mainly used for automatic recording.
3. If you need a different display result, adjust the field settings instead of rewriting the recorded values directly.

Glossary