Forum Discussion
- AmmarAl-HadeethQrew MemberIs the [ID] a formula too? Or is it a related field? What kind of field is it?
Regards - QuickBaseCoachDQrew CaptainIf you are trying to link to a record, the syntax is
URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & ToText([ID])- ArchiveUserQrew Captainlink 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.
- AmmarAl-HadeethQrew MemberThe link is missing "&rid=[Record ID#]"
if this is being sent through notification, you would need to encode it!
Regards - ArchiveUserQrew Captainat the end?
- ArchiveUserQrew Captainwhat am i doing wrong here?
- ArchiveUserQrew CaptainThe 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.
- QuickBaseCoachDQrew CaptainWhat�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.
- ArchiveUserQrew CaptainInside 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] - AmmarAl-HadeethQrew MemberWhat is the code of [Link to record]?
- ArchiveUserQrew CaptainURLRoot() & "db/" & Dbid() & "?a=dr&rid=" & ToText([ID])