How to use Auto action to set all users to have a field set to NO?

Hi

I would like to have a field of all users set to NO (the site has already 4000+ users). How do I best do that?

Also, can I have a CRON job done so that it triggers this auto-action every 30 days?

Thanks

Tim

timstohr wrote: Hi

I would like to have a field of all users set to NO (the site has already 4000+ users). How do I best do that?

Also, can I have a CRON job done so that it triggers this auto-action every 30 days?

Thanks

Tim

Best way is to execute a database SQL query to do this.
The table you would need to update is the comprofiler one.

Create a Query action with no trigger selected (should say None) with a query to update the _comprofiler table and set the field value. Then use the "Internal Action URL" (found under the Global tab after saving the action) in CRON to trigger the action regularly.