Update relationship between two collections

[AndrewP]

This seems like it should be simple, but I can’t figure it out…

I have two collections:

• Users
• Companies

Relationship: A company can have multiple users. A user belongs to one company.

Screen 1 (Sign up)

• User inputs name, email address, password etc and a user record is created.

Screen 2

• I want the user to input company information into a form, and the submit button should carry out the following actions:
  • Create the company record
  • Update the logged in user record with the company name

I’ve tried every way I can think of but I can’t get the user record to update with the company name
e.g. John Smith is linked to Company X (and vice versa)

Any help much appreciated

[CopyThat]

Share screenshots or do you want remote help?

Dan.trendstonedevelopment@gmail.com

[AndrewP]

So the user should complete this form

When the user selects “Create Company” button I’ve set the update actions to (a) Create the company record in the company collection and (b) then link back to the home screen:

But…

I want the “Create Company” button to complete a 3rd action: To update the company for the logged in user.

This is what I’m assuming should work (Update > Logged in user > Company)

Which gives me these options:

And this is where I’ve got stuck.

The objective is to allow this form submission to automatically update the logged in users company name:

Appreciate any help you can add… thanks

[CopyThat]

On this at the bottom hit users then add logged in user.

[AndrewP]

This is what I’m getting when I do that…

When I click “Logged in user” then “Company” is displayed. That’s the only clickable property.

But alas, does not achieve the objective.

[karimoo]

Don’t get confused by the relationships and display of the several sub menus. Did you try to just click on Loggend In User in your last screenshot?

[AndrewP]

Hi Karimoo,
Yep, if you’re referring to the highlighted link, I tried but it’s not clickable…

[karimoo]

@AndrewP Try the following:
For the second action:

1. Select Update > Loggedn In User
   
   Don’t use Update > Logged In User > Company

2. Select the company field of the user and select New Company
   

[AndrewP]

That’s worked perfectly, thank you so much!