Have a line field list populated by a value set in a body field.
I’m wanting a little advice here to focus my direction of travel. The advice may need to become more detailed as I follow down this path.
Basically I want to create have a line field on a custom transaction record have displays a list of values. This list would be dependant on a field value that has been entered in the body of the form.
I have a body field named LOCATION, and I choose the value USA,
In the line(s) of the transaction I have a PLACE field, this would return a list of places in USA, eg New York, San Francisco etc.
Alternatively in the LOCATION field I chose UNITED KINGDOM, this time the PLACE field would show LONDON, MANCHESTER etc.
I have a custom field for the PLACE which gives me the location and place, for these above examples 4 records would be
USA New York
USA San Francisco
UNITED KINGDOM London
UNITED KINGDOM Manchester.
Can I achieve this from basic set up, if so how. or will this need done in SuiteScript?… I’d need some pointers here too.
Any advise would be gratefully received to hopefully focus my direction.
Thanks in advance.