Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
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.