Using Quick Base Action to copy file attachment

Appreciate your response to this last month, it worked brilliantly! However, I'm running to a different issue concerning the button links I have created to these URLs.

I have 7 record attachments that "copy over" in this way from one table to another (the links appear as buttons on the new record).

However, not all of these attachment fields will actually have an attachment (usually only 2-3 attachments were actually uploaded). Quickbase is somehow copying URLs for attachments that do not exist and showing the buttons on the new record - how do I prevent this? When you click the link button, it takes you to a page that says the attachment doesn't exist. How can I tell it to not copy this field if it is blank?

I suggest that you make a field which is the ToText value of the file name.

Then set a Condition for the Action to fire only when that is not blank.

Could also handle this a step before that and just embed the current button code within an IF() function that tests whether or not an attachment exists for that button, and if it doesn't, hide the button so it can't be clicked.

I'm not sure what you mean the "make a field which is the ToText value of the file name."

Would you mind elaborating?

Right now I have a Formula-URL field which copies the URL of each file attachment. So would I need an additional 7 fields to do what you are talking about or is this something that I would be editing in the current Formula-URL fields?

In your formula text field for each button:

If( Length(ToText([File Attachment Field])) = 0, null, <your current button code> )

This will test the attachment to see if it exists, and if it doesn't, the button will not show and therefore cannot be clicked.

So you are saying I need to create a formula text field that corresponds to each formula URL button?

Or that I am replacing the formula that is currently there with the one above?

Replacing the current formulas by wrapping them within the IF function. That will let you control whether or not it is appropriate for the buttons to display at all, based on your criteria that not all attachments necessarily exist.

Now I'm getting this:

Please check the syntax of your entire formula. Possible culprits are a mismatched set of parentheses, missing quotes, or an extra bracket.


If( Length(ToText([Bid Analysis])) = 0, null,   <URLRoot() & "up/" & Dbid() & "/a/r" & [Req ID#] & "/e81/v0"> )


I put my current formula exactly as it is, but it is appearing in Italic in the error message so I assuming it is trying to tell me that is where the error is?

Sorry. Get rid of the beginning < and the ending > that I put in there. They were merely meant as placeholders to frame the text I entered between them.

Got it working! Sorry you had to spell it out for me so much.

I swear, the longer I try to get something to work the dumber I seem to become.

Thanks so much for your help.