This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I always struggle, how do I pull dynamic field references into this formula? '{"name":"{custrecord_gp_finish_item}", "age":30, "car":{custrecord_gp_user_loc}}'

• It's just a default formula in a custom field

so it would be non stored, reading values from other fields on the same custom record to be dynamically producing that json blob

Have to add a || before and after the fields to concavenate it all together

Also a single quote before and after the ||

Each dynamic field should be ‘|| {fieldID} ||’

{"name":"'||{custrecord_gp_finish_item}||'", "age":30, "car":"'||{custrecord_gp_user_loc}}||'"}{"name":'||{custrecord_gp_finish_item}||', "age":30, "car":'||{custrecord_gp_user_loc}}||'}

Your formula has an error in it. It could resolve to the wrong datatype, use an unknown function, or have a syntax error. Please go back, correct the formula, and re-submit.

Put a single quote before and after the whole thing

Also you have double curly braces after some of you fields

'{"name":"'||{custrecord_gp_finish_item}||'", "age":30, "car":"'||{custrecord_gp_user_loc}||'"}{"name":'||{custrecord_gp_finish_item}||', "age":30, "car":'||{custrecord_gp_user_loc}||'}'