18

change it to a setup where you are eliminating potentials for capitalization to be a problem…you would have to do this by creating a group, make it type text and datasource is the input elements value:lowercase (this is because your also need to make your database entries lowercase as well dynamically and we are not able to through dynamic expressions when comparing two sources values against each other to use the lowercase operator on the second value in the comparison expression). It also has to be done because Bubble contains comparative is case sensitive

… contains

This operation tests if the first entry contains the argument. The substring of text should match the sequence of characters of the first entry exactly, including case. This search respects the order of the words in the entry.

For example, searching for ‘cat’, ‘hat’, ‘cat in’, ‘cat in the’, ‘in the hat’, ‘at in’, or ‘cat in the hat’ would all return the phrase ‘the cat in the hat’.

However, searching for ‘cat the hat’, ‘cat hat’, or ‘Cat’ would not return ‘the cat in the hat’. This search is useful for returning exact matches for partial words, like searching ‘pepp’ and returning ‘peppers’.

Make your search with built in constraint be combined_postcode_suburb:lowercase contains group inputs value lowercase.

Make your Repeating Group set to display at max maybe 10 items and likely for design reasons, it should be limited to 5 if you don’t want the ugly scrollbar and a clean ‘dropdown’ like selector made from groupfocus and repeating group.

One thing that might also need to be done based on the ordering of items in the value to compare as in the example from manual of cat in the hat…you may need to split your data field (since it is zip plus other values as single string)…or maybe structure the single string properly so it is 9000|suburb_name|other_details…which causes it to be treated as single word and then should remove the issue of contains operator being order driven.

Lastly, if you are still stuck on this in two weeks, reach out to me directly as I’d be interested to test my own tools against the issue.

1 Like