Questions tagged [lookup-filter]
The lookup-filter tag has no usage guidance.
139
questions
0
votes
1answer
36 views
Lookup relationship filter by related object's junction relationship
I have the ff:
Product object with multi select picklist State.
Payment object with string State.
Payment will have a lookup relationship to Product but I need to filter products so that it will only ...
1
vote
1answer
53 views
Lookup filter information
I have a custom Lookup component that will within another LWC. I need to retrieve the filter information for any lookups that has an active filter.
I was able to retrieve data using ...
0
votes
1answer
15 views
How do I create a lookup relationship that populates email instead of 'User'
How the scenario should work:
A required field on opportunities that a user must select from a predefined list of approvers (they just have a flag on their user for department approver) before I use ...
0
votes
0answers
180 views
Lookup Filters with LWC
There appears to be a bug with lwc and lookup filters. When there are multiple lookup fields which have related filters (e.g. Type field is filtered by the value in the Category field), the second ...
1
vote
1answer
274 views
Search multiple fields of custom object from a lookup field
I have a lookup field on Account to a custom object. The lookup dialogue, allows me to search on the record's Name. However, I want to search on one more field. Is there a way to search from a lookup ...
0
votes
1answer
31 views
Increasing the number of instant results in a Lookup field
I have a lookup field in my Contact records that lets you choose a shipping address that is related to the Contact's Account.I applied a filter to this lookup field so it only displays addresses that ...
0
votes
0answers
70 views
Lookup filter to display Contacts related to the Account
I have a custom object called key contacts and roles. On that custom object, I have a field called Account Name which is a Master-Detail relationship field with Account and a field called Name that ...
0
votes
0answers
32 views
Account Lookup filter in Community
We have a custom lookup filed to Account on a Case which points to the "End Customer" account.
We have a lookup filter to only show end customer accounts which are under the Account the Case is under.
...
0
votes
1answer
31 views
Is there a way to filter results in a lookup for certain record types?
I have a lookup on a custom object to the standard object 'Products'. My custom object has 3 record types, and requires an input from the Products. But I would like to filter which Products are ...
1
vote
0answers
293 views
LWC Lookup Filter using another field on record
I have custom objects: events, registration and rooms.
A registration has a lookup for the event and a lookup for the room.
The room have an event lookup as well.
In lightning web components I want ...
0
votes
1answer
46 views
Custom filter based on data extension
we have a data extension with some user status asigned to identificators.
Is it possible to make a filter shows only the possible values of that field based on a DE with those ids and its meaning ...
0
votes
1answer
1k views
How to add standard field lookup filter in to the change set?
I need to add lookup filter modification in to the change set which is done to a standard field in the Contact object. Is that possible to do?
1
vote
0answers
105 views
Lightning Experience Lookup Field not display option “Create new Object”
I have a question, I have a Lookup Field in Case to Order but when I click on this field the option "Create new Order" is not visible, just give me suggestions but this option "Create new Order" does ...
0
votes
1answer
199 views
Formula to Concatenate all Public Group Membership Names onto User Record
I need to create a custom field on the user table that concatenates the public groups this user is a member of separated by ', '. Does anyone know if it's possible to pull public group data through to ...
0
votes
1answer
39 views
Lookup Filter is not working
I created filter Lookup :
(Sales Order Customer Ship To: Record TypeEQUALSShip To) AND ((Sales Order Customer Ship To: Company IDEQUALSPurchase Agreement: Sales Order Company ID) OR (Sales Order ...
1
vote
0answers
99 views
lookup field not working on mobile in community
I have a custom object on the community which has lookup with contact it's working fine in a desktop or if looked from F12 on the laptop. However, when I open the community[Customer community plus] on ...
0
votes
1answer
28 views
Lookup Filter display
Hi is it possible to change lookup results ? instead of displaying the id/autonumber I want to display custom field/text(got 50 datasets of text
0
votes
1answer
39 views
Dont want to associated contact to other objects if status is pending
i want a rule where i dont want to associated contact to other objects if contact status is pending.I am not sure how can i achieve this .any suggestion
5
votes
0answers
2k views
Lookup Filters in custom lightning:recordeditform lightning:inputfield using prepopulated values
I'm using lightning:inputfield in a lightning:recordeditform for lookup fields - we'll call them Party and Warehouse. The Warehouse lookup has filters on it based on the Account field - Warehouse....
0
votes
1answer
773 views
Lookup Filter is not showing object fields to create a filter
I am trying to put a filter on a lookup field so that i can only show the records which will full fill the filter criteria. But in during the setiap of filter criteria i am not able to get all the ...
0
votes
0answers
102 views
Implementing lightning component with number of lookup fields in community
I'm trying to implement a component with lookup fields. The form is to be created dynamically. I tried the following ways :
Approach 1
Using <lightning:inputField> with <lightning:...
0
votes
1answer
360 views
community user not able to populate lookup field which has lookup filter
I have a custom lookup field(contact lookup) in Lead object. Previously both internal & community user are able to populate value for this field. now we have enabled lookup filter condition, after ...
0
votes
1answer
496 views
Related list contacts not displaying in lookup filter in search results
i have created lookup filter in Vehicle object for contact.
i want to see related account object contacts in vehicle object driver(contact) lookup field.
when i am search related contacts driver ...
1
vote
1answer
125 views
Lookup filters should validate on create but not on edit of record
we have a lookup on custom object to opportunity with lookup filter to only show open opportunities.But, at some point the user closes the opportunity and comes back to update a text area field on the ...
1
vote
0answers
180 views
Opportunity Product Lookup Filter [closed]
I was trying to replicate an object fields in my developer org and i came up with an object(which is a part of managed package) and a field of it has Lookup Relationship with Opportunity Product.
How ...
0
votes
0answers
80 views
How to limit lookups in many-to-many relationship based on related record attributes?
I have created a many-to-many relation between Contact and Skill, a custom object that represents a contact's skills. A contact can be one of two different record types, Type A and Type B.
I want to ...
0
votes
1answer
2k views
Lookup filter does not appear to be working
I have a lookup filter that is not filter.
Here is what the user sees:
So I was assuming that records where the Duplicate Assigned field is True would not appear. So if the user still accepts the ...
4
votes
1answer
2k views
Are Lookup Filters supported in Custom Lightning Components?
So, there are two ways to get Salesorce Standard Lookup filed in Lightning components: force:inputField and lightning:inputField. However, no matter what I do, I can not get lookup filters to work. ...
0
votes
1answer
888 views
Filter lookup on Task
Normally in Salesforce we can insert filter logic for lookup fields values by clicking on Edit near to chosen lookup field. Why cannot we do this in case of standard field RelatedTo on Task? This ...
5
votes
0answers
305 views
'Multiple items found' error when selecting from 'My Recent Items' drop down on standard lookup field
Maybe a Summer '18 Version problem?
I have a dependent lookup field where you must select the value via the lookup window. After you have done this there is a standard lookup field that filters on ...
1
vote
1answer
272 views
How to deal with records invalidated due to adding filter criteria on lookup field?
I have an object A which has lookup relationship to object B.
The lookup relationship field on object A is not required.
I recently added filter criteria to this lookup relationship field.
(Added a ...
1
vote
1answer
127 views
Need more than 10 lookup filter criterias
I have 2 objects lets say Contract and CustomA__c. Both these Objects have same record types names (Contract has types A,B,C.., and CustomA__c has types A,B,C..).
I have lookup field on Contract To ...
0
votes
1answer
2k views
Can we use formula fields in lookup filters or how do I implement lookup filter to match `D.A` to be equal to `C.B.A`?
I am trying to introduce a lookup filter.
I have standard object A, standard object D which has lookup to A and custom object B__c which has lookup to A and custom object C__c which has lookup to ...
1
vote
1answer
957 views
FIELD_FILTER_VALIDATION_EXCEPTION but there is no field with a filter
Full message:
FIELD_FILTER_VALIDATION_EXCEPTION - Value does not exist or does not
match filter criteria.
Since a few weeks, I found out today, custom objects records cannot be created due to ...
0
votes
0answers
391 views
Lookup Filter on related list
I have 2 custom objects - Object A and Object B.
Object A has a lookup to Account.
Object B has a lookup to Object A.
When creating an Object B record from Object A (related list), Object A is auto-...
-1
votes
1answer
115 views
Lookup filter Inclusion (Incorrect type. Record Type not compatible with Text)
I have a object b which has lookup to object a. when i prompt to create a new record in object b i will select the record type and then i will go to edit page.
Now when i click the lookup icon of ...
1
vote
1answer
1k views
Custom lookup within Lightning Component
For my scenario, Within a Lightning component there needs to be two custom lookups.
For the first custom lookup, The code for Lightning Component is working perfectly. And when the same code is ...
-3
votes
1answer
35 views
Need help in achieving one requirement [closed]
Business reqmnt:
Suppose there are 2 managers and 4 employees. Manager1 has Emp1 and Emp2 under him and Manager2 has Emp3 and Emp4 under him.
I want to add a picklist or lookup in Manager's layout ...
-1
votes
1answer
217 views
Filtering for dates in a lookup call via AMPScript
we need a date filtered rowset from a data extension in an user's email via AMPScript but the lookup function does not include a filter option.
The rowset we want to retrieve shall have a greater (...
3
votes
0answers
126 views
It is possible to made user-defined lookups filters by code on Lightning?
I'm trying to make my Org Lightning Ready, and i notice that user-defined lookups filters (Lookups with optional filters) are not supported on Lightning.
If you leave the lookup filter as optional ...
12
votes
1answer
448 views
Undocumented SOQL Syntax USING LOOKUP
I've come across a SOQL syntax which I cannot find any documentation for, and was wondering if anyone knew about it.
SELECT Id, Name
FROM Contact
USING LOOKUP Account.ParentContact__c
BIND ParentId ...
0
votes
1answer
396 views
Translation of Lookup window Text
When we add a lookup filter, there is an option to enter the lookup window text. Does Lookup window text automatically translate? or is there a way to translate Lookup window text?
Please suggest. ...
0
votes
2answers
762 views
Reading Lookup Filter criteria from SObject field descriptions?
We are implementing a special type of lookup window in a VisualForce page, which displays a set of potential records a user can select from to populate a Lookup value. As a means to allow users to ...
0
votes
1answer
97 views
Lookup-Filter Classic to Lightning
I have ran the release readiness report to identify what gaps I need to consider for moving from Classic to Lightning and I have profiles that need to have some work addressed, one of which is Lookup ...
2
votes
0answers
507 views
No Recently Viewed Records In Lookup
A custom object Payment_History__c has a Lookup field to the standard Order object.
There is no lookup filter for the field.
But when I click on the "magnifying glass" icon
I don't see any ...
0
votes
0answers
86 views
Can an sobject be queried using One of the Sobject Field's lookup filter criteria in Apex
Is there any Apex API like to get the Lookup filter condition defined on an sObjectField of type "lookup" so that the condition can be used in SOQL.
0
votes
2answers
44 views
look up filter failing while doing copy paste
I have a custom lookup filter on an opportunity to show only active records of a custom object (look up relation ship) . Its working well in regular process but its failing when I do copy paste of ...
1
vote
2answers
721 views
Lookup filter with permission set criteria got error Field $Permission.XXXX does not exist. Check spelling
I want to filter user lookup with criteria: only users have permission set name 'manager_user'. So to achieve that, i do as follow:
Create a permission set name 'manager_user'
Create a custom ...
0
votes
1answer
212 views
LookUp from two data extension at the same time?
We have couponcode email flow where we want to send out a reminder email to those who didn't use the code.
We have several data extension with codes, because we have had to use new codes on a regular ...
1
vote
1answer
766 views
Need lookup filter that filters a date against today or date stored in a formula field
I have a lookup field in the quote line item standard object. It is a lookup field to a custom object that has a field that is an expiration date.
I need to be able to filter the lookup so that it ...
