Forum Discussion

DeepaPrashant1's avatar
DeepaPrashant1
Qrew Cadet
2 days ago

Trigger RULE is there is a change in an attachment field

I have  RULE that says when "Ready for Approvals" is checked and an attachment has been added, it triggers an email. Now I want that email to be triggered again if the attachment is modified, that i...
formula query
  • MarkShnier__You's avatar
    MarkShnier__You
    22 hours ago

    I suggest the following.

    1. Form rule that says when the file attachment is not blank, then make read only file attachment.
    2. Button called Upload New File Attachment which will display if the File Attachment is not blank.  This button will delete the file attachment and and land the user in edit mode.

     

    var text DeleteFile = URLRoot() & "db/" & dbid()

     & "?act=API_EditRecord&rid=" & [Record ID#]

    &_fid_99=&delfile_fid_99=1;

    var text DisplayInEditMode = URLRoot() & "db/" & dbid() & "?a=er&rid=" & [Record ID#];

    $DeleteFile

    & "&rdr=" & URLEncode(DisplayInEditMode)

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
22 hours ago

I suggest the following.

  1. Form rule that says when the file attachment is not blank, then make read only file attachment.
  2. Button called Upload New File Attachment which will display if the File Attachment is not blank.  This button will delete the file attachment and and land the user in edit mode.

 

var text DeleteFile = URLRoot() & "db/" & dbid()

 & "?act=API_EditRecord&rid=" & [Record ID#]

&_fid_99=&delfile_fid_99=1;

var text DisplayInEditMode = URLRoot() & "db/" & dbid() & "?a=er&rid=" & [Record ID#];

$DeleteFile

& "&rdr=" & URLEncode(DisplayInEditMode)