How to Use the FINDB Function in WPS on Windows

Last updated:July 23, 2026

Use FINDB through 3 how-to topics, including creating a formula field, setting the parameter format, and writing a sample formula; choose a topic from the index and follow the entry path and steps.

How-to Index

No.TopicMembership Requirement
11. Create a formula field and call FINDBFree
22. Set the FINDB parameter formatFree
33. Write a FINDB example formulaFree

How-to Guide

1. Create a formula field and call FINDB

Entry path: Add Field → Formula

  1. Open the Bitable you want to edit.
  2. Click Add Field on the toolbar.
  3. Select Formula as the field type.
  4. Enter FINDB in the formula editor.
  5. Click Confirm to save the field.

Success Criteria

  • Interface result: A new formula field appears in the table.
  • What you can do next: You can continue entering the full formula and review the calculated result.

Tips While Using

  • Common mistake: Using a normal text field instead of a formula field prevents the function from working.
  • Environment note: If the online Bitable page loads slowly, the formula editor may not appear immediately.

2. Set the FINDB parameter format

Entry path: Formula Editor → Function Library → FINDB

  1. Open the formula editor in the formula field.
  2. Select FINDB from the function library.
  3. Enter the arguments in the order FINDB(search text, target text, [starting position]).
  4. Check that the text arguments are not reversed.
  5. Save the formula and review the returned result.

Success Criteria

  • Interface result: The full FINDB formula appears in the editor.
  • What you can do next: After saving, you can see either a returned position value or an error message in the record.

Tips While Using

  • Common mistake: Reversing the search text and target text can return an error.
  • Environment note: If the target text is empty or the starting position is invalid, the formula may return an error.

3. Write a FINDB example formula

Entry path: Formula Field → Enter a sample formula

  1. Enter a sample formula such as FINDB("新", "农历新年", 2) in the formula field.
  2. Replace the search text and target text to fit your own data.
  3. If needed, nest the FINDB result inside other functions for conditional logic.
  4. Save the formula and review the automatic result for each record.

Success Criteria

  • Interface result: The formula field shows a numeric result.
  • What you can do next: The result can be used as input for other formulas.

Tips While Using

  • Common mistake: Ignoring the byte-count rule for double-byte text can lead to confusion about the result.
  • Environment note: Returned values change with the text content in each record.