updating sort order on campaign member status

quick note re updating sort order on campaign member status

you cant do this via the UI, you have to do a data load

and sort order is unique, you cant set a member status to have a sort order of 2 if another one already is 2.

so lets say you have 10 member statuses, with sort order 1-10.

if you want to update them, query via workbench

select id,label,sortOrder from campaignMemberStatus where campaignId = ‘insert ID of your campaign here’

then to update the sort order, you need to set the new ones starting with 20, so you have 20-30

then the update will work

else you will get an error

 
0
Kudos
 
0
Kudos

Now read this

Evaluating max/min of multiple date fields in flow

UPDATE : JUNE 2023 Summer22 brought us new formula functions. UNIXTIMESTAMP allows you to convert dates to numbers, which can be fed into MAX or MIN, which will return a single value which you can convert back to dates using FROMUNIXTIME... Continue →