Recipient Lists and SQL Server

[Blake Norwood]

I'm trying to streamline one of our sites' business cards. Currently, we have 2 versions of business cards. The first version is a single card that allows a user to select their office location from a dropdown and populates the address information from a SQL Server database.

The second version of the card uses a recipient list and a looooong if/ else sequence to populate the address. Is it possible to pull the address from the same SQL Server database that the single card uses and populate the recipient list so that we no longer have to update the address in multiple places?

[couch]

Sure. For example, in uPlan, the primary table or recipient schema is linked to your recipient list (eg the sample recipient list that the customer would upload).

You can then connect another secondary database to the plan. I would use that to create a userview so you can capture all the other fields for the address in one query.

Of course, it relies on the customer uploading a list where the key that is used in the query is good. I mean that they are not going to mistype the office ID or branch location that is used to query the address details.