nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Adding Member to the List Based on Google Sheet

Jason Tan_s7psk1

Current Situation

In this board, I have two lists - Day and Night. These two lists are already created within the boards. Both lists also have card created and there is only one card within the list.

I have 10 members who are A1, A2, A3, A4, A5, B1, B2, B3, B4, B5.

Think of A1 = Jason, A2 = Craig etc...

A1 - A5 are assigned to Day whilst B1 - B5 are assigned to Night.

Challenges

Over the time, I would like the different members assigned to each of the board. For example, A1 - A5 are currently assigned to the card in the Day list and often they stay the same until I change up the members for the card in the Day List. For example, I just want to simply mix it up by having A1, B1, A4, A5 and B5 assigned to the card in the Day List for next month. For the month after, it will be randomly mixed again with B2, B3, B4, A1 and A3 being assigned to the card in the Daylist on the month after.

For this step, I have to do it manually.

Objective

I would like to automate the steps of assigning / rotating (randomly) the members to each of the the card in the list weekly.

What have I tried?

I have tried to use Zapier but I stumble into issue which requires organisation, when trying to use the function of "Find Members". I can't seem to change my board from Private to Organisation. See print screen

Has anyone ever tried this or any other solution to make it working?

Accepted answers

Iain Dooley

@Jason Tan can you explain what this means?

"I would like the different members assigned to each of the board"

Maybe if you provide some elaboration on what the real world scenario here is, rather than describing it in the abstract, the functionality you need will be clearer

All comments

Iain Dooley

@Jason Tan can you explain what this means?

"I would like the different members assigned to each of the board"

Maybe if you provide some elaboration on what the real world scenario here is, rather than describing it in the abstract, the functionality you need will be clearer

Jason Tan_s7psk1

Hi @Iain Dooley

Updated the details with better and more examples. Would this be making sense?

Iain Dooley

@Jason Tan i think there are some gaps in the terminology. Here are the parts I can't understand:

"A1 - A5 are assigned to Day List whilst B1 - B5 are assigned to Night List."

You can't assign Trello members to a list. What are "A1 - A5" are they Trello users? Are "Day List" and "Night List" lists in Trello? Columns in a Google Sheet?

"I would like the different members assigned to each of the board"

You can't assign members to a board. Do you mean add them to a board? Which board do you want to add them to? Do you mean assign members to a card? Which cards do you want to assign them to?

---

The rest of it I can't understand for similar reasons, once you clarify the above I might have a better idea of what's going on.

Jason Tan_s7psk1

A1 (Jason) - A5 are the Trello members whom I have invited to join the board Hello World.

In the Hello World board, I two Lists - Day is one list and Night is the other list.

Each of these Lists (Day & Night) in the Hello World board have got invited Trello members assigned to them.

Could this make better sense?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

trello

automation

group

zapier