I want to update fields based on updated records in related tables. I use text fields with "calculated value" option, and "auto-enter calculation replaces existing value".
But what if I added another source of calculation? I mean, the process goes like this:
1) Auto-enter calculation removes formatting, spaces and other illegal characters.
2) When the related record is updated in related database, it should also update that parent record.
How to set up "Calculated value" calculation, in order to achieve both of above mentioned objectives?