Populate cell from another table value

[ParrotHead72]

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?

[NailDyanC]

Hi, this would be possible using Triggered action. You may try to check this article from Caspio: 

https://howto.caspio.com/tables-and-views/triggered-actions/

[cheonsa]

Hi @ParrotHead72, 

I created a sample Triggered Action for your reference:

 

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!