Hi, I'm looking for a solution to this.

Context : I have a field in a form that fetches it's value in another field in another form based on the value entered in another field in the same form. That bit is ALREADY taken care of with a script that fetches the value "On Add" and "On Edit" so the value is added to the field when creating a new record or when updating an existing record.

Question : What I'm looking for is a way to update in one step this field for all existing records at once. Currently, if i create a new record or edit an existing record, this field gets its content through the form action, all fine. The problem is, the existing records in this database do not have their value fetched for this filed unless I edit them (in which case they do automatically get their value for this field through the "on edit" action). I have hundreds of records and would like a way to run this script once for all records instead of having to go and edit every record one by one.

Note : I tried updating all records at once using a dummy filed with a bulk input of "xyz" for all records, but it didn't work. It looks like a 1 field bulk edit does not result in a whole record edition that would run the "On Edit" action.

In summary my question really is : How can I run an action once for all existing records in a database (form) ?

Thanks!