Hi, everyone! Excuse my word choice since I'm new ...
# generalu
李 知恵
05/29/2023, 10:35 AMHi, everyone! Excuse my word choice since I'm new to netsuite..
I want to put a field value in the result tab in saved search.
For example, there is a field called {myfield}, I chose FORMULA(TEXT) then put {myfield} in a formula tab(?).
then, this gave me an error saying it's not valid.. What should I change?
n
NElliott
05/29/2023, 10:52 AMWhat's stopping you from just choosing your field from the list of available fields in the results section?
u
李 知恵
05/29/2023, 11:50 AMI can't find the field from the list... Hmm maybe its name is different.. or it's under another field?
n
NElliott
05/29/2023, 11:51 AMDid you create the field? Check the options on it such as "show in list".
NElliott
05/29/2023, 11:52 AMMaybe show the field on the record, it's definition and your search here.
u
李 知恵
05/29/2023, 12:35 PMThe field I wanna search ↓ (Customer / Vendor Record)
李 知恵
05/29/2023, 12:36 PMand I don't see the field here.
Saved Search type is 'entity'
n
NElliott
05/29/2023, 1:17 PMAre you sure that's a custom field? It's a native field on a vendor record...
NElliott
05/29/2023, 1:17 PMIf it's the native field In it's not searchable
NElliott
05/29/2023, 1:18 PM(according to the records browser)
u
李 知恵
05/29/2023, 1:23 PMoh, yeah it's not a custom field.
李 知恵
05/29/2023, 1:25 PMI see..! I thought I could retrieve the value in saved search, but I guess I need to do something else... (maybe by script..?) thanks!
n
NElliott
05/29/2023, 1:25 PM3 Views