Forum Discussion
QuickBaseCoachD
8 years agoQrew Captain
If you have a std document in your same app, perhaps in a table called Standard Documents, you can make a link to that document on records in another table.
The field type would be formula URL and the formula would be
URLRoot() & "up/" & [_DBID_DOCUMENTS] & "/a/r10" & "/e11/v0"
In the example above, the reference to the table name comes off the Advanced Properties of the the table with the Std Documents.
The e11 means that the field on that table which is holding the std document is Field ID# 11. You would need to change that 11 to your own field ID.
The r10 means that the record ID# of the record with the Std Document is Record ID# 10. You would need to change that too.
The field type would be formula URL and the formula would be
URLRoot() & "up/" & [_DBID_DOCUMENTS] & "/a/r10" & "/e11/v0"
In the example above, the reference to the table name comes off the Advanced Properties of the the table with the Std Documents.
The e11 means that the field on that table which is holding the std document is Field ID# 11. You would need to change that 11 to your own field ID.
The r10 means that the record ID# of the record with the Std Document is Record ID# 10. You would need to change that too.