Pre-populating in Ustore based on a database

[tif...@colormarkprinting.com]

In Ustore, I need to create a drop down menu of locations and when a
user selects a location, then it automatically pre-populates Address
1, 2,3, city, state, zip into the input fields. The fields need to
remain editable just in case the user needs to adjust the address.

I tried the Use Data source for personalized values, but it will only
return one field value, is there any way to return multiple field
values in ustore? I was told that they currently don't offer the
return of multiple fields. Does anyone know of another way to do this?

Thanks for your help.

[Alan Dixon]

If you create a contional rule in the plan file that uses the variable (as a campaign dial) for location selection, then in ustore set the values for the drop down list to match the "if else" rule.
Then when the user selects the location of choice it will use this value to execute all lines of the address, giving the result of "pre populated".
We have done this many times before.

Regards Alan

Technical Director - Positive Focus
Sent from my BlackBerry® wireless device

[Louis]

I had a similar situation, for a business card ordering store -
where the user selects his "Department" or "Branch" on step one, and
then the artwork on step 2 draws the address telephone and email
details from the database using his selection as criteria, letting him
only modify his name and cell number.
Step one has a text ador that is set up as a drop down list advanced.
this control's value is what will determine the non-editable info on
the second step.
Step two has the full set of adors, with only name and surname and
cell number (as mentioned above) being editable to the user. the
other adors' values are populated using a custom query like this:
SELECT [Street] as [Value],
0 as [IsDefault]
FROM
[businesscards] JOIN
[ustore].[dbo].[OrderProductDialValue]
ON [ustore].[dbo].[OrderProductDialValue].DialValue =
CONVERT(nvarchar, [businesscards].StoreID)
JOIN [ustore].[dbo].Dial
ON [ustore].[dbo].OrderProductDialValue.DialId = [ustore].
[dbo].Dial.DialId
WHERE
[ustore].[dbo].[Dial].UProduceDialName = 'StoreName' AND
[ustore].[dbo].[OrderProductDialValue].OrderProductID =
@OrderProductId

obviously this code is slightly different for each of the adors, but
the crux of it is what you see above.
code is the product of a long webex session, courtesy of viktor of
xmpie,
feel free to check out the result - it's at http://www.jetline.co.za/pod
- the products are for inhouse use only and useless to anyone outside
of Jetline in any event...

hope all of this helps?

On Oct 14, 5:59 pm, "tiff...@colormarkprinting.com"