Profile Workflows - have to update same drop down 4 times. Another way?
By Jason Wells on Tuesday, 17 April 2018
Posted in Technical Issues
Likes 0
Views 562
Votes 0
I have 2 profiles types in Easy Social (Basic & Premium member)
I created 2 workflows (Basic & Premium) as they have different access control lists
A member gets Basic by default and pays a subscription to get Premium ACL
The workflows are identical as are the fields and values inside each

I have a drop down list in Basic and Premium workflows called "Current Industry" which has a standard list of industries. It is the same values for Basic and Premium.

I also created the list in a section called "Capabilities & Experience", it is in both workflows and has the same values.

So there are 4 instances of the same list of values.

This seems v inefficient as every time I update it I have to do 4 times. I would think you create somewhere once and use in both member types.

There is no bulk upload values option so I have to update the 4 lists 1 by 1 value.

How I can make this more efficient? e.g. Update the dropdown list once and then use in multiple places or bulk upload a list 4 times.
I think you can try insert data via SQL query, you can refer on my attached screenshot below.

The important part is, you need to find that custom field id after you save into your workflow, so you can add the SQL insert statement specific for this custom field id.

Note : Remember do the full backup before you execute any SQL query on your database.

And you can create one of the workflow and try this, so that it will not messed up your existing workflow data, once you know how to add this through SQL, then you only start to try in your existing workflow.
Arlex Wong
·
Wednesday, 18 April 2018 16:36
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Jason,

Unfortunately currently that is no other way around to add this easier at this point of time.
Arlex Wong
·
Wednesday, 18 April 2018 00:07
·
0 Likes
·
0 Votes
·
0 Comments
·


For thanks for the reply:D

Is there anyway to access the list in the db/php files? and replace this particular list there?
Jason Wells
·
Wednesday, 18 April 2018 10:15
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks a lot. Will think about it!
Jason Wells
·
Wednesday, 18 April 2018 16:51
·
0 Likes
·
0 Votes
·
0 Comments
·
You're welcome.

Just for your information, I have locked and marked this thread as resolved to avoid confusions in the future. Please start a new thread if you have any other issue in the future so it will be easier for us to manage your inquiries.

Thanks for understanding
Arlex Wong
·
Wednesday, 18 April 2018 18:23
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post