Unanswered

Searching text fields not able to find comment field.

(0) Share

Report

Posted on by rroque

350

I can't seem to find the correct syntax to search comment field. The function cannot find the comment field below. This is a single line text. Any help would be greatly appreciated.

Here's the code in question.

Filter(OPTrack_FormsInventoryEnhancedTables, txtSearch.Text in FORM_NO || Text(dteReqDate.SelectedDate) in REQ_DATE
|| Text(dteReqDate.SelectedDate) in LAST_INVEN || txtComment.Text in COMMENT);

Categories:

Using Apps Using Formulas

All responses (9)

Answers (0)

rroque 350 on at

Like (0)

Report

Re: Searching text fields not able to find comment field.

Yes I did found the problem and fixed it.
The fix was to add the comment field to the items property of the list. Thank you.
rroque 350 on at

Like (0)

Report

Re: Searching text fields not able to find comment field.

Hi @anandm08 thx again. I tried your code but no difference. I don't know what else I can check.
Revised code.
Filter(
OPTrack_FormsInventoryEnhancedTables,
txtSearch.Text in Text(FORM_NO) ||
txtSearch.Text in Text(REQ_DATE) ||
txtSearch.Text in Text(LAST_INVEN) ||
Lower(txtSearch.Text) in Lower(COMMENT)
)
anandm08 1,936 Super User 2025 Season 1 on at

Like (0)

Report
Re: Searching text fields not able to find comment field.

Filter( OPTrack_FormsInventoryEnhancedTables, txtSearch.Text in Text(FORM_NO) || txtSearch.Text in Text(REQ_DATE) || txtSearch.Text in Text(LAST_INVEN) || Lower(txtSearch.Text) in Lower(COMMENT) )
try this
rroque 350 on at

Like (0)

Report

Re: Searching text fields not able to find comment field.

hi @anandm08

Here's the revised code.

Filter(OPTrack_FormsInventoryEnhancedTables, txtSearch.Text in FORM_NO || Text(txtSearch.Text) in REQ_DATE
|| Text(txtSearch.Text) in LAST_INVEN || Lower(txtSearch.Text) in Lower(COMMENT));
rroque 350 on at

Like (0)

Report

Re: Searching text fields not able to find comment field.

Here's the revised code. I included you lower instruction code.
Filter(OPTrack_FormsInventoryEnhancedTables, txtSearch.Text in FORM_NO || Text(dteReqDate.SelectedDate) in REQ_DATE
|| Text(dteReqDate.SelectedDate) in LAST_INVEN || Lower(txtComment.Text) in Lower(COMMENT));
rroque 350 on at

Like (0)

Report

Re: Searching text fields not able to find comment field.

@anandm08 Thank you for the lower code. I tried the lower code and it is not finding my comment field.
rroque 350 on at

Like (0)

Report

Re: Searching text fields not able to find comment field.

Also the lower example isn't delegable.
rroque 350 on at

Like (0)

Report

Re: Searching text fields not able to find comment field.

Here are the advanced properties.
anandm08 1,936 Super User 2025 Season 1 on at

Like (0)

Report
Re: Searching text fields not able to find comment field.

hi @rroque ,
there might be potential issues like case sensitivity or exact match requirements. Some systems might require an exact match, meaning that if txtComment.Text contains "hello", it will only match a COMMENT field that contains "hello" exactly and not "Hello" or "hello there".
Here's how you might adjust the syntax:

Lower(txtComment.Text) in Lower(COMMENT)