Hello, I've currently got a pipeline that is triggering based on a Checkbox - Formula Field. The formula returns true if a file is uploaded. The first time that I trigger this, it works as expected, and my pipeline then processes, and deletes the attachment (Via an API call). The problem, is that the 2nd time I try to upload a file to the same file attachment field, the pipeline not be called again. I've even added a field to update at the end of the pipeline so that the record is saved again. I know that in general you should avoid using Formula Fields to process this flow, but I'm a bit at a loss how else I could detect if a file is uploaded or not (more than once, at least). ------------------------------Jake Mauk------------------------------

what's the formula? i'm assuming that you mean that you have the formula-checkbox as the condition on the Record Update step... so if it's not triggering the second time. you'll have to provide what the formula is doing so we can help you. Is it really just checking whether there is a filed attached on a field?------------------------------Tim D------------------------------

Yes, you are correct that the Record Update triggers on the field for the Checkbox Formula. Currently that formula is as such: If(ToText([AttachmentField]) <>"", true, false) It returns true/false as I expect it to depending on if there is anything in the attachment field, but only the first file uploaded triggers a pipeline.------------------------------Jake------------------------------

I thought that "passive" changes didn't count as triggers? I've not messed with attachment fields in a while, but can you not set the PL to trigger when the attachment field changes? You could use the checkbox field as a safe guard though. Changes to the attachment field trigger the PL, but you filter it to ONLY run if the checkbox is checked. That way, if someone deletes the attachment it doesn't run the PL.------------------------------John Ross------------------------------

It is also my understanding that Passive triggers do not work on these for the most part. The fact it only triggers once is what is confusing me on it. If it never worked I wouldn't have gotten in so deep on it, haha. I actually tried it when the attachment field changes - But that doesn't seem to trigger the Pipeline at all, unfortunately. This would have made things much simpler for me.------------------------------Jake------------------------------

When you say it triggers once, is that upon uploading a file for the first time or uploading a file in a new record and then saving it? Hmmm, I could have sworn that file uploads counted as a "active change/edit". Is your trigger step "on edit", or "On add or Edit"?------------------------------John Ross------------------------------

Formula Field Update | Qrew Discussions

TimD
Qrew Trainee
2 years ago
what's the formula?

i'm assuming that you mean that you have the formula-checkbox as the condition on the Record Update step... so if it's not triggering the second time. you'll have to provide what the formula is doing so we can help you. Is it really just checking whether there is a filed attached on a field?

------------------------------
Tim D
------------------------------
- Jake1
  Qrew Member
  2 years ago
  Yes, you are correct that the Record Update triggers on the field for the Checkbox Formula. Currently that formula is as such:
  
  If(ToText([AttachmentField]) <>"", true, false)
  
  It returns true/false as I expect it to depending on if there is anything in the attachment field, but only the first file uploaded triggers a pipeline.
  
  ------------------------------
  Jake
  ------------------------------
  - JohnRoss3
    Qrew Member
    2 years ago
    I thought that "passive" changes didn't count as triggers?
    
    I've not messed with attachment fields in a while, but can you not set the PL to trigger when the attachment field changes? You could use the checkbox field as a safe guard though. Changes to the attachment field trigger the PL, but you filter it to ONLY run if the checkbox is checked. That way, if someone deletes the attachment it doesn't run the PL.
    
    ------------------------------
    John Ross
    ------------------------------

Forum Discussion

Formula Field Update