Skip to main content

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!

 

Hm is the primary field of the Company Information table a formula field or something?  I think what may be happening is we’re pasting in a value that doesn’t yet exist in the Company Information table, and that’s why it’s erroring out

e.g. If the Company Information table has two records with the primary field values of Company A, Company B

And you get the automation to paste into a linked field to that table ‘Company C’, that error will appear

 

To resolve this, you’ll either need to:

  1. Make the primary field of the Company Information table a text field
  2. Ensure that the Company Information table has the value that you’re trying to paste in from the Invited Users table

If the above doesn’t apply, could you provide screenshots of the following please?

  1. The Company Information table
  2. The Invited Users table
  3. Automation set up for the ‘Update record’ step

 


Thanks for the recommendation, got me closer, data was actually entered into the fields but they were errors or code rather than the values from the Invited Users table.

 Invited Users table:

Updated Users table:

 


Hmm, so your automation

  1. Searches for the email in ‘Invited Users’ table and grabs the linked record from ‘Organisation ID’
  2. Pastes it into the ‘Active Organisation’ linked field in ‘Updated Users’

Is that right?  

Could you provide screenshots of the Company Information table and the automation set up for the ‘Update record’ step?


Hey ​@IanImpactory,

If you prefer, feel free to grab a slot using this link and I’m sure we can get it solved together in a couple of minutes! 

Mike, Consultant @ Automatic Nation


Hi,
the most reliable way to link is to use record ID(s).
Find records result is array (even when it finds 1 or 0 records), so using it as a single value depends on whether you can convert it to string. But.
Linked field value is array too, so Find Records result it ideally fits in it to use.
This way:
 

Note: ensure you are targeting the correct table in Find records. For debug, try to manually paste ID or list of IDs into linked field. When record with this ID present in the linked table, it links to it. If not, it uses ID as usual text value.

 


Hi all, thanks for the suggestions and advice. Yesterday I went back to basics to test a few things out and found that even updating the Users table from a form, not filling data with an automation, was causing errors. No idea why. I rebuilt the table from scratch, connected it and found a way to invite users without the Invited Users table, so simplified the flow, and now everything works. No idea what happened to the original Users table but all now working!


Glad to hear that ​@IanImpactory. Make sure to reach out if anything else comes up :D

Mike, Consultant @ Automatic Nation 


Reply