[dnajd]

Hi Friends,

I'm trying to link from a Membership profile in RE to a internal web based system. Here is the affect I would like to create....

1. Data entry person is looking at CRecord in RE interface.
2. Clicks something (maybe a vba macro) and it opens a web browser; passing the consitituent id of the record being viewed onto the end of the url (query string).
3. The web application uses that consitituent id to look up info in a separate system.

So VBA macro would have worked perfectly except blackbaud insists on charging us $1,500. Given that what I'm trying to do is simple I would be hard pressed to get $1500. Does anyone have a suggestion on how I can go about this.

Worse comes to worse I'm going to create a little desktop app where the data entry person can click, enter the Constituent id and it will launch the browser and load the data. But I'd rather have this integrated with the RE interface.

Thanks,

Don

[DavidZ]

I didn't quite catch whether or not your organization owns the VBA module or not. Is the charge Blackbaud are proposing to do the work or is it for the VBA module (sounds very cheap for the VBA module itself). If it is for the code and you already have the VBA module then check out my blog posting here for the code and just paste it into the VBA environment's System_Macros file

RE-Decoded » Blog Archive » Opening a link from a Constituent

David

[dnajd]

Hi David,

Unfortunately we don't have the VBA module and I can't get the money at this time to puchase it. Do you know if there is there any other way to accomplish this?

[JeffMon]

You could do it as a plugin:

http://labs.blackbaud.com/NetCommunity/Page.aspx?pid=205

It won't open up with a button click from the user's record, but you could probably do it with three clicks and a copy-n-past: copy constit id, click plugins folder, activate plugin, paste constit ID, click "go". Actually you could make that two clicks if you catch the change event on the plugin's constit ID field. ;-)