Skip to main content
Solved

Trigger RULE is there is a change in an attachment field

  • November 20, 2024
  • 0 replies
  • 185 views
Forum|alt.badge.img+8

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 is someone saves over the attachment again (they may or may not change the name).

How do track that an attachment has been modified?

Thanks!

Deepa

Best answer by MarkShnierYou

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)

View original

MarkShnierYou
Forum|alt.badge.img+24

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)

Mark Shnier. Your Quickbase Coach
Forum|alt.badge.img+8

Thank you Mark! You are a savior as always!

Terms & ConditionsAccessibility statement