Discussions

Formula URL to Open a File Attachment Field?

  • 1.  Formula URL to Open a File Attachment Field?

    Posted 12-12-2017 22:45
    Hello,

    I in my button, i would like to encode information, save the changes and then pop open a new window which "Prompts" the end user to save a photo from their devices...this would essentially mean that the File Attachment field id #43 is clicked without having to click the button.

    Im struggling to script the final "open the new window."

    Your help is appreciated!


    URLRoot() & "db/" & [_DBID_CUSTOMER_DELIVERIES__TRUCKS_]
    & "?a=API_EditRecord&rid=" & URLEncode ([Record ID#]) 
    & "&_fid_45=" & URLEncode(true)
    & "&_fid_44=" & URLEncode(Now())
    & "&_fid_13=" & URLEncode("Delivered")
    & "&apptoken=123456" 
    & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?act=dr&rid=" & [Record ID#])
    & "&window.open('https://myaddress.quickbase.com/db/mydatabaseid?a=er&dfid=43')";