The advanced pdf appending another pdf can be done via link, but I don't know if you can get that link from a field on the record, also the file has to be made available without login I believe