[Solved] How to delete an item from a delimited list?

Thunkable Discuss
, ,
#1

Hi, :wave:

I am making an App, where I have stored a delimited list in an Airtable cell.

The Airtable area looks like image.

The "1,2,3,4" will be set to a list-viewer, with this block

image
image823Ă—257 14.8 KB

What I exactly want is, when I select any item from the list, it should be removed from the Airtable cell.

For example, if I click "3" from the list, it should be removed from the list-viewer, and from the Airtable cell. Then the cell would look like - "1,2,4".

I tried doing it, and it didn’t work out well.

My blocks and the result

image
image713Ă—458 24.8 KB

Neither Airtable reflect any changes, nor the list-viewer.

What should I do?
Thanks! :blush:

1 Like
#2

Here you go.

Screen Shot 2020-04-02 at 11.36.44 AM
Screen Shot 2020-04-02 at 11.36.44 AM944Ă—902 80.6 KB

Remix Link:
https://x.thunkable.com/copy/b5053d2d80d94a42e939862dd5225be8

Preview Link:
https://thunk.app/w/gMGX4VX6I

2 Likes
#3

Hi, @jared! :wave:
Thanks for your reply! :blush:

Your idea works! :+1:

But, I have a small problem, which I forgot to say earlier (sorry for that) -

Now I have data in Airtable like :arrow_right: 1 - 2 - 3 | 4 - 5 - 6 | 7 - 8 - 9
Now with " | " as the master delimiter. So the items in the list would look like -

1 - 2 - 3
4 - 5 - 6
7 - 8 - 9

Your provided code, ultimately joins every list with “,”. How will I choose and delete “1 - 2 - 3” from a " | " delimited list?

Thanks again! :blush:

#4

Hi, @jared :wave:

I have dropped my above idea, and now I would like to just replace an delimited item. For example, my list is delimited with " || " character, and list is like 1 || 2 || none || 4
And I would like to replace the item no. 3 in the list, which is “none” with another term.

So,

  • I would get the list & un-delimit it,
  • Then I’ll get the 3rd term of the list, and replace it with something.
  • Then delimit it again with the " || " character.
  • And finally add it back to Airtable. So the new list would be 1 || 2 || 3 || 4

Any help is appreciated :smiley_cat:
Thanks! :blush:

#5

How does this work for you?
https://thunk.app/w/gMGX4VX6I

https://x.thunkable.com/copy/82bc8f3fa3f4961688f816f167b8b7c2

The only thing missing is the airtable blocks. I imagine you are able to extract info from the cell you want and then to replace it.

1 Like
#6

Hi Jared!

Your idea works! :smiley_cat:

I just modified it according to my data, and works brilliant :+1: :white_check_mark:

image
image1241Ă—621 81.3 KB

Thanks a lot! :blush:

1 Like
#7

Happy to help you out, man!

1 Like
#8

Thanks! :smiley_cat:

P.S. You are browsing at 2AM?! :hushed:

1 Like
#9

2:35… @domhnallohanlon mentioned It wouldn’t hurt to take a break from time to time. :joy:

I just finished a 2hr Flutter Training session. My eyes hurt!

1 Like
#10

Man, you must be a night owl instead of a morning person :joy:
You need some sleep! :smile: