How can i remove " (abc) "

how can i remove
example
data back from google sheet between two parentheses like this
(abcdefg) I want remove parentheses and data back like this abcdefg

This is because those are lists

Are you going to use dynamic components to show all data or do you want to show specific info ?

also back with two parentheses

Example, spreadsheet format

image

Blocks for getting column 2 in a label

Result

In first label with html enabled
In second joining names with comma separator

1 Like

its working but i need select row to show and i want chose
for example if name = sabagh i want this row if name else don’t show any data

this is my block

If I want to show only the row that contains data saved in tinyDB, here is an example

image

thanks for your support but still not working see my block

Post a screenshot of your spreadsheet

Username sabagh appears 5 times in your spreadsheet. You want to get all info for all rows that contains that user name ?

yes all thanks

This post was flagged by the community and is temporarily hidden.

This post was flagged by the community and is temporarily hidden.

Change Set List’s Elements from String

image

to Elements

its working but i need all sabagh user this show only one user

problem solved thanks for support

great
then please provide a screenshot of the solution
thank you
Taifun

1 Like

solution is



Change Set List’s Elements from String to Elements
but i give list height