Yes they are
Can you please show me an example of this? Thanks so much!
On your inspection report - go into the settings for the add button that you're clicking.
The format should be something like:
URLRoot() & "db/" & [_DBID_ATTACHMENTS] & "?a=API_GenAddRecordForm" &
"&_fid_A=" & [Record ID#]
In this case - fid_A should have a # instead of A. That fid is the 'related inspection report' on the attachment. So you need to add another similar to that to pass in your related light tower like:
URLRoot() & "db/" & [_DBID_ATTACHMENTS] & "?a=API_GenAddRecordForm" &
"&_fid_A=" & [Record ID#] &
"&_fid_B=" & [Related Light Tower]
Where you need swap the value of B with the field ID of the related light tower field in the Attachments table.
This all makes total sense, however. I did not change anything (using default add attachment button) from the inspection report table, and now it doesnt fill in the related inspection report when I am adding an attachment from an already created inspection report. Here is the add attachment button formula:
URLRoot() & "db/" & [_DBID_LIGHT_TOWER_ATTACHMENTS] & "?a=API_GenAddRecordForm&_fid_60=" & URLEncode ([Record ID#])& "z=" & Rurl()
Field 60 is the related "service" report, we renamed this table, sorry a bit confusing. But when i use this button, field 60 has nothing in it and the proxy field shows nothing.
This is my current formula, after trying to add the second part to bring in the related light tower and its not bringing the light tower but somehow now showing the related service report!
URLRoot() & "db/" & [_DBID_LIGHT_TOWER_ATTACHMENTS] & "?a=API_GenAddRecordForm&_fid_60=" & URLEncode ([Record ID#]) & "&_fid_8=" & URLEncode ([Related Light Tower]) & "z=" & Rurl()
Looks just like a missing & before the z= Rurl() piece. So:
URLRoot() & "db/" & [_DBID_LIGHT_TOWER_ATTACHMENTS] & "?a=API_GenAddRecordForm&_fid_60=" & URLEncode ([Record ID#]) & "&_fid_8=" & URLEncode ([Related Light Tower]) & "&z=" & Rurl()
