Is in list query

[rhem21]

hi, i tried to search for a topic that can answer my query but none i found.

im trying to to compare user id input from user and compare to UID on my database. when i display the UIDs tru label it show ["aaa aab"] but if i enter aaa or aab it still return false. how does "is in list" compare to user input sirs? thank you in advance

[ABG]

In the Web 1.GotText, the response content looks to be a text Join of IDs with a blank between them .

In that event, set global Uid to Split response content at Blanks to get get a list of IDs.

P.s. if that's \n between the IDs, use the split at \n block instead.

[rhem21]

thank you sir, but now im getting extra space after every items, only the last item dont have that space, therefore return the true value, i tried to use trim but didnt work, but it helped to remove blank cells from gsheet and display only non blank cells.

[rhem21]

thank you so much sir, i made it work by using split at spaces