This guide includes 3 how-to topics, and all 3 are available without membership, so you can create the field, enter parameters, and check results in order.

How-to Index

#	Topic	Membership
1	1. Create a formula field and open the editor	Free
2	2. Enter SEARCHB parameters	Free
3	3. Type a sample formula and check the result	Free

How-to Guide

1. Create a formula field and open the editor

Entry point: Add Field → Formula

Open the DBSheet that you want to edit.
Click Add Field.
Select Formula as the field type.
Open the formula editor and get ready to enter the SEARCHB function.

Success Criteria

UI state: A new formula field is created and the formula editor is visible.
Next actions: You can continue entering the function name and parameters.

Tips While Using

Common mistakes: If you choose another field type, the formula editor will not appear.
Environment limits: You need permission to edit the current DBSheet.

2. Enter SEARCHB parameters

Entry point: Formula editor → Enter function

In the formula editor, type SEARCHB(.
Fill in the text to find and the target text as needed.
Check that brackets, commas, and references are complete.
Confirm that the parameter order matches your calculation goal.

Success Criteria

UI state: The formula editor shows a complete SEARCHB function structure.
Next actions: You can save the formula and review the returned result.

Tips While Using

Common mistakes: Missing parameters, unclosed brackets, or mismatched references can return an error.
Environment limits: The returned position depends on the actual text in the current record.

3. Type a sample formula and check the result

Entry point: Formula editor → Confirm

Type a sample SEARCHB formula in the formula field.
Click Confirm to save the formula.
Review the returned result in the current record.
After data changes or imports, check whether the result refreshes automatically.

Success Criteria

UI state: The formula field displays a calculated result.
Next actions: You can continue changing data and observing the result.
No side effects: You do not need to trigger recalculation manually.

Tips While Using

Common mistakes: If the formula format is incorrect, the result may not appear.
Environment limits: Automatic calculation after import depends on the formula field being saved correctly.