how do i get a text input that says words say that something contains it using google sheets? rightnow all it can say is yes or no but I want it to say what words it contained
I’m not sure I understand your question. Can you give a few examples?
i want it to show text from an input in the app and say that it contains certain words and those certain words are in a google sheet
Okay but that’s a description of what you want. An example would be like this:
My Google Sheet has values including:
apple
orange
banana
If the text input is:
ban
Then a label will display:
banana
Is that what you mean?
kinda i just need a join thing so it says “it contains banana”
You’re not providing enough information but maybe you’re just looking for the Join block?