Formula Rich Text Button - File to Add Record
Hi, I'm using a formula rich text button to add record in a different table when click. The button includes the action of copying multiple field values into the newly added record. I have one fiel...
Forum Discussion
Thank You, Mark!
To give you a bit more context, these files are always unique - almost always a screenshot or pdf of an email with an outside person confirming the current property/broker commission rate.
That being said, if there's a way to populate the link for the file and push that link to the new file that would work! Am I dreaming there?
The trouble is these two records (separate tables) are not related in any way currently. It's meant to be an electronic carbon copy if you will.
Anything come to mind?
------------------------------
Chris
------------------------------
To give you a bit more context, these files are always unique - almost always a screenshot or pdf of an email with an outside person confirming the current property/broker commission rate.
That being said, if there's a way to populate the link for the file and push that link to the new file that would work! Am I dreaming there?
The trouble is these two records (separate tables) are not related in any way currently. It's meant to be an electronic carbon copy if you will.
Anything come to mind?
------------------------------
Chris
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendWell it seems to me that the record you are launching off of has the file attachment so you can easily build a link to the very record that you launched off of and the field that has the file attachment in it.
If you want to file attachment to appear exactly as it does on the original record then let me know and I can help you if you need it with the format for a hyperlink field which would have the file name for the user to click on as opposed to a "click here" type button
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- Having the file attachment appear exactly as it does on the original record sounds perfect!
So does that mean this would be a local formula field that displays the associated link and then that field would be copied into the new record?
If that's accurate and you can give me the basic formula breakdown, I'd really appreciate it! I've been thinking through this one for too long with no success.
------------------------------
Chris
------------------------------- MarkShnier__YouOK, so you want a hyperlink to open a file. Create a Rich Text formula field on the Source record
var text Words = ToText([File Attachment field]);
// replace the 99 below with the field of the field holding the file attachment.
var text URL =URLRoot() & "up/" & dbid() & "/a/r" & [Record ID#] & "/e99/v0";
// this last part is always the same
"<a href=" & $URL & ">" & $Words & "</a>"
If the nature of the documents are that they will open up in the browser, you probably want to force a new tab, so replace the last line with this
<a target='_blank' & $URL & ">" & $Words & "</a>"
Then copy the value of the formula field to the target record into a Rich Text field type.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Thank You, Mark!
I ran into an issue in the formula so I switched it around to this:
var text Words = ToText([Deal Terms Documentation]);
var text URL =URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e268/v0";
"<a href=" & $URL & " target=_blank>" & $Words & "</a>"
The issue I'm running into now is when running the Rich Text Formula button to copy I'm getting an issue during the copy. Do I need to format the field in the copy formula?
& "&_fid_300=" & [Deal Terms Documentation Link]
This XML file does not appear to have any style information associated with it. The document tree is shown below.<qdbapi><action>API_AddRecord</action><errcode>0</errcode><errtext>No error</errtext><rid>49</rid><update_id>1593573745472</update_id></qdbapi>
I did also find another one of your posts on doing similar using Formula URL to URL field, but I figured I'd check if there's a way to make the Rich Text option work because it displays better with the file name.
Thank You!
Chris
------------------------------
Chris
------------------------------