Version: eXtendFiles 1.6.5 and above
Audience : Administrator

Introduction

Using eXtendFiles, NetSuite Administrators can set static field values during the Public Upload process by using URL parameters. These static field values are applied to eXtendFiles records created from public uploads.

For instructions on setting up the public upload feature, refer to Configuring the Public Upload Feature in eXtendFiles.

Example Usage

Consider an example where you want to set the field eXtendFiles - File Type (Custom) to "Final Artwork" for eXtendFiles uploaded using a particular public upload link.

The field ID of the File Type list is "custrecord_extfile_type_custlist" and the internal id for the Final Artwork list entry is "4".
Image Placeholder

By using the following formula applied to a custom hyperlink field, we can dynamically apply the desired file type to the public upload link:
CASE WHEN {BASE URL LINK} IS NOT NULL THEN CONCAT({BASE URL LINK}, CONCAT('&id=', CONCAT({id}, CONCAT('&rectype=', CONCAT({type}, CONCAT('&custrecord_extfile_type_custlist=', '4')))))) ELSE '' END

The generated link will be:
https://exampledomain.suitextend.net/v1/approval/order/9200f816-6a88-4ba9-848e-8a9faafc2d50?id=39776&rectype=salesord&custrecord_extfile_type_custlist=4

Multiple static field value parameters can be chained together to apply multiple field values:
CASE WHEN {BASE URL LINK} IS NOT NULL THEN CONCAT( {BASE URL LINK}, CONCAT( '&id=', {id}, CONCAT( '&rectype=', {type}, CONCAT( '&custrecord_extfile_type_custlist=', '4', CONCAT( '&custrecord_ext_dept_ref=', '3', CONCAT( '&custrecord_extfile_rs=', '1' ) ) ) ) ) ) ELSE '' END
The generated link will be:
https://exampledomain.suitextend.net/v1/approval/order/9200f816-6a88-4ba9-848e-8a9faafc2d50?id=39776&rectype=salesord&custrecord_extfile_type_custlist=4&custrecord_ext_dept_ref=3&custrecord_extfile_rs=1

Important Notes

  • For Select type fields (single select or multiple select), provide the option’s internal id instead of their textual representation. For instance, use "4" instead of "Final Artwork".
  • Use T or true to specify Boolean values. Note that this is case sensitive, as shown below:
    • &custrecord_extfile_generate_public_link=T
    • &custrecord_extfile_generate_public_link=true
  • In the examples above, replace {BASE URL LINK} with your actual public upload link.