Discussions

Expand all | Collapse all

Link to the current report

  • 1.  Link to the current report

    Posted 02-28-2018 22:19
    I have this formula to create a link to the report.

    URLRoot() & "db/" & Dbid() & URLEncode("?a=dr&rid=") & ToText([ID])

    It works sometimes and sometimes it is blank



  • 2.  RE: Link to the current report

    Posted 02-28-2018 22:24
    Is the [ID] a formula too? Or is it a related field? What kind of field is it?

    Regards


  • 3.  RE: Link to the current report

    Posted 02-28-2018 22:27
    If you are trying to link to a record, the syntax is

    URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & ToText([ID])


  • 4.  RE: Link to the current report

    Posted 03-01-2018 14:05
    link to record looks like this


    But then the email looks like this;

    To whom it may concern:

     

    Please Note a Supplier Corrective Action Report (SCAR) CAR-1255 has been assigned to you.

     

    Finding/ Issue: During customer audit (Sunflower Electric Power) on 11/16/17, customer was inspecting poles in the yard and saw where an improper coating repair had been made.  Action Item 3:       Implement process improvement to prevent coating damage from forklift transportation of pole sectionsAction Item 4 (a):  Repair improper coating repairs.Action Item 4 (b):  Implement process improvement for prevention of improper coating repairs.

     

    To complete the Corrective Action click on this Link: https://trinityindustriesinc.quickbase.com/db/bmpb6z9v9?a=dr


  • 5.  RE: Link to the current report

    Posted 03-01-2018 14:15
    The link is missing "&rid=[Record ID#]"

    if this is being sent through notification, you would need to encode it!

    Regards 


  • 6.  RE: Link to the current report

    Posted 03-01-2018 15:40
    at the end?


  • 7.  RE: Link to the current report

    Posted 03-01-2018 15:47
    Yes,
    This is what is the [Link to record] code:
    URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & ToText([ID])

    Your link is :
    https://trinityindustriesinc.quickbase.com/db/bmpb6z9v9?a=dr">https://trinityindustriesinc.quickbase.com/db/bmpb6z9v9?a=dr">https://trinityindustriesinc.quickbase.com/db/bmpb6z9v9?a=dr


    Which is missing the bold part


  • 8.  RE: Link to the current report

    Posted 03-01-2018 17:08
    Doesn't work.  Solution was what I originally had.  It had a small glitch


    URLRoot() & "db/" & Dbid() & URLEncode("?a=dr&rid=") & ToText([ID])


  • 9.  RE: Link to the current report

    Posted 03-01-2018 13:40
    what am i doing wrong here?



  • 10.  RE: Link to the current report

    Posted 03-01-2018 14:01
    The link is correct but when i put it in the body:
    "Please Note a Supplier Corrective Action Report (SCAR) " &[CAR ID] & " has been assigned to you."&
    "%0D%0A" &
    "%0D%0A" &
    "Finding/ Issue: " &[Finding / Issue                                                                                                                           _] & 
    "%0D%0A" &
    "%0D%0A" &
    "To complete the Corrective Action click on this Link: " &
    [Link to record] &
    "%0D%0A" &
    "%0D%0A" &
    "If you have any questions please reply to this email."&
    "%0D%0A" &
    "%0D%0A" &
    "Thank you!"


    That then gets put into the email to the supplier:
    "mailto:"&""&[Supplier E-Mail Address]
    &"\n"&"?Subject="&"\n"&[Subject]
    &""&"&body="&"\n"&[Body]

    Something goes wrong.


  • 11.  RE: Link to the current report

    Posted 03-01-2018 13:49
    What�s is the code that was clicked that gave that message. It is saying that you are asking to rerun a report which does not exists.


  • 12.  RE: Link to the current report

    Posted 03-01-2018 14:17
    Inside field [Body]:
    "To complete the Corrective Action click on this Link: " &
    [Link to record] &
    "%0D%0A" &
    "%0D%0A" &


    This is the email:
    That then gets put into the email to the supplier:
    "mailto:"&""&[Supplier E-Mail Address]
    &"\n"&"?Subject="&"\n"&[Subject]
    &""&"&body="&"\n"&[Body]


  • 13.  RE: Link to the current report

    Posted 03-01-2018 14:20
    What is the code of [Link to record]?


  • 14.  RE: Link to the current report

    Posted 03-01-2018 15:40
    URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & ToText([ID])