Allow Automations to Update entities via Lookup fields

I am frustrated by the inability of Rules to Update entities related through a Lookup :unamused:

It means more Javascript, which seems unnecessary.

This should also include formula fields, which would really expand the automations capabilities.

Formulas would essentially allow you to update any entity in the system without script and without linking entities.

Adding frustration to this! It allows for ones that are with ā€œAutolinkingā€ I think I will need to autolink the relation that could have been a lookup just to get the automation to update it.

Facing this issue again when trying to build something. I love how lookups/formulas behave almost like relations in many ways, I wish this was part of the ways.

Solved with auto-linking, (formula outputting the IDs of the needed relations, then auto-link based on ids… The new ā€œcontainsā€ in auto-linking is a saviour) but this results in two fields instead of one which is just a bit redundant.

Ideally this feature request is possible.