I have a sign up process where users can invite other users to join their organisation. As such I have 3 key tables: Users; Invited Users; and Company Information. Users have a linked field to an Organisation ID field in the Company Information table so that the site can display information about the company they are assigned to. When a user invites a new user to join their organisation the Invited User table is updated with a new record including their Email, Name etc. and
a linked field “Organisation ID, linked to the Company Information table. Then when an invited user signs up they are added to the Users Table and there is an automation that pulls over information from the Invited Users table like their access level and assigned Organisation ID. However, pulling over the Organisation Field results in a "Field "Organisation ID" cannot accept the provided value: Cannot modify a computed field." error.
I have tried changing the transfered value to a static value (plain text), using the Organisation ID, using the Record ID. It’s like an automation cannot update a linked field at all.
Any ideas how to overcome this issue? Thanks in advance!

