Hello Coda Community,
I am experiencing an issue with the search functionality in a ‘Detail’ view in one of my tables, specifically when searching for concatenated fields.
Issue Description: I have a table with a “Full name” column, which is a concatenation of “First name” and “Last name” columns and set as a ‘display column’. The concatenation itself works perfectly, but the search functionality in the ‘Detail’ view is not behaving as expected.
Example Data:
- First name: Janusz
- Last name: Kowalski
- Firm: HubSpot
- Full name (auto-generated): Janusz Kowalski (HubSpot)
** Formula: Concatenate(thisRow.[First Name]," “,thisRow.[Last Name], " (”, thisRow.Company, “)”)
Search Behavior:
- When I search for “Janusz”, the search returns several results, which is fine.
- Searching for “Kowalski” also yields results, as expected.
- However, when I enter “Janusz Kowalski” (part of both first and last names), there are no results, which seems incorrect.
Additional Information:
- I will attach screenshots showing the search results for each of these scenarios.
- This issue seems specific to searches where part of the concatenated ‘Full name’ is used.
Request for Insights or Solutions: I believe this might be a bug in the search functionality, especially when dealing with concatenated fields in a ‘Detail’ view. Has anyone else experienced this? Any insights or workarounds would be greatly appreciated.
Thank you in advance for your assistance and insights.
