see i have a sheet named vessel and it contains fields as vesselname and displayowner(need tobe taken from the display owner field) and i have another sheet named shipowner contains fields as VesselName and owner (contains owner data) , the vesselname in vessel sheet , the VesselName in shipowner sheet are having same values now i want to know how can i get the displayowner field gets filled by cross checking the vesselnames . I mean it should check the vesselnames and if they are equal then it should look for the corresponding owner name and that should automatically get filled in the displayowner feild
Hi there,
To achieve your goal of automatically filling the DisplayOwner
field in your Vessel sheet based on the matching VesselName
from the ShipOwner sheet, we recommend using Ragic’s Link & Load feature.
This feature allows you to link records between two sheets via a shared key field—in your case, VesselName
. Once the link is established, you can automatically “load” related data—such as the Owner
field—into your current sheet.
Here’s how it would work in your scenario:
- In your Vessel sheet, set up a Link & Load relationship with the ShipOwner sheet using the
VesselName
field as the link field. - Then, configure the
DisplayOwner
field to load theOwner
value from the ShipOwner sheet.
Check out the user guide here for more details:
Link and Load
Hope this helps!