how can i create a custom field of list/record for vendor that is filtered to only show vendors whose name starts with 'oci'?

AI generated answer (using internal Slack threads):

To create a custom field of list/record for vendor that is filtered to only show vendors whose name starts with 'oci', you can follow these steps: 1. Navigate to the custom field creation page (Customization > Lists, Records, & Fields > Record Fields > New). 2. Set the type of the field to 'List/Record'. 3. In the 'List/Record' dropdown, select 'Vendor'. 4. Go to the 'Sourcing and Filtering' subtab. 5. In the 'Filter Using' section, select 'Expression'. 6. In the 'Filter Expression' field, enter the following formula:

BEGINS({entityid}, 'oci')

. This will create a custom field that lists vendors, but only shows those vendors whose entity ID begins with 'oci'. Please note that this assumes that the vendor's name is stored in the 'entityid' field. If it's stored in a different field, you should replace

{entityid}

with the appropriate field ID. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******

expression is not an availalbe selection for filter using