Jump to content
  • 0
Sign in to follow this  
ParrotHead72

Populate cell from another table value

Question

I have 2 Tables:  Computers and Users.  In the Computers table, i have information of SerialNumber, CPU, RAM, OS, Model, and IssuedTo.  In the Users table, i have information of FirstName, LastName, FullName,... and AssignedComputer.

What I would like is when I populate the IssuedTo field in the Computer table with a user's FullName, I would like it to auto populate the SerialNumber in the AssignedComputer field of the User table.

 

How do I link them?

Share this post


Link to post
Share on other sites

2 answers to this question

Recommended Posts

  • 0

Hi @ParrotHead72

I created a sample Triggered Action for your reference:

image.png.f03c1ee3c0dffd8b7a9c6f96f33df8bb.png

 

In this scenario, I already have records in the Users Table. Then, upon insert or update in the Computers Table, the AssignedCompter filed in Users Table will update if the FullName is equal to IssuedTo. 

 

Hope this helps!

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...