Searching a concatenated text string with "contains"

[Nick D]

I have two text fields, TextField1 and TextField2. I have a calculation field that concatenates them together as Textfield1+” “+TextField2. I have set the calculation field to return text. When I try to search the calculation field, Tap Forms is treating it as a number–I can only search “is”, “is greater than”, etc rather than “contains”, “does not contain”, etc.

How can I search a calculation field that’s a concatenation of text as a regular text field, specifically with “contains”?

Thanks.

[Brendan]

Hi Nick,

Ah I see. Since support for concatenation of strings is a recent new feature, I guess I neglected to adjust the search rules comparison operators to treat those types of calculations as text instead of numbers.

I’ll correct that for the next update.

Thanks!

Brendan

[Nick D]

Awesome, thanks!

[Brendan]

I have made this fix for the next update now.

[Author]

Posts