How to change the contains of a field when another field is updated from FrontEn

I would like to create one or several autoactions that would set a field to "No" when a registered user update a profile field or when no file has been uploaded in a file field or when the uploaded file is replaced.

Can you explain how I can do that with Autoaction plugin ?

Thanks

See below on how to trigger an action when a fields value changes.

www.joomlapolis.com/forum/153-professional-member-support/240617-solved-cb-autoaction-on-change-of-specific-user-fields#310923

As for acting on another field being set to "No" simply add an OR condition for that. Same applies for if the field is empty. So you'd have 3 OR conditions in total to cover your usage. If you want it to also apply to moderator profile edits or backend profile edits you'll also need to use the onAfterUpdateUser trigger.

I will try. Thank you.

Thank's.
This is working as shown in the exemple.

What are the usage of the other Var_x ?

I have tried to reproduce the query exemple www.joomlapolis.com/images/stories/tutorials/uc001/aa-sql-block.png

It does not work. I have set trigger onupdateuser . Are your query syntax compliant with sql syntax ? I am surprise to see two type of ' in this exemple and not table jointure between users and comprofiler for the id=user_id

Sorry for my poor knowledge.

The var# usages are to access the variables of a trigger. You need to be using the triggers onAfterUserUpdate and onAfterUpdateUser to cover backend and frontend user edits. var1 is the new user object and var3 is the old user object. This allows you to compare the new field value to the old field value so you can see if it changed. If you don't need to compare values you can just use [FIELD_NAME] substitutions.

For example if you've a checkbox field and you want to condition on that field being checked you'd use the below.

[FIELD_NAME] Equal To 1

For checkbox fields Yes (checked) is actually stored as 1 and No (unchecked) is actually stored as 0 or NULL. So it's best to condition Equal To 1 for checked and Not Equal To 1 for unchecked.