Discussions

I have been looking up how to generate the file attachment URL for a while now and the formula that continues to pop up is this one:

URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/eg/v0/" & [Image]

The problem that I have been having is that the [Record ID#] is always passing a number into the url such as:

/up/dbid/a/r12/eg/v0/image.jpg

The correct URL for the image (based on inspecting the HTML) appears to always contain a letter in that position and there is not a direct mapping to numbers as the letters are not sequential:

/up/dbid/g/rn/eg/v0/image.jpg

The value following the dbid is also different but that appears to be a separate issue atm. Any help I could get with creating this URL for the image would be helpful.

------------------------------
Jordan McCaskill
------------------------------

This syntax should work

URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e99/v0

Then replace the 99 with the field ID of the file attachment field.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Original Message:
Sent: 06-10-2021 16:08
From: Jordan McCaskill
Subject: Help with File Attachment URL

I have been looking up how to generate the file attachment URL for a while now and the formula that continues to pop up is this one:

URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/eg/v0/" & [Image]

The problem that I have been having is that the [Record ID#] is always passing a number into the url such as:

/up/dbid/a/r12/eg/v0/image.jpg

The correct URL for the image (based on inspecting the HTML) appears to always contain a letter in that position and there is not a direct mapping to numbers as the letters are not sequential:

/up/dbid/g/rn/eg/v0/image.jpg

The value following the dbid is also different but that appears to be a separate issue atm. Any help I could get with creating this URL for the image would be helpful.

------------------------------
Jordan McCaskill
------------------------------

I read that multiple times while looking it up and for some reason it didnt click that I am not getting the direct link to the image but for the field.

thanks for the help.

------------------------------
Jordan McCaskill
------------------------------

Original Message:
Sent: 06-10-2021 16:18
From: Mark Shnier (YQC)
Subject: Help with File Attachment URL

This syntax should work

URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e99/v0

Then replace the 99 with the field ID of the file attachment field.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com

Original Message:
Sent: 06-10-2021 16:08
From: Jordan McCaskill
Subject: Help with File Attachment URL

I have been looking up how to generate the file attachment URL for a while now and the formula that continues to pop up is this one:

URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/eg/v0/" & [Image]

The problem that I have been having is that the [Record ID#] is always passing a number into the url such as:

/up/dbid/a/r12/eg/v0/image.jpg

The correct URL for the image (based on inspecting the HTML) appears to always contain a letter in that position and there is not a direct mapping to numbers as the letters are not sequential:

/up/dbid/g/rn/eg/v0/image.jpg

The value following the dbid is also different but that appears to be a separate issue atm. Any help I could get with creating this URL for the image would be helpful.

------------------------------
Jordan McCaskill
------------------------------

Are you looking to display a thumbnail?

"<img src=" & URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e99/v0 width=200>"



------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Original Message:
Sent: 06-10-2021 16:26
From: Jordan McCaskill
Subject: Help with File Attachment URL

I read that multiple times while looking it up and for some reason it didnt click that I am not getting the direct link to the image but for the field.

thanks for the help.

------------------------------
Jordan McCaskill

Original Message:
Sent: 06-10-2021 16:18
From: Mark Shnier (YQC)
Subject: Help with File Attachment URL

This syntax should work

URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e99/v0

Then replace the 99 with the field ID of the file attachment field.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com

Original Message:
Sent: 06-10-2021 16:08
From: Jordan McCaskill
Subject: Help with File Attachment URL

I have been looking up how to generate the file attachment URL for a while now and the formula that continues to pop up is this one:

URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/eg/v0/" & [Image]

The problem that I have been having is that the [Record ID#] is always passing a number into the url such as:

/up/dbid/a/r12/eg/v0/image.jpg

The correct URL for the image (based on inspecting the HTML) appears to always contain a letter in that position and there is not a direct mapping to numbers as the letters are not sequential:

/up/dbid/g/rn/eg/v0/image.jpg

The value following the dbid is also different but that appears to be a separate issue atm. Any help I could get with creating this URL for the image would be helpful.

------------------------------
Jordan McCaskill
------------------------------

yeah, I have all that already. I just trimmed down my example to the part that was giving me issues.

Thanks again for the help though.

------------------------------
Jordan McCaskill
------------------------------

Original Message:
Sent: 06-10-2021 16:32
From: Mark Shnier (YQC)
Subject: Help with File Attachment URL

Are you looking to display a thumbnail?

"<img src=" & URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e99/v0 width=200>"



------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com

Original Message:
Sent: 06-10-2021 16:26
From: Jordan McCaskill
Subject: Help with File Attachment URL

I read that multiple times while looking it up and for some reason it didnt click that I am not getting the direct link to the image but for the field.

thanks for the help.

------------------------------
Jordan McCaskill

Original Message:
Sent: 06-10-2021 16:18
From: Mark Shnier (YQC)
Subject: Help with File Attachment URL

This syntax should work

URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e99/v0

Then replace the 99 with the field ID of the file attachment field.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com

Original Message:
Sent: 06-10-2021 16:08
From: Jordan McCaskill
Subject: Help with File Attachment URL

I have been looking up how to generate the file attachment URL for a while now and the formula that continues to pop up is this one:

URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/eg/v0/" & [Image]

The problem that I have been having is that the [Record ID#] is always passing a number into the url such as:

/up/dbid/a/r12/eg/v0/image.jpg

The correct URL for the image (based on inspecting the HTML) appears to always contain a letter in that position and there is not a direct mapping to numbers as the letters are not sequential:

/up/dbid/g/rn/eg/v0/image.jpg

The value following the dbid is also different but that appears to be a separate issue atm. Any help I could get with creating this URL for the image would be helpful.

------------------------------
Jordan McCaskill
------------------------------

But is it all working for you now?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Original Message:
Sent: 06-10-2021 16:36
From: Jordan McCaskill
Subject: Help with File Attachment URL

yeah, I have all that already. I just trimmed down my example to the part that was giving me issues.

Thanks again for the help though.

------------------------------
Jordan McCaskill

Original Message:
Sent: 06-10-2021 16:32
From: Mark Shnier (YQC)
Subject: Help with File Attachment URL

Are you looking to display a thumbnail?

"<img src=" & URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e99/v0 width=200>"



------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com

Original Message:
Sent: 06-10-2021 16:26
From: Jordan McCaskill
Subject: Help with File Attachment URL

I read that multiple times while looking it up and for some reason it didnt click that I am not getting the direct link to the image but for the field.

thanks for the help.

------------------------------
Jordan McCaskill

Original Message:
Sent: 06-10-2021 16:18
From: Mark Shnier (YQC)
Subject: Help with File Attachment URL

This syntax should work

URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e99/v0

Then replace the 99 with the field ID of the file attachment field.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com

Original Message:
Sent: 06-10-2021 16:08
From: Jordan McCaskill
Subject: Help with File Attachment URL

I have been looking up how to generate the file attachment URL for a while now and the formula that continues to pop up is this one:

URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/eg/v0/" & [Image]

The problem that I have been having is that the [Record ID#] is always passing a number into the url such as:

/up/dbid/a/r12/eg/v0/image.jpg

The correct URL for the image (based on inspecting the HTML) appears to always contain a letter in that position and there is not a direct mapping to numbers as the letters are not sequential:

/up/dbid/g/rn/eg/v0/image.jpg

The value following the dbid is also different but that appears to be a separate issue atm. Any help I could get with creating this URL for the image would be helpful.

------------------------------
Jordan McCaskill
------------------------------

yeah, everything is working and tested.

------------------------------
Jordan McCaskill
------------------------------

Original Message:
Sent: 06-10-2021 16:47
From: Mark Shnier (YQC)
Subject: Help with File Attachment URL

But is it all working for you now?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com

Original Message:
Sent: 06-10-2021 16:36
From: Jordan McCaskill
Subject: Help with File Attachment URL

yeah, I have all that already. I just trimmed down my example to the part that was giving me issues.

Thanks again for the help though.

------------------------------
Jordan McCaskill

Original Message:
Sent: 06-10-2021 16:32
From: Mark Shnier (YQC)
Subject: Help with File Attachment URL

Are you looking to display a thumbnail?

"<img src=" & URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e99/v0 width=200>"



------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com

Original Message:
Sent: 06-10-2021 16:26
From: Jordan McCaskill
Subject: Help with File Attachment URL

I read that multiple times while looking it up and for some reason it didnt click that I am not getting the direct link to the image but for the field.

thanks for the help.

------------------------------
Jordan McCaskill

Original Message:
Sent: 06-10-2021 16:18
From: Mark Shnier (YQC)
Subject: Help with File Attachment URL

This syntax should work

URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e99/v0

Then replace the 99 with the field ID of the file attachment field.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com

Original Message:
Sent: 06-10-2021 16:08
From: Jordan McCaskill
Subject: Help with File Attachment URL

I have been looking up how to generate the file attachment URL for a while now and the formula that continues to pop up is this one:

URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/eg/v0/" & [Image]

The problem that I have been having is that the [Record ID#] is always passing a number into the url such as:

/up/dbid/a/r12/eg/v0/image.jpg

The correct URL for the image (based on inspecting the HTML) appears to always contain a letter in that position and there is not a direct mapping to numbers as the letters are not sequential:

/up/dbid/g/rn/eg/v0/image.jpg

The value following the dbid is also different but that appears to be a separate issue atm. Any help I could get with creating this URL for the image would be helpful.

------------------------------
Jordan McCaskill
------------------------------