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

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())

Thanks for the reply! I will take a look at that as soon as I get a chance.

I have a button just like that already. The problem I have is that when I change a record via grid edit on a report in another app, I want the button to appear on the form in that other app and I'm not sure how to make that happen.

I would like to help but I'm not understanding your question ...

I tried including the field that the button is in on the report, but that doesn't work...

In the form below I would like a button next to the report to appear when I change the status from "satisfactory" to "unsatisfactory" that allows me to create a new record in the app the report originates from. I have that button working in the other app, but have no idea how to create the same thing here.

You would need to hard code the table code if the table is in a different app.

Can you post the code for the button that is working in the other app , and also let me know the code for the table - all that string of numbers you see in the URL and we can adjust that to work here.

the button:

URLRoot() & "db/" &[_DBID_DISCREPANCIES]& "?a=API_GenAddRecordForm&_fid_7=" & URLEncode([Serial Number])

table code:

bn539nsxk?a=er&rid=13&rl=sdy

and a picture of the table it is on just in case

try this

URLRoot() & "db/" & "bn539nsxk" & "?a=API_GenAddRecordForm&_fid_7=" & URLEncode([Serial Number])

But I do not know if you have a comparable field for [Serial Number] in the table where you are putting the button.

If you only want to show the button for certain statuses (ie Unstatisfactory), you can use a form rule

There is not a comparable field for [serial number] on the table. The button on the NVG status log will only ever reference one serial number, while on the Flight Rest and Duty log there will always be multiple serial numbers. If I could put the button in the report, that might work but I haven't been successful trying to do so.