Need guidance and help in Make array column to remove users from array , using trebuchet method

[Dilip_Adiga]

Hi Guys,

Good day!

I followed help from Darren and watched a video of Robert on Trebuchet method

I have creators table which houses all my creators with criteria,

I first apply Query by using JS and filter creators into a Layer 1 filtering List a d save the creators in a saved search table

Then I Display the saved search creators under the name they are saved in and show the saved query response in the collection as creators

It has a Make array column to add creators and Remove element for removing creators.

This is used to select and deselect creators , Its shown in the table below

I store the selected creators list in users table under Multiple files column as shown below

I have a table which houses all my campaigns created which houses campaigns name and ID and also has a multiple files column which sends in all the creators selected as shown below

How it works in the UI

When creators are selected in the selection page there is a choice component which lists all campaigns created → I select the campaign in the drop down → select the creators from the list → click on move to campaign button → it sends the selected creators to campaigns multiple file column

The creators copied as Listing fine under the campaign.

My Problem

1. When the campaign lists all creators → I want to remove creators from that list, how do I do it?
   Removing the row deletes the creators from main database itself

Is it possible to use “Remove element from set” ? if yes how does it work? I tried reading the documentation but couldn’t understand much

2. I moved the selected creator after accepting the to new table by clicking on Add new row.

But when I click it it takes me to detail page → of creator.

How can I make it open the detail page of the element from new table?

I know in list its straightforward, how do I do it when sent from array?

Should I move it as an array or individual creators data?

3. I need to add comments for reason for removing them → how do I do it and where can I store it?

Have been stuck with this would appreciate any help in clearing my doubts.

Thank you in advance

Regards,
Dilip

[Dilip_Adiga]

Arrays concept has got me confused now.

How do I handle the item click so that it doesn’t go to the main creator table.

But it should open the new table source which has this Creator name

Reason is because I have other new fields which will need to be entered by the person using this tool

Regards,
Dilip

[Dilip_Adiga]

Hey Guys,

I handled the scenario of click on items by using Filter criteria

using the “screen” option

Regards,
Dilip