Forum Discussion

DanteTognoli's avatar
DanteTognoli
Qrew Captain
7 years ago

creating a button that references a record in a report link to create a new record in another app

I would like to add a button to a form that can create a new record in another app based on a report link on the form.  The report link has a list of items and information about what condition they...
Forms
reports and charts
Tables and fields
AnnSwelgin2's avatar
AnnSwelgin2
Qrew Member
7 years ago
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())