When a record of a table that has a field of type "file", how to delete the file stored in the drive

[Paulo_Garcia]

When a record of a table that has a field of type "file", how to delete the file stored in the drive?

Scenario:
I have a table called "file", which has some fields among them a field called "file" of type "file", where a file is stored, this file is stored in the Drive in the AppSheet folder.
When I delete this record from the table the file is not deleted from the drive, how can I delete the file from the drive automatically?

[Joseph_Seddik]

With an Apps Script task through automation. 

Call Apps Script from an automation - AppSheet Help 

[Paulo_Garcia]

Hello,
Thanks for the help, I'm traveling, as soon as possible I'll try yours and the other solutions pointed out to see which one would be easier.
Thanks

[Suvrutt_Gurjar]

Please explore if the below top helps

https://www.googlecloudcommunity.com/gc/Tips-Tricks/Delete-app-images-or-files-in-an-app-record-from...

[Paulo_Garcia]

Hello,
Thanks for the help, I'm traveling, as soon as possible I'll try yours and the other solutions pointed out to see which one would be easier.
Thanks.

[Marco_Antonio_N]

Adicione a pasta que contém os arquivos como uma tabela em seu aplicativo

Assim você consegue apagar os arquivos 

[Paulo_Garcia]

Hello,
Thanks for the help, I'm traveling, as soon as possible I'll try yours and the other solutions pointed out to see which one would be easier.
Thanks..