RE: Have a line field list populated by a value set in a body field.

Hi,

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.

For example,

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.

BullgillRunner Rookie Asked on July 26, 2021 in How To's.
Add Comment
1 Answers

I’m almost certain that you’ll need SuiteScript here.

Do you have any experience of SuiteScript at all?

Intermediate Answered on August 3, 2021.

Thanks Chris.
I have managed to get it to work using a suite script. I’m not able to post how I did it this week but will do in case it helps others.

on August 4, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.