Copy Data From One Table, To Change Data On Another Table

[wrodriguez1]

Hello,

I have a table called FleetRequest where our employees go in and request a vehicle to use temporarily or permanently. Then there is a table called VehicleAsset that holds all of the vehicles we have in stock. I set it up where from the request there is a dropdown that references VehicleAsset and displays the vehicles that are currently unassigned. You can then save that vehicle to that request and mark it completed.

I wanted to make an action that passes on the driver name from the request over to the asset table.

FleetRequest[employee_name] -> VehicleAsset[assigned_driver]
VehicleAsset[vehicle_status] = “4”

Status 4 is a referenced table that equals “Assigned”.

I made an action:

I used: ANY(FleetRequest[employee_name])
because it gave me an error if I used: FleetRequest[employee_name]

“The expression is valid but its result type ‘List’ is not one of the expected types: Ref”

I then tried to make a WorkFlow, which is where I found my issue.

I can’t add the action I made because it is from another table.

Of course, any help with this would be much appreciated. I am truly grateful for this community. You guys have helped me with multiple things thus far.

So thank you.