Discussions

Expand all | Collapse all

Hyperlink summary field into a button?

  • 1.  Hyperlink summary field into a button?

    Posted 08-28-2017 20:32
    Please help!! What's the easiest way to change a hyperlink summary field into a button? is this even possible?

    ">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1642050/RackMultipart20170828-94232-1jjym83-image_inline.png?1503952307">
    Thank you!


  • 2.  RE: Hyperlink summary field into a button?

    Posted 08-28-2017 20:56
    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])


  • 3.  RE: Hyperlink summary field into a button?

    Posted 08-28-2017 21:22
    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!


  • 4.  RE: Hyperlink summary field into a button?

    Posted 08-28-2017 23:24
    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???


  • 5.  RE: Hyperlink summary field into a button?

    Posted 08-28-2017 22:20
    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)


  • 6.  RE: Hyperlink summary field into a button?

    Posted 08-28-2017 23:48
    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?


  • 7.  RE: Hyperlink summary field into a button?

    Posted 08-29-2017 00:08
    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


  • 8.  RE: Hyperlink summary field into a button?

    Posted 08-29-2017 01:00
    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)



  • 9.  RE: Hyperlink summary field into a button?

    Posted 08-29-2017 02:18
    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!!


  • 10.  RE: Hyperlink summary field into a button?

    Posted 08-29-2017 05:26
    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. :)


  • 11.  RE: Hyperlink summary field into a button?

    Posted 08-29-2017 07:18
    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?