Can't Clear Files Columns Programmatically (Tried [empty array] and Clear Value, Neither Work)

Hi everyone,

I’m running into an issue with my Glide automation.

I have several files columns in a Glide Table that store images (e.g. Fotos cocina antes, Fotos baños después, etc.). I’m trying to automatically clear all the data in these columns using a scheduled automation and a loop through rows.

I’ve tried two approaches:

  • Setting each column value to [] (empty array)
  • Using the Clear value option in the Set Column Values action

Neither approach is working — the images remain in the row after the automation runs.

Has anyone found a reliable way to programmatically clear files from a file column in Glide Tables?

Here’s what I’ve confirmed:

  • The columns are basic “Multiple files” fields (not computed or template-based)
  • I’m looping correctly through the rows
  • The automation is being triggered as expected (daily schedule)

I’ve heard that sometimes assigning a separate column that stores [] (empty field) as text and using that to overwrite the file columns may work — has anyone done this successfully in Glide?

Any help or ideas would be appreciated :folded_hands:

I explain the reason: In my business we upload a lot of images in a daily basis for quality purposes but once the services is paid and reviewed, we don’t need this images anymore, so i would like to delete them so they dont use my plans storage

Sounds more like a bug to me.

@comm_support_agent Issue for deleting file column from scheduled workflow.

@ThinhDinh May you change the category of this thread?

Thanks :slight_smile:

Are you able to use ‘Set Column’ → ‘Clear Value’, or is that showing as an option?

I am able but nothing happens

Is the column in question User Specific?

No its not @Darren_Murphy

Do each of those columns each contain just a single file?
If yes, why are you even bothering to use Multiple Files columns?

I just did a quick test, and this works as expected, so that indicates that something is wrong with your setup that you haven’t shown us yet.

1 Like

Here you go @Darren_Murphy

Most of the row contain more than one file but some of them contain only 1 file and some are empty

The filters that i am applying are basically one that ask to not delete files when the service is still open incidendia is not check

The other is the start date to delete the files

Let me know if you have other questions or if im not being clear on something, and thank you!

Can you try duplicating your table, and then run the workflow on the duplicated table with the filters removed. This will tell you whether or not the filters are causing the problem.

Also, can you show me a screen shot of the most recent run log?

I just duplicate the glide table and duplicate the workflow without any filter and still nothing

That screen shot confirms that the workflow is running, but it doesn’t confirm that it is actually doing anything. Please open one of the individual runs and show me what that looks like. It should be something like the below:

Also, can I please see a screen shot of the two columns that are referenced in the filter?

1 Like

I think that is the problem, is not targeting any data, i just did 2 tries

Here are the screenshots of the 2 columns, what do you think im doing wrong?

Do you see the same thing when the filters are removed?

same

I was able to find the logs of the filtered workflow

That log seems to indicate that it is working.
How many rows are in the table?

I think that may be the issue, there is 3k and i had the limit at 100 and the first 800 rows have no files on them

i just put the limit at 1k to see if it works, do you know how to loop them from bottom to top?

as soon as the workflow finishes ill send you the logs

You can add an additional filter so that it skips rows that have no files.
What you might be better off doing is starting with a Query that applies all your filters, and sort it in reverse table order. And then loop through the query instead of directly through the table.

I have not done that so please guide me

like this right?

I applied the order and filters to the query and then loop the query

Yes, that looks correct :+1: