＜Steps＞

1. Open the app and click the gear icon at the top right of the screen.
2. In the "Form" tab, place a "Text (1 line)" field.
3.  Hover over the gear icon at the top right of the placed "Text (1 line)" field and click "Settings."
4. Check the "Calculate automatically" option, set it as shown below, and click "Save."
   

   Example:
   To make the value of a "Radio Button" field (field code: Radio Button) searchable:
   Overview of Field Codes
   
   Placed "Text (1 line)" field name: Searchable Radio Button
   Formula: Radio Button

   Note

   • If you reference field types like "Date" or "Date and Time" in the formula, the value will be displayed in seconds. Use the DATE_FORMAT function to set the formula to display it in a readable format like "January 1, 2025."
     DATE_FORMAT Function: Specifying the Display Format of Date and Time
     
   • If you want to make fields like "Check Box" or "Multi-choice" searchable, use the IF function.
     Example:
     Settings for the "Check Box" field you want to search:
     ・Field code: Check_box
     ・Options: sample1, sample2
     
     Formula for the searchable "Text (1 line)" field:
     IF(AND(CONTAINS(Check_box, "sample1"), CONTAINS(Check_box, "sample2")), "sample1, sample2",
     IF(CONTAINS(Check_box, "sample1"), "sample1",
     IF(CONTAINS(Check_box, "sample2"), "sample2", "")))
     IF Function: Change the Value to Display Depending on a Condition
     CONTAINS Function: Determine If a Field Contains an Exact Match for a Specified Character String
5. Click "Save Form" at the top left of the screen.
6. Click "Update App" > "Update App" at the top right of the screen.

　

　

＜References＞

• No match in search result.