Delete records automatically which are older ...

(Etwo Cargo) #1

Delete records automatically which are older than 3 months? Is that possible?

(Philip Garrett) #2

@Etwo_Cargo

One way to do this would be to create a Report that runs periodically. Assuming you stored the record creation date in the record, you could detect which records should be deleted based on their creation date. Your Report could invoke a webhook that used the

AppSheet API to delete the expired records.

(Levent KULAÇOĞLU) #3

@Etwo_Cargo As @Philip_Garrett_Appsh suggested you can use Scheduled Reports to invoke a webhook to AppSheet API which will need a Pro Plan subscription. If that’s not the case, then you can write a time-triggered script to your gSheet which will delete the old data.

(Etwo Cargo) #4

@Levent_KULACOGLU hocam desteğin için minnettarım. Saol.

Translate