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

  • 0
  • 1
  • Question
  • Updated 4 days ago
  • In Progress
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 are in. If the items are not in satisfactory condition, the user makes a grid edit to the report and selects that, then saves and continues. What I would like to do is have a button appear when that happens that will create a new record in the app where the item information is kept so that they can fill out a discrepancy report for the item.
Photo of Dante Tognoli

Dante Tognoli

  • 514 Points 500 badge 2x thumb

Posted 4 months ago

  • 0
  • 1
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())