Hi Himaldin
This is the video of using the app
This is the template for you to try.
Let me know if it works
Regards,
Dilip
Not sure what Bulk action is , I am using normal action to copy data to campaigns.
I am not using any form
Yes its adding to my multiple files column in campaigns when I click on copy to campaign.
Issue is if I try adding more its deleting the previously added data and adding only new one.
As shown in the screen recording
Regards,
Dilip
@Dilip_Adiga, Iâm currently unable to watch your video, could you try it yourself first?
What I mean by âbulk actionâ is an action taken after selecting multiple options.
However, as a clue for you, basically, you can repeat the process of adding and removing arrays repeatedly in other tables. With this principle, you can still keep the previous selections from being deleted. Perhaps you can add a specific user column as a transitional step before a definite action to delete or add.
Ok let me give it a try
Do you mean to say I add a user specific Multiple files column in user table ?
Can you elaborate it a it? Sorry new to this.
Because this wont work as it will change every time I move between campaigns right ?
Regards,
Dilip
Forget what I said.
It was just a passing thought, giving you possibilities if there are things related to the context specifically for users in managing your form as a transition before submitting. After that, through your lookup column, you can convert it into an array.
I am assuming you mean Copy to campaign?
But the issue of older values coming still will persist.
I would need an approach like where I would need to store each result in a array column and add as and when more are added with avoiding duplicates.
not sure wether there is anything I can do ti achieve this?
Regards,
Dilip
If you only mean to avoid duplicates, the solution lies in filtering with conditional settings so that those items are not selected again.
No itâs not just avoiding duplicates.
I would want older values too right? This is the part that has me in confusion.
Cant think of approach to do this.
Regards,
Dilip
1 Like
@Himaladin did you get confused on what I want?
Regards,
Dilip
I donât know⌠Iâm just an AI bot, following your questions. 
Perhaps your application is too complex. Try simplifying it starting from your own thoughts.
1 Like
I agree that my use case is a little complicated. I think its my lack of knowledge that might be a barrier to me thinking of solution.
Thank you Anyways.
Regards,
Dilip
1 Like
According to your thread title, and you already know that your data is stored in an array column and how to prevent it from being deleted. Itâs just about what you want.
From my perspective, there should be no duplicate creators in your array. Unless you want to continue to another session, where you would certainly need to open a new sheet/row for your campaign sheet and of course, need a timestamp column as well.
I am very impressed and envious of your hard work in pursuing something, this is your positive side. Good luck trying again.
Correct that is the use case I want to solve. But my only issue is when I clear all selection â which will happen in most of my case and add few new creators again by clicking on copy the older creators are deleted and only new ones appear in the array.
Just want o prevent this.
Actually itâs not about having duplicate creators, I just want some way where the
Thank you Himaldin. I think itâs constant support from wonderful people like you , Darren, Nathan and many more that we are eager and interested to work and learn more on Glide.
Regards,
Dilip
I havenât been able to watch your video yet. However, based on your statement, I will give you questions as a reflection material:
- Are your copy and reset buttons still relevant for use?
- If yes, what if all elements containing the copy and reset buttons are placed in a form? I mean, the action of deleting and copying will not actually be copied/deleted until the submit button is pressed, so you can still add your new and old values in your custom action on your submit button.
I hope this helps you think clearly.
Yeah, its very important for me to have it.
Oh you mean like a normal form? That would not work as per UX because I can have more than 1000 creators right? il have to keep searching and adding creators in large numbers
Regards,
Dilip
@Darren_Murphy Greetings!
is there a way I can write my Multiple files column output to some other column type?
Idea is whenever my multiple files column values are written again and again, though it gets replaced in multiple files column as such, but to other column it writes it holds the previous values whatever present.
Removing any duplicates.
Is there any other file type that I can write to achieve this?
Thank you in advance
Regards,
Dilip
@Dilip_Adiga, your videoâs audio is hard to hear, so I ended up looking at a copy of your app. Please correct me if Iâm wrong in understanding your workflow. From what I understand, youâre having trouble implementing the trebuchet method from your âSearch Savedâ sheet, right?
Below, Iâve included an image that simply shows that for a new Glide, you can actually take a collection from another sheet or wrap it with a custom collection to switch sheets. With a little filter setup, you can filter as you wish.
What I observed is that your 2 button actions have not implemented how to add or remove arrays. Your reset button clears the value, which will, of course, erase all previous selections.
Perhaps your buttons should directly work on the creatorâs side where your array column is placed and it seems not to affect what youâre doing now.
Another way is I use a single value column to pull the array column from your creatorâs sheet into your âsearch savedâ sheet. From here, you can change the action of your reset button.
Thank you for the detailed reply Himaldin, I really appreciate it.
Yes you are correct , In my search saved UI, I might add creators from any searched list to same campaign. If I reset and add from other saved List it deletes the previous selected items and adds this.
I didnt quite get how this will help my use case?
I think it has been right? Array set up for selected items are present in Creators table. Which writes to user table and on press of Copy button copies selected creators from user table to Campaigns table. (But as multiple files)
Dont you think if I work on it, my selections will be altered? Then ill not have control over data being written to campaigns table right? It would still replace the existing values in the campaign when I remove the selection and add new ones
I dont think this will work even if you reset values in here, According to screenshot it takes the first row of the saved query, so all saved searched will have same values as first column value. That wouldnât work right ?
Let me know if I am wrong or right.
Thank you for your patience.
Regards,
Dilip
If you see my campaigns table, there is a Multiple file column with name âAll selected creatorsâ
Is there a way I can add the values present here to some column in such a way that whenever values are replaced in this column it gets added to previous values stored in new column?
Regards,
Dilip
Yes, essentially you can pull arrays into all tables using the âsingle valueâ column that I showed earlier.
Iâm currently out and about. If youâre willing to try tweaking the button actions and columns from various angles, or creating a set of double value columns, Iâm sure it can work. The key is, your âselectedCreatorsâ array column hasnât been utilized yet. This column is the one that will store the complete data, while you can wait for @Darren_Murphy for the time being.