0

I want to display an ordered list of items taken from a Data Extension via a Landing Page. Then allow the user to re-order the items via jquery and save the new order back into the Data Extension.

I have the jquery piece working to allow the re-order but I am struggling to get the updated order back into the DE.

Does anyone have an example or solution for this?

2
  • Why does it need to be sorted in the Data Extension? Nov 21 '16 at 14:48
  • The context is a preference centre, so I want to keep a record of the user preferences in order of importance. If their preferences change, I want to store that change. It doesn't need to be sorted in the DE, but I need the order stored so that I can display it sorted correctly.
    – Paul Moody
    Nov 21 '16 at 15:31
0

You should be able to include an index or ordinal position for each row -- similar to this Data Tables example:

data tables index example

You can just store the ordinal position in the Data Extension and retrieve it in order using the LookupOrderRows() function (or the SSJS Lookup() function) in your page.

1
  • Thanks Adam, my issue is how I get the new order from the client side jquery result into the Data Extension. Once it's in the DE I am fine.
    – Paul Moody
    Nov 22 '16 at 15:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.