Batch adding an option to varied Multiple Select

#1

Apologies if this question has been answered somewhere else! I couldn’t find anything in the topics section.

Basically, I need to add new selections to a multiple select column within a particular view. I can’t copy/paste because each row has other unique tags (It won’t let me add an image. Hopefully this makes sense).

It need to work so that when we send a new book out, the column will contain the books they’ve been sent + the newest book without having to add in several hundred manually one by one.

Anyone know how to do this? Thanks for your help!

0 Likes

#2

Let me see if I understand your scenario correctly. It sounds like a book club, so I’m going to call it that for the sake of this example. If I’m off the mark, let me know, but that’s what it sounds like so far.

When a person joins the club, they start receiving books on a regular basis. The older someone’s membership is, the more books they’ve received over time, and you want to track the specific books that each member has been sent. When a new book is sent out, you want that book to reflect in all members’ records without having to manually add it one record at a time.

Is that an accurate(ish) assessment of what you’re trying to achieve?

0 Likes

#3

Add formula field that lists the linked books, then adds the new book at the end of it: {Books}&', Name of New Book'

Copy and paste the formula column into your multi-select column.

You’ll have to do this with each time, and this assumes each person gets the same book at the same time, but this preserves each record’s unique tag combination

0 Likes

#4

Thanks so much, Kamille! This will work for what we need.

It would be ideal if there were a more straightforward way—this makes sense to me but it might be more difficult for me to hand off to an intern, for example.

0 Likes

#5

You might be able to do this with Integromat

  • Your [Books] table will need a {Created Time} field, use that field as the trigger
  • You’ll need a Search module to get all you team member records, passed through an Iterator module to execute the following task one by one
  • Another Airtable module to update a record by its ID. Have it concatenate the current record’s book list with a comma and the book’s record ID from the first module which retrieves the latest book.
0 Likes

#6

I think there is a quick and dirty way to do this(how I usually modify my multi/single select lists).

  • Create X number of new blank records(or let it auto expand and fill)

  • paste a list of values into the multiple select field and they will be added to the list

  • delete extraneous records

image
image

CTRL-V
image

delete records
image

Voila
image

0 Likes