I am trying to have a certain field continuously update automatically when a related field is updated. Usually, when I make an update to the database I build a workflow around a button which then creates a new entry in a field or updates data in a field. What this does is it allows me to update fields on that specific form at that moment, but it does not update previously created records in the field.
Is there a way to run a workflow on page load that would update related fields? So, for example: If I have field A2 that is connected to a workflow that is continuously adding entries through a standard button workflow. A2 has many records that are created through previous form completions. Then when a related record in the B2 field is added I want to make changes to all of the related A2 records. Instead of updating one record at a time with a workflow connected to a button, I want the B2 input to update all of the related A2 records with the same B2 record.
Not sure if this makes sense. Basically, I want to update one record that then updates all of the records in a related field (It is not a list)