Reupload Data with DataShuttle
I would like to create a tool which uses Data Shuttle. Basic idea is to ask user to upload attachment (via a form) which would trigger a data shuttle and info in the attachment would go to a transition sheet from where it would be moved to the target sheet with automation. It works nicely, however, I need to consider the possibility that they want to correct a previously uploaded data. In an ideal world I would add a check box to the form saying "Reupload?" and if they tick it it would trigger a mechanism which would delete the formerly uploaded data (maybe based on a common identifier and the value of the check box). Do you know if this is possible to achieve? I tried to insert the checkbox but it didn't update the Reupload column in any way (I guess due to the data shuttle and automation).
Basically I would like to avoid creating a duplicate sheet from the target sheet which would need to be manually maintained.
What do you think?
thank you for your help in advance ☺️