Hi Team,
need to make sure when @ is typed in a search box it shows all the available addressable names in the box.
Example.. if i search @S with should display a list of all the name which starts with s or includes s in the search box recommendations
Hello Saif,
If you are just trying to achieve search using the keyword which can be anywhere in the string, then you can use the 'Like' operator.
Something like: client.Email like "%" + SearchKeyword + "%"
This will filter out the the string which contains the SearchKeyword.
Also, if you want to enable this feature only after entering '@', then you can use the Substr() function to validate in th OnChange action of the search widget if the user has entered '@'.
Hi saif sheikh,
which widget you are using, because i can able to see the checkbox also
Hi Ellakiya, i am referring to the input box of search.. if i type E into the input box with search prompt, it should display all names in the list with E
Hi Saif,
What did you mean by addressable names? Any difference with the other items in the list?
If the list in your dropdown contains only the names, then why would you need @ symbol? and why any special treatment for the @ character?
If you type the character s, it should anyway display all the names in the list that start with s or contain s character.
Please explain what would be the difference if you enter the character with or without @ symbol.
Hello,
Question: I can see that list includes email addresses and not names. Inclusion of '@s' might be fetching zero results as of now. Is this the case? If Yes, re-adjusting on change filter might help.
Searchable dropdown when implemented properly should fetch all the entries which contain "s" when user types only "s" in searchbox.
To trigger this only when "@" is present at start-
1. Use text before '@' from email options. [Get position for @ for each option using
Substr(TextOption,0,Index(TextOption,"@",searchFromEnd:True,ignoreCase:False))] for each entry.
2. Add custom logic to check '@' is present at SearchVar[0], If True, Use List Filter to get all entries which include SearchVar[1:] in them.