nlapiLookupField on SuiteFlow's set field value action

Question

I would like to use a custom field value of joined list record on Workflow Action.

I tried the following formula, but it didn't work as we expected.

{custrecord_sw_voyage_year} + '_' +

nlapiLookupField('customrecord_sw_vessel_company', {custrecord_sw_vessel_company}, 'custrecord_sw_vessel_company_name') + '_' +

{custrecord_sw_vessel_name} + '_' + {custrecord_sw_voyage_number}

Cannot we use nlapiLookupField with variables as arguments？

gokuakuatsushishoukai · Accepted Answer

I found the solution, which is

nlapiLookupField('customrecord_sw_vessel_company',

nlapiGetFieldValue ('custrecord_sw_vessel_company'),

'custrecord_sw_vessel_company_name'

).

So we don't need a further investigation.

Thank you for your support.