Hello yandiw6015,
Could you please check if this is your requirement. And I would suggest to use a summary page on a related action when you click on the Product name. Just for the UX/UI POV. Hope this helps!

a!localVariables(
local!selectedName,
{
a!columnsLayout(
columns: {
a!columnLayout(
showWhen: a!isNotNullOrEmpty(local!selectedName),
contents: {
a!sectionLayout(
label: "Your Reference Data",
contents: {
a!buttonArrayLayout(
align: "END",
buttons: a!buttonWidget(
label: "Clear Selection",
icon: "times",
saveInto: a!save(local!selectedName, null)
)
),
a!richTextDisplayField(
value: {
a!richTextItem(
text: "Selected Product: " & index(
local!selectedName,
'recordType!{f97605c9-a3a8-48e4-948b-1ba114fa3269}ITAM Inventory.relationships.{974d1e66-6035-4fad-8eac-beb394166ab8}masterWarehouse.fields.{291a305e-54a3-40db-b538-a50d32b7338e}warehouseName',
null
),
size: "MEDIUM_PLUS",
style: "STRONG"
)
}
),
a!textField(
label: "Your Input",
labelPosition: "ABOVE",
saveInto: {},
refreshAfter: "UNFOCUS",
validations: {}
)
}
)
}
),
a!columnLayout(
contents: {
a!gridField(
label: "My Data",
labelPosition: "ABOVE",
data: 'recordType!{f97605c9-a3a8-48e4-948b-1ba114fa3269}ITAM Inventory',
columns: {
a!gridColumn(
label: "Inventory Id",
sortField: 'recordType!{f97605c9-a3a8-48e4-948b-1ba114fa3269}ITAM Inventory.fields.{0ae1d15c-5981-4d9a-aedc-1852852b5548}inventoryId',
value: fv!row['recordType!{f97605c9-a3a8-48e4-948b-1ba114fa3269}ITAM Inventory.fields.{0ae1d15c-5981-4d9a-aedc-1852852b5548}inventoryId'],
align: "END"
),
a!gridColumn(
backgroundColor: if(
a!isNullOrEmpty(local!selectedName),
"",
if(local!selectedName = fv!row, "ACCENT", "")
),
label: "Master Warehouse",
sortField: 'recordType!{f97605c9-a3a8-48e4-948b-1ba114fa3269}ITAM Inventory.relationships.{974d1e66-6035-4fad-8eac-beb394166ab8}masterWarehouse.fields.{291a305e-54a3-40db-b538-a50d32b7338e}warehouseName',
value: a!richTextDisplayField(
value: a!richTextItem(
text: fv!row['recordType!{f97605c9-a3a8-48e4-948b-1ba114fa3269}ITAM Inventory.relationships.{974d1e66-6035-4fad-8eac-beb394166ab8}masterWarehouse.fields.{291a305e-54a3-40db-b538-a50d32b7338e}warehouseName'],
link: a!dynamicLink(
saveInto: a!save(local!selectedName, fv!row)
),
linkStyle: "STANDALONE"
)
),
align: "END"
),
a!gridColumn(
label: "Product Master Detail",
sortField: 'recordType!{f97605c9-a3a8-48e4-948b-1ba114fa3269}ITAM Inventory.relationships.{63d57cbf-6e2c-43f4-8e36-40bab0fc80b2}productMasterDetail.fields.{eb4513cb-275e-4a41-b750-ace5dc577704}productName',
value: fv!row['recordType!{f97605c9-a3a8-48e4-948b-1ba114fa3269}ITAM Inventory.relationships.{63d57cbf-6e2c-43f4-8e36-40bab0fc80b2}productMasterDetail.fields.{eb4513cb-275e-4a41-b750-ace5dc577704}productName'],
align: "END"
),
a!gridColumn(
label: "Quantity Available",
sortField: 'recordType!{f97605c9-a3a8-48e4-948b-1ba114fa3269}ITAM Inventory.fields.{287c4f80-c1b1-4152-b492-1959168a950e}quantityAvailable',
value: fv!row['recordType!{f97605c9-a3a8-48e4-948b-1ba114fa3269}ITAM Inventory.fields.{287c4f80-c1b1-4152-b492-1959168a950e}quantityAvailable'],
align: "END"
),
a!gridColumn(
label: "Minimum Quantity",
sortField: 'recordType!{f97605c9-a3a8-48e4-948b-1ba114fa3269}ITAM Inventory.fields.{4f283990-42f8-4efe-832e-1faf6f9be623}minimumQuantity',
value: fv!row['recordType!{f97605c9-a3a8-48e4-948b-1ba114fa3269}ITAM Inventory.fields.{4f283990-42f8-4efe-832e-1faf6f9be623}minimumQuantity'],
align: "END"
),
a!gridColumn(
label: "Alert Notification",
sortField: 'recordType!{f97605c9-a3a8-48e4-948b-1ba114fa3269}ITAM Inventory.fields.{52373b6f-52b7-4061-8eee-c8cb593db3a6}alertNotification',
value: fv!row['recordType!{f97605c9-a3a8-48e4-948b-1ba114fa3269}ITAM Inventory.fields.{52373b6f-52b7-4061-8eee-c8cb593db3a6}alertNotification']
),
a!gridColumn(
label: "Back Order",
sortField: 'recordType!{f97605c9-a3a8-48e4-948b-1ba114fa3269}ITAM Inventory.fields.{55c8ba54-a873-4a91-babf-69110ff4e2ed}backOrder',
value: fv!row['recordType!{f97605c9-a3a8-48e4-948b-1ba114fa3269}ITAM Inventory.fields.{55c8ba54-a873-4a91-babf-69110ff4e2ed}backOrder']
),
a!gridColumn(
label: "Created By",
sortField: 'recordType!{f97605c9-a3a8-48e4-948b-1ba114fa3269}ITAM Inventory.fields.{6b1dc071-42e2-4e0a-bcd6-0d055b50780b}createdBy',
value: fv!row['recordType!{f97605c9-a3a8-48e4-948b-1ba114fa3269}ITAM Inventory.fields.{6b1dc071-42e2-4e0a-bcd6-0d055b50780b}createdBy']
),
a!gridColumn(
label: "Created On",
sortField: 'recordType!{f97605c9-a3a8-48e4-948b-1ba114fa3269}ITAM Inventory.fields.{9baafd08-c411-4085-97d2-b405609ddd42}createdOn',
value: if(
isnull(
fv!row['recordType!{f97605c9-a3a8-48e4-948b-1ba114fa3269}ITAM Inventory.fields.{9baafd08-c411-4085-97d2-b405609ddd42}createdOn']
),
fv!row['recordType!{f97605c9-a3a8-48e4-948b-1ba114fa3269}ITAM Inventory.fields.{9baafd08-c411-4085-97d2-b405609ddd42}createdOn'],
datetext(
fv!row['recordType!{f97605c9-a3a8-48e4-948b-1ba114fa3269}ITAM Inventory.fields.{9baafd08-c411-4085-97d2-b405609ddd42}createdOn'],
"default"
)
),
align: "END"
),
a!gridColumn(
label: "Modified By",
sortField: 'recordType!{f97605c9-a3a8-48e4-948b-1ba114fa3269}ITAM Inventory.fields.{c0cc1097-c059-46e2-be44-ae3ccd8ba98f}modifiedBy',
value: fv!row['recordType!{f97605c9-a3a8-48e4-948b-1ba114fa3269}ITAM Inventory.fields.{c0cc1097-c059-46e2-be44-ae3ccd8ba98f}modifiedBy']
),
a!gridColumn(
label: "Modified On",
sortField: 'recordType!{f97605c9-a3a8-48e4-948b-1ba114fa3269}ITAM Inventory.fields.{dfc8e076-23d4-4bf3-bf4a-57b8bb098664}modifiedOn',
value: if(
isnull(
fv!row['recordType!{f97605c9-a3a8-48e4-948b-1ba114fa3269}ITAM Inventory.fields.{dfc8e076-23d4-4bf3-bf4a-57b8bb098664}modifiedOn']
),
fv!row['recordType!{f97605c9-a3a8-48e4-948b-1ba114fa3269}ITAM Inventory.fields.{dfc8e076-23d4-4bf3-bf4a-57b8bb098664}modifiedOn'],
datetext(
fv!row['recordType!{f97605c9-a3a8-48e4-948b-1ba114fa3269}ITAM Inventory.fields.{dfc8e076-23d4-4bf3-bf4a-57b8bb098664}modifiedOn'],
"default"
)
),
align: "END"
)
},
validations: {},
refreshAfter: "RECORD_ACTION",
showSearchBox: true,
showRefreshButton: true,
recordActions: {
a!recordActionItem(
action: 'recordType!{f97605c9-a3a8-48e4-948b-1ba114fa3269}ITAM Inventory.actions.{950ccf0d-2875-4d30-b94d-fe62a4db6c2e}newInventory'
)
}
)
}
)
}
)
}
)