Can i create three field custom record or we have ...
# suitescriptm
MUHAMMAD MUBUSHER ASLAM
05/31/2021, 6:13 AMCan i create three field custom record or we have better solution for that,
Actually i want to have three field in single list/table ColumnA will be dropdown of location, Column b will be shipping method dropdown and Column C will be freeform text field.
The i want to get this record type on the basis of linelocation and want to show freedormtext value in salesordeelineitem using suitescript, Am I in a right direction?
b
battk
05/31/2021, 6:23 AMyou can usually always do this with suitescript
battk
05/31/2021, 6:24 AMyour ability to do this outside of suitescript depends on your mastery of Sourcing Criteria and Filtering Criteria
m
MUHAMMAD MUBUSHER ASLAM
05/31/2021, 6:28 AMThanks @battk, but my concern is creating custom record is a good idea or we have better solution for that
MUHAMMAD MUBUSHER ASLAM
05/31/2021, 6:28 AMI want to do this and then get freeformtext value from this record
b
battk
05/31/2021, 6:28 AMthe fields and data have to go somwhere
👍 1
battk
05/31/2021, 6:29 AMif not a field on a custom record, then its a field on another record
battk
05/31/2021, 6:29 AMpotentially the location itself
m
MUHAMMAD MUBUSHER ASLAM
05/31/2021, 6:29 AMSo you're recommend ing this?
b
battk
05/31/2021, 6:31 AMdont really know your requirements in enough detail to give recommendations
battk
05/31/2021, 6:31 AMfrom a minimalist perspective, I would avoid the script and the custom record
m
MUHAMMAD MUBUSHER ASLAM
05/31/2021, 6:32 AMIs there any way(other then custom record) i can keep three fields in a row somewhere,
LocationId, ShippingItemId and FreeFormText field in a single row data?
MUHAMMAD MUBUSHER ASLAM
05/31/2021, 6:33 AMthe in salesorderlineitem i want to get the freeformtext field as per locatin change
b
battk
05/31/2021, 6:34 AMcustom fields on the location record
battk
05/31/2021, 6:35 AMcustom transaction line fields to source from the line location
m
MUHAMMAD MUBUSHER ASLAM
05/31/2021, 9:45 AMLocations and shipping method will be many to many relation