Check that your fields are outputting as expected on the users profile. Your auto action is just comparing those two fields and sending an email so if they output fine on profile the auto action condition will also work fine. More than likely your queries need adjustments as both can respond with more than 1 result and I suspect you only want the most recent.

It likely would be better to use a Code action and set Method to PHP then simply code out a custom solution that handles looking for groups that match their uploads, which should act on the gallery_onAfterCreateGalleryItem trigger.

do we have any tutorial or any examples of using "CB code field"?

No, you wouldn't be using CB Code Field. You'd be using a Code action in CB Auto Actions and coding the group lookup based off upload (for that trigger the upload would be var3). Both Code action and CB Code Field however simply take your PHP and execute it and in the case of CB Code Field it displays the results of your PHP as the fields value.

And do you guys help with PHP code with additional charge?

No.

krileon wrote: More than likely your queries need adjustments as both can respond with more than 1 result and I suspect you only want the most recent.

I think adding a LIMIT 1 at the end of your queries will help.