Questions tagged [lookup-filter]
The lookup-filter tag has no usage guidance.
136
questions
0
votes
0answers
10 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 ...
0
votes
0answers
121 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
43 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
0answers
22 views
How to populate related contacts list by selecting account in lookup?
I have two lookup's 1. Account Lookup and Contact Lookup
Trying to get related contacts to the specific account selected .
For that I have used a formula on contact field is
Formula : Contact: ...
0
votes
0answers
25 views
How to populate related contacts in contact lookup by selecting account in account lookup in visualforce page?
I'm trying to populate related contacts in contact lookup by selecting account in account lookup in a visualforce page.
For that I have searched in google and found some information to achieve this.
...
0
votes
0answers
9 views
can we change sample text(search parent object) of lookup field
DO we have to change the sample text of lookup field, I have 4 lookup field which is releated to same custom object(purpose is to display the value based on lookup filter criteria), like as per screen ...
0
votes
1answer
428 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
84 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
129 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
25 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
70 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
24 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
38 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
4
votes
0answers
1k 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
349 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
62 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
141 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 ...
1
vote
1answer
340 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
52 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 ...
0
votes
1answer
2k views
How to get lightning lookup field value to save a record?
I have implemented a custom lookup component in lightning(by using Lightning: pill) and I embed it into another component. but don't know how to get the selected lookup field value?
Child Component2:
...
1
vote
0answers
121 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
65 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
1k 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
1k 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
542 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
258 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
88 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
99 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
1k 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
399 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
271 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
93 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
34 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
145 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
118 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 ...
11
votes
1answer
332 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
301 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
1answer
495 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
83 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
393 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
81 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
41 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
513 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
182 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
633 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 ...
0
votes
1answer
111 views
Remove or hide values from lookup
I have a junction object (Employee_Skills__c) between Contact and Skill__c(Custom object). Is there a way that we can remove/hide from the lookup of Employee_Skills__c those values which is not being ...
0
votes
0answers
46 views
Change the search field in lookup dialogue
One of the objects has lookup relationship with Addresses object. The lookup dialogue, allows me to search for Addresses on Name. I however want to search on some different fields.
Accessing setup ->...
1
vote
1answer
615 views
Related contacts of Account in Task - Lookup filter
I have contact lookup in task. If I choose contact then it should show only related contacts to Account. I put the filter condition as follows
Activity: Related To ID equals Contact: Account ID
The ...
