[SOLVED] Field updated when another field edited

Following up on my previous post:
forum/255-developer-members-support/236772-solved-code-field-update-when-another-field-is-edited

So either my logic is wrong, or I have configured something incorrectly but here is what I am trying to do:

• I have a 3 separate query select fields where a member selects their 1st, 2nd & 3rd city choices (working correctly)
• I have 3 separate datetime fields to record the date and time of each city choice/change above
• I switched from using code fields (the previous post noted above) to 3 query fields which each set to update each date field when that city is changed

I update each field separately using each city change as its ajax trigger, however when I change any one, all 3 are updated to the new time.

Suggestions?

So here is an update:
The datefield is being updated on each page view? This is not just the date view, but the date in the field in the table. Could this be the result of using a query, although ajax updating the field is supposed to only happen at registration and profile edit I had read.

Here is the code and settings I am using at each stage:

• The select query for the city:
  cb_city_one
  SELECT `province`, `city_name`, `city_id` FROM `#__townlocations_canada` ORDER BY province, city_name
  integrations: none
• The datetime field:
  cb_choice_one
  format: Default settings
  integrations: none
• The query date field:
  cb_pick_one
  UPDATE `#__comprofiler` SET `cb_choice_one` = NOW() WHERE `#__comprofiler`.`user_id` = [user_id]
  integrations: Update On: cb_city_one

Suggestions/corrections are appreciated.

Doing an update query means it will do that update every single time the field is output. You'll need to use a Query or Field action in CB Auto Actions do the update once or based off whatever criteria you need. Assuming cb_choice_one is a datetime field the below would work.

Global
Triggers: onAfterUserUpdate
Type: Field
User: Automatic
Access: Everybody
Conditions
1: [cb_choice_one] Equal To 0000-00-00 00:00:00
Action
Field: cb_choice_one
Operator: Set
Value: [cb:date format="Y-m-d H:i:s" /]

Thanks Kyle.
If I want to update the datetime field every time the city selection is changed, is there a different condition I can use?

Yup, you can check to see if the city field change its value using the below condition.

[var1_cb_city_one] Not Equal To [var3_cb_city_one]

var1 is the new user object with their most recent changes. var3 is the user object before the profile update. Using those two variables you can compare fields to see if they were changed.

Thanks again Kyle.
You have really built an incredible extension.