Share
Report
155I have an application that sits outside of CRM. It reads the data from CRM. Requirement is the user wants to click on a URL in that app, that opens CRM phone call activity form with some prepopulated values. User wants to verify and save the form.
Here are the fields :
1) Call type - Schema name : rtt_calltype, value type : option set value
2) Campaign Search – Schema name : rtt_campaignsearchid, value type : Lookup to Campaign entity
3) Regarding – Schema name : regardingobjectid, value type : lookup to contact entity (Out of the box field)
4) Call to – Schema name : TO, value type : Party list (Out of the box field).
I generated the URL but it doesn’t seem to be working. Either it autopopulate rtt_calltype, rtt_campaignsearchid (or) regardingobjectid,TO but not all. Please share your ideas if there is also other way of achieving this like javascript etc.
select substring(('https://' 'testdev.com/TDEV/CRMReports/viewer/drillopen.aspx'), 0, charindex('CRMReports',('https://' 'ctacrmdev.rjf.com/INTERMEDIARYDEV/CRMReports/viewer/drillopen.aspx')))
'main.aspx?etc=4210&pagetype=entityrecord&'
'extraqs='
'rtt_calltype=' '961640001'
'&rtt_campaignsearchid=' replace(replace(convert(varchar(40),'075DCB99-4B8E-EB11-8106-005056B968B6' /*fp.entityid*/), '{', ''), '}', '')
'&rtt_campaignsearchidname=' '2021 NextGen'
------- Code does not work below this point with the above. Can either run the top portion or the bottom portion.Cannot run both together, else the bottom portion overrides the top
'&?_CreateFromId={' replace(replace(convert(varchar(40),'37C88105-D25D-E811-80DC-005056B920D8' /*fc.contactid*/), '{', ''), '}', '')
'}&_CreateFromType=2&contactInfo=&etc=4210&pId={' replace(replace(convert(varchar(40), '37C88105-D25D-E811-80DC-005056B920D8' /*fc.contactid*/), '{', ''), '}', '')
'}&pName=&pType=2&partyaddressused=&partyid={' replace(replace(convert(varchar(40), '37C88105-D25D-E811-80DC-005056B920D8' /*fc.contactid*/), '{', ''), '}', '')
'}&partyname=' replace('Mike Hussey' /*fc.fullname*/, ', ', ', ') '&partytype=2'
All responses (
Answers (
