I will try this as a practice. Thank you for the solution.
I use these below steps to achieve above right ?
On your Collection, modify your Item Click action so it takes the value from the Make Array column and writes it to the multiple files column in the User Profile
Then once the user has finished making their selections, use an action to take the value from the multiple files column in the user profile row, and write it to the multiple files column in the Campaigns table.
You can then relate that column back to your Creators table, and you will have a list of all Creators associated with each Campaign.
I tried it , its only taking the first item as only that is clickable how can I make it take multiple rows in a single go like how you mentioned??
I am afraid I’ll need it because, I might have to edit the values.
But for this purpose I could make use of Collection item action for edit.
This would still mean I can see detail page right ?
The below needs to be two separate actions. The way you have it now you are clearing the value and setting it again every time. So the array will only ever contain one value. You only need to clear it once - when the screen is first opened.
Yes. What you can do is instead of clearing the column in the user profile, set it with the current array value from the Campaigns table, and then go from there. It would make sense to set that up on the Campaigns tab. You’ll see a collection there - you would modify the default action on that collection.
You need to change the default action on that Collection so that it first writes the value from the selected row into the User Profile row, then does Show Details screen. Then you set the Details screen up to work the same way as the Creators tab. Except you don’t need the choice component, as you’re already attached to the correct row.
Yes, I see. That’s a bug in my template. I sat the Creators list on top of the Users table and forgot to filter it. There are a number of ways you could address this:
Apply Row Owners to the Users table
Apply a filter to the Creators tab - “email is signed in user”
Move the Creators tab to sit on top of the Creators table instead of the Users table
