Forum Discussion
JamesTrory
7 years agoQrew Assistant Captain
Hi,
I see now. I didn't know I could create a report link between the same field in the same table.
I've created a report link in Shots to link the Record ID with itself which now lets me use that link to modify a field in Shots called Reshoot, to which I write YES (indicating that the record is flagged as reshot).
I still can't get this to work though. I need the Action to add two new records the first time the Shot is modified - one record for the new entry and one record for the old entry. Then, for any subsequent modifications, only record the old record.
The problem I'm having is that in an Action I can't specify criteria BEFORE a record is modified, only after. So I can't say "if a Shot already has YES in the Reshoot field, do not fire the Action".
I can do this with Automation, but I can't add old records after modification using Automation. I can only add new records. I can't find a good balance between using an Action simultaneously with an Automation.
I see now. I didn't know I could create a report link between the same field in the same table.
I've created a report link in Shots to link the Record ID with itself which now lets me use that link to modify a field in Shots called Reshoot, to which I write YES (indicating that the record is flagged as reshot).
I still can't get this to work though. I need the Action to add two new records the first time the Shot is modified - one record for the new entry and one record for the old entry. Then, for any subsequent modifications, only record the old record.
The problem I'm having is that in an Action I can't specify criteria BEFORE a record is modified, only after. So I can't say "if a Shot already has YES in the Reshoot field, do not fire the Action".
I can do this with Automation, but I can't add old records after modification using Automation. I can only add new records. I can't find a good balance between using an Action simultaneously with an Automation.