[solved] the above solution did not work for me. The url is expecting a letter, not a number. Here is an example of the correct url.
https://aaa.quickbase.com/up/bq8b53jdm/g/rs/ede/va/Estimate-xxxxxxxxxx.pdfI added a few more records until I ran out of alphabet letters and then I got the following link
https://dti.quickbase.com/up/bq8b53jdm/g/r3/ede/va/Estimate-xysyssyysys.pdf but the record id for that is 25, so the record id does not fit in this space.
eg if I use the record id on a different file, then the url produced is
https://aaa.quickbase.com/up/bq8b53jdm/g/r12/ede/va/Estimate-xxxxxxxxxx.pdf
which gives me a 404 not found page.
I found another post about this here...
[other post about attachment urls]It mentioned the encoded record id field, and in the end that is what solved my problem.
In my formula text field I did something like the following.
=============
var text textId = QB32Encode([Record ID#]);
"https://xxx.quickbase.com/up/bq8b53jdm/g/r" & $textId & "/ede/va/" & [Saved Estimate Letters]
also note that I could not use the qb32encode inline
i.e. the following did not work
"https://xxx.quickbase.com/up/bq8b53jdm/g/r" & QB32Encode([Record ID#]) & "/ede/va/" & [Saved Estimate Letters]
------------------------------
Johnnyny
------------------------------