Using MASS UPDATE to update other Fields in Creator. Or using WorkFlows with Custom Forms.

Using MASS UPDATE to update other Fields in Creator. Or using WorkFlows with Custom Forms.

Using MASS UPDATE to update other Fields in Creator. Or using WorkFlows with Custom Forms.

Hi.

I need to do a bulk update so that when a field is ticked, another field updates. I.e. "Confirmed Status" is ticked then a text field called "Current" status would be updated with the text of "Confirmed".

I have created an app to do this. It does lots of checks and the code works great in a single form as it uses the OnSuccess events and the OnChange events that happen when creating a new entry or editing a current one.

The problem is, I want to view my form data in a list, MASS UPDATE them and change all the records accordingly. It doesnt seem to process my code when this happens, it simple updates the value I have told it to update which is useless.

Can someone tell me how to do this please?

I have looked into Worlflow Automation rules, I thought that would be ok because I could set a rule that when the tick box updates then I can update the field which would work fine. However when setting the rules I dont have my custom tables to select from. Can I link these tables in the CRM so they appear in various drop downs for things like Workflow Automation Rules?