Hi,
I wanted to get only one row of a column in airtable. Hence I set the maximum record value to 1. Till now everything was correct.
I wanted to display the text received from airtable in a label. Hence I added the following code…
What I get is the value of the spreadsheet but with two brackets before and after the text. Is there any way I can remove that and why is this happening?
Asd_fasd
(Asd fasd)
August 11, 2021, 2:07pm
3
If there are only two brackets(at the start and at the end) you can use segment block for delete them.
2 Likes
You can use two replace blocks even..
Asd_fasd
(Asd fasd)
August 11, 2021, 2:09pm
5
What if there is another bracket in the text?
Two replace block i mentioned , in one replace block ,can add ( and in another block he can add ).. even if more number of brackets obtained it will be removed
But dora method will be good to use.
1 Like
Asd_fasd
(Asd fasd)
August 11, 2021, 2:13pm
7
i mean if there is another bracket in the main text: for example main text is sqrt{25}=5. when he received this text it will be {sqrt{25}=5}. if you use replace block it will be sqrt25=5
dora_paz
(Dora)
August 11, 2021, 2:14pm
10
Airtable returns values as list, so since you are setting max record to 1 with above blocks you will get sqrt{25}=5
1 Like
Maybe this Steven Leary’s video can be useful.
This is a detail of code that replace ( )
1 Like
Thanks for your valuable reply. But using these blocks, I can only remove the bracket at the first but the last bracket still remains.
dora_paz
(Dora)
August 11, 2021, 2:25pm
13
@Didyme_Apps Why use so many blocks when in the specific problem it can be done with one block ?
Asd_fasd
(Asd fasd)
August 11, 2021, 2:26pm
14
oh i am sorry i sent the block without testing, write length.values - 2 instead of 1
It worked!!! Thanks a ton. Can you please edit the above solution so that i can mark it as the correct answer.
dora_paz
(Dora)
August 11, 2021, 2:34pm
16
I really can not understand the logic in that solution, you have a list with just one item and you want to use segment and …
2 Likes
Asd_fasd
(Asd fasd)
August 11, 2021, 4:30pm
19
done. you can mark it as a solution
Taifun
August 11, 2021, 4:56pm
20
Still-learning:
use two replace blocks
rather than removing brackets you should learn how to work with lists…
Taifun
4 Likes