I was wondering how can I delete all the data stored in a form log once the item gets deleted from the form?
I have a table where I can input a part number, its description, quantity, location, etc. Then I created a form log that keeps track of every change done on that part number. If I change the qty or the location then the log will keep track of those changes using IFTTT Audit, similarly if a new part gets created. Like, it tracks every change on the table and displays it on another table. Now, my issue is that if you delete the part number from the 1st table, the form log does not disappear at all for that part. Is there a way to make sure that the log erases the data of the part, if the part no longer exists on the form?
*sorry the tables are a bit messy, I'm trying to test a lot of different features.
1st picture: table where items are added
2nd picture: records stored in the form (exactly same information as above)
3rd picture: form log
Hi
You can add an IFTTT macro into your original form that deletes records in the _log form set to execute on onDeleted event
The filter to delete will be
_ref:[entry.id]
Form name: myform_log
Alex
Obviously, it will start to delete only the records that you will delete AFTER you have set up the rule to delete. All the other orphaned data you will need to delete yourself
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You will probably need to remove those rows manually (from a _log form)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You cannot do it via UI, sorry
it is either through the REST API or setting up a rule like I have explained earlier
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.