krileon & CB team,

Really appreciate your reply! You inspired me to keep trying and after a few hours I found the problem is that a field with null value won’t concat in your code (works fine in phpmyadmin and other uses)... so I have a work around for us where we first clear the null value. The following example is for type Activation as we have added in all our plans (replace Annual Membership for each plan) and we have one for each action (replace ACTIVATED with RENEWED, EXPIRED, or DEACTIVATED for each type):

!! This Works:
UPDATE `jos_comprofiler` SET `cb_adminnotes` = '---' WHERE `id` = [user_id] AND `cb_adminnotes` IS NULL LIMIT 1;
UPDATE `jos_comprofiler` SET `cb_adminnotes` = CONCAT(' ACTIVATED Annual Membership<br /><br />',`cb_adminnotes`) WHERE `id` = [user_id] LIMIT 1;

This script allows us to track all changes to CB subscriptions in each user's profile by simply adding a time stamp and description of each action to the beginning of our cb_adminnotes field ‘Admin Notes’ which we have under a tab we created called ‘Admin Only’ which only our administrators can access.

Feature request for CB Fields:
The CB Team could make this easier for us by simply adding a few lines of code to your CB Fields CBsubs plugin so it has the option to CONCAT at either the beginning or end of the field (it currently only let us replace what is there already).

Did you notice I have the SQL action working? I edited my note to add !! This Works

Happy to hear changes made to subscriptions in back-end will be fixed, but this not my issue here.

Also, my feature request for CB fields would not complicate the plug in, it would make it better and more functional - instead of replacing what is there it lets you add to what is there already.

I guess you are busy - thanks anyways.

What are the values we can use in our SQL Actions? Can we get the code to show the amount donated? Would [amount] work?

The instructions state:

CB user fields can be substituted (e.g. [user_id] or '[username]'). IMPORTANT: always quote text strings (all user data is SQL-escaped). You can also use: [plan_id], [subscription_id], and where applicable (replaced by a 0 if not available): [replaced_plan_id], [parent_plan_id], [parent_subscription_id]