How to assign value to CB Text Field in Auto Action Type Code after JSON decode?

Hello,
for demo purposes we've temporarily set 3 fields as type "Code".
Goal is to fetch JSON (single array) via API call, decode and trim it to CB field values. This demos screenshot 1 (for CB field ..._title) and 2 (frontend view).
This works properly. Return displays values correctly.
Field type of these 3 fields is "Text" when in normal operation, not code

However, this fetch and decoding operation is required only when an specific ID field gets updated by user.
In addition values fetched from JSON have to be saved to user profile to be become searchable.

We think an Auto Action is appropiate here (screenshot 3):
TRIGGER: onAfterUpdate
CONDITION: ID field not empty
ACTION: Method=PHP
OUTPUT: None (at least no display required here)

Screenshot 3 has an DB query that did not at all. Fields remain blank.

Now, how can we just simply assign a value to a CB field, like:
[cb_youtube_video_title]=$result;
which would save value to #_comprofiler table.

Please assist.

Thank you in advance.
Regards. Michael.

Code actions have direct access to the $user object. You can set a field and store it using the below.


This does not fire profile update triggers so it won't get stuck in a loop by doing this. If you're changing another action after this action be sure to enable reload user under Parameters in the action after this one so it sees your user object update.

Thank you Kyle for your quick response.

I've updated the code, and ... nothing has been written/updated to DB. Fields remain empty as you're saying: "This does not fire profile update triggers"
So how we get the DB CB fields updated then? I'm afraid I've not got the point here. reload user set to yes.

Thank you,
Regards, Michael.

PS: Code in Code Field works properly, DB got updated.

I've updated the code, and ... nothing has been written/updated to DB. Fields remain empty as you're saying: "This does not fire profile update triggers"
So how we get the DB CB fields updated then? I'm afraid I've not got the point here. reload user set to yes.

PS: Code in Code Field works properly, DB got updated.

I don't understand. These two statements are conflicting. You can't have your code action which is acting on the after profile update trigger fire the profile update trigger. That creates an infinite loop and would crash.

Hello,

we have tested our PHP script in a CB Code Field. In this case Auto Action Code is unpublished of course.
PHP code in this field provides correct results and saves data to #_comprofiler. PHP code works properly.
When Auto Action Code is published involved fields are set to type "text field".
What we are looking for is to save data only when profile has been updated.
We understand from your comments that this is not possible via a Auto Action Code when updating values.

Thanks for your assistance.
Regards, Michael.

A code field should not be storing anything. You're causing A LOT of database stores, which will slow database access significantly. You need to handle storage with CB Auto Actions at specific cases like after a profile is updated and/or after a user registers. CB Auto Actions has a Code action where you can supply your PHP. If you want to keep the code field and store the code fields results then use a Field action and substitute in the code field when configuring the value to set into another field.