Welcome to he Community. We are very friendly here.
so np,
Try this
URLRoot() & "db/" & [_DBID_DOCUMENT_LIBRARY] & "?a=API_GenAddRecordForm"
& "&_fid_58=" & URLEncode ([Task ID])
& "&_fid_37=" & [Related Project]
& "&z=" & Rurl()
The first line say to go to your Realm (like mycompany.quickbase.com" and then to a particular Table and call the API which will put up a data entry form, to add a record.
The next line says to stuff the Task ID, which is key field of your Tasks table into field id 58. That would be the field in Documents for [Related Task]
The next line which is the new line you will add says that assuming that in the documents table the field for [Related Project] is field ID 37, we stuff the value of [Related Project] of the Task also into the [Related Project] field in documents.
The last line says to land the user back where they started on the Task Record after saving the document.
Note that I broke up your code into 4 lines for better readability. The & at the start of each line is just for concatenation. The
&s inside the quotes tells Quick Base that a parameter is about to follow. So same character
& but completely different meaning if it is outside the quotes (concatenation) or inside the quotes.
There is an app I put in the Exchange called URL Formulas For Dummies which explains some of the basic syntax of these URL formula buttons.
see you around .......
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------
