Forum Discussion
AnnSwelgin2
7 years agoQrew Member
i may need more information about this but my simple answer is to create a formula URL field in the table where you report link is coming from. Check the box that says show as a button and paste in the URL to "Add Discrepancy Report". You should be able to tell it when to show the button when you write the formula...
Example: In the code below I have a button that toggles on and off when a summary field from my relation is equal to 0 and our turnover date is blank (null).
If([# of records in Planning]=0 and IsNull([Actual Turned Over Date]),URLRoot() & "db/" & [_DBID_PLANNING] & "?a=API_GenAddRecordForm&_fid_16=" & URLEncode ([Record ID#])& "&z=" & Rurl())
Example: In the code below I have a button that toggles on and off when a summary field from my relation is equal to 0 and our turnover date is blank (null).
If([# of records in Planning]=0 and IsNull([Actual Turned Over Date]),URLRoot() & "db/" & [_DBID_PLANNING] & "?a=API_GenAddRecordForm&_fid_16=" & URLEncode ([Record ID#])& "&z=" & Rurl())