Compare text field with string

yuliia.kryvenchuk · 2020-07-10T13:30:29.852Z

Hello everyone! I have an entity Car Part which has only one field of text type called Title. I am trying to do a search for Car Parts with constraint Title = “Break pads” or any other string, but it won’t let me.

image670×650 27.9 KB

Could you please help me. Isn’t it possible to compare a text field to a string?

Thanks!

TipLister · 2020-07-10T13:56:29.531Z

hi, this can normally be done with bubble.
Is break pads a field type text?

You just have to type in Break pads without the “”.
However, it has to be EXACTLY the same capitalization as in the database.

yuliia.kryvenchuk · 2020-07-10T13:59:09.813Z

Hi! Break pads is not a field. I am trying to compare field Title to a string “Break pads”, basically trying to search Car part by its Title. Comparing a text field with a text field does work.

TipLister · 2020-07-10T14:05:58.468Z

if you go to database and car parts could you screenshot that please?

I know break pads is not field type text but what I mean is that the field break pads is saved in is, right?

yuliia.kryvenchuk · 2020-07-10T14:27:18.730Z

So Car parts structure:

image612×614 26.3 KB

All existing Car parts (Break pads):

image2302×452 82.3 KB

Doing a search to return Car part entity with Title = “Break pads”

deadpoetnsp · 2020-07-17T00:18:32.314Z

There’s a weird thing in Bubble where you will have to click outside the dark box first, delete the “click” and then type the text you are looking for (without quotes). I know what you are facing, just click after it, hit backspace to get rid of the dark box after the equal to sign and then type your text.

yuliia.kryvenchuk · 2021-09-02T18:17:53.972Z

Hi! I am very sorry, I just saw that I totally forgot to say a BIG THANK you!!

anon95673267 · 2021-09-09T01:45:45.890Z

Can’t thank you enough. I can’t believe this wouldn’t be explained properly somewhere, so someone doesn’t have to spend hours trying to figure out what they’re doing wrong.