Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
How to add custom field to formula
Hello All,
I’m looking to modify a formula used for the default value of a custom item field.
The current formula
REGEXP_REPLACE({custitem_ca_images_csv}, '([^,]+)', 'https://example/images/\1')
adds the URL https://example/images/ to a list of images pulled from custitem_ca_images_csv.
Example:
custitem_ca_images_csv = image1.jpg, image2.jpg, image3.jpg
Results = 'https://example/images/image1.jpg,https://example/images/image2.jpg,https://example/images/image3.jpg
I would like to replace the URL https://example/images/ with the custom field custitem_ca_images_url so I can more easily change the URL by updating the field and not the formula.
0