Hyperlink summary field into a button?

I don't think you can change that field to be a button, because it is a reference field, and the 'link' functionality is just built into QB.

You will want to make a formula-url button that has the same atributes as the link.
i.e. ?a=dr&rid="&URLEncode([Related Root Cause])

I tried creating a formula url button to link to the child record, but it's not referencing the correct record.

"Root Cause" is the child table that has the record I want access to and "Root Cause Related Damage Parts Incidents2" is the summarized field. Is this formula set up incorrectly?

URLRoot() & "db/" & [_DBID_ROOT_CAUSE] & "?a=dr&dfid=XX&rid=" & [Root Cause Related Damage Parts Incidents2]

Thanks!

It looks correct.  Does it work for you?

The record id value just needs to be the record ID of the parent.  So if in your case the parent record ID# is [Root Cause Related Damage Parts Incidents2] then you should be good.

(looks like your app has had a far amount of tinkering going on)

I need the button to pull the Record ID of the child record since the button is located in the parent form. I'm not very familiar with quickbase and it seems like what I need should be fairly simple, but it's starting to sound quite complex.

I have a table (Damage Parts) that houses the button that links to it's child form (Root Cause). This is embedded in the parent form (Damage) which is the only table the user will have access to. So essentially I need the button to allow the user to create a record as well as edit only accessing the from through the button. Is this even possible?

I understand exactly what you are trying to do. But I'm saying that if you have a Summary field which a Summary of the minimum record ID# of the child Record, it is highly unlikely it has that field name you are using in your formula.

What is the field name on that Damage Parts record that has the summary of the Minimum Record iD# of the Root Cause Record.

If you are really stuck, contact me via the information on my website and I will have a quick look.
QuickBaseCoach.com

The hyperlink that shows in my "Edit Root Cause" field does exactly what I need the button to do. I just need that hyperlink in the form of a button. In my edit button I am referencing the same field as my summary but it will only link to the Parent Table (Damage Parts) and not the child table (Root Cause)

I adjusted the table and field to pull the correct record and it's finally functioning like it should!! Is there something I can add to the formula that will open the record in edit mode?

URLRoot() & "db/" & [_DBID_ROOT_CAUSE] & "?a=dr&dfid=XX&rid=" & [Root Cause Record ID#]

Thank you!!

Perfect!! Thanks Matt, but I'm far from an expert. To take this formula a step further, how would I tell it to return to the Parent Table and Record after it's saved?