Hyperlink summary field into a button?

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
Please help!! What's the easiest way to change a hyperlink summary field into a button? is this even possible?


Thank you!
Photo of Evan Fujikawa

Evan Fujikawa

  • 390 Points 250 badge 2x thumb
  • Frustrated!

Posted 1 year ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
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])
Photo of Evan Fujikawa

Evan Fujikawa

  • 390 Points 250 badge 2x thumb
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!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,126 Points 50k badge 2x thumb
Evan,
Sorry but I have been unable to log onto the Forum all day today and most of my devices. Based on what I know about your app from your other questions, it does not look to me like you are referencing the correct record ID.

That formula will display a record. It seems unlikely to me that the record I do that you want to display on the root cause record is that the formula is using. Is that really your Summary field with a name like that???
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
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)
Photo of Evan Fujikawa

Evan Fujikawa

  • 390 Points 250 badge 2x thumb
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?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
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
Photo of Evan Fujikawa

Evan Fujikawa

  • 390 Points 250 badge 2x thumb
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)

Photo of Evan Fujikawa

Evan Fujikawa

  • 390 Points 250 badge 2x thumb
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!!
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
Change the "a=dr&" to be "a=er&"

display record vs edit record.

Glad you could get it sorted out.  Usually its just some setting or tinkering to get what you need.  Now you are an expert and can help others. :)
Photo of Evan Fujikawa

Evan Fujikawa

  • 390 Points 250 badge 2x thumb
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?