Skip to main content
New
Stack Overflow Jobs powered by Indeed: A job site that puts thousands of tech jobs at your fingertips (U.S. only). Search jobs

Questions tagged [lookup]

This type of relationship links two objects together. Lookup relationships are similar to master-detail relationships, except they do not support sharing or roll-up summary fields.

Filter by
Sorted by
Tagged with
0 votes
1 answer
31 views

How to prefill lookup value in lightning web component

I have a requirement to create a task on opportunity with prefilled values from custom fields on the opportunity. I have a lightning web component on the opportunity detail page which I want to use ...
Thomas's user avatar
  • 2,298
0 votes
1 answer
34 views

Lookup (Picklist dependency)

Our system has a Case object which has a Service field and Unit field. The Unit field is a lookup (picklist dependency) of the Service (picklist) field. At present our agents have to use the search ...
Leona Longden's user avatar
0 votes
0 answers
49 views

Salesforce: Lookup Field in Screen Flow is not showing records when searching for a record

For the New Quote button created from Aura its showing the results for Primary Contact. Lookup field when a record is searched, but it is not showing records for Primary Contact. in New Quote. Button ...
Lavanya Pushpakar's user avatar
0 votes
1 answer
65 views

Invalid index (parameter2) Passed to row function. Index must be less than or equal to the row count -

I am trying to display 3 hotel contents in a for loop but I am getting the error while previewing only for specific contacts. Not able to solve this. Any help would be greatly appreciated. This is my ...
Archana Selvakumaran's user avatar
0 votes
0 answers
23 views

Not able to search in lookup when using sforce.one.createRecord

I'm employing sforce.one.createRecord("customObject", "{!jobRecordTypeID}", {!lightningPrepopulatedFields}) within one of my Visualforce pages. The lightningPrepopulatedFields are ...
Kat's user avatar
  • 1
0 votes
1 answer
47 views

Query Accounts from Individual in a Parent-to-Child SOQL query

This is a case in Salesforce: There is a lookup relationship from Account to Individual, both standard objects. How to write a parent-to-child SOQL query where Individual is the parent and Account is ...
Gnopor's user avatar
  • 151
0 votes
1 answer
53 views

record id is not searchable in standard salesforce lookup dialog

I am trying to search related records in a lookup field and I am unable to search using record Id of the record. I tried adding field to search layout. I am able to see the recordId still I am unable ...
Ishan's user avatar
  • 539
0 votes
0 answers
23 views

aura:id in sObjectLookup - aura component

This is a code snippet of my aura component where i used sObjectLookup - <c:sObjectLookup fieldLabel = "Contact" objectAPIName = "Contact" ...
user139696's user avatar
-1 votes
1 answer
69 views

Lookup records not diplay in Experience Cloud for Guest Profile

I have Screenflow with Lookup components and i setup experince cloud with guest access. I gave all permissions but i can't see the Lookup records in Experience cloud site as guest user. Please help on ...
Harikrishna Parvatam's user avatar
1 vote
0 answers
90 views

Does filtering in lightning-record-picker support SOSL?

I am using the lightning-record-picker component and I am querying an object which has its 'Name' field encrypted. This means that I'm returning a 'the like operator is not supported on an encrypted ...
Andy Hitchings's user avatar
-2 votes
1 answer
67 views

An Ampscript loop that will show columns in a foreach instead of rows

I don't think this is possible, but has anyone ever created an ampscript loop that went on column data instead of row data in a lookup data extension? I was thinking of using a BuildRowsetFromString ...
scoopzilla's user avatar
0 votes
0 answers
40 views

How to handle IndirectLookUp datatype in External Datasource in Salesforce while consuming metadata

In Salesforce External Datasource we are trying to Consuming Mule Application via Odata. As part of this, client requirement is for one of the field datatype is IndirectLookup which links to ...
saieem ali's user avatar
0 votes
0 answers
37 views

Lookup Search Page Incomplete match behaviour

I've encountered an issue with the lookup search in Case object. I have lookup field into custom field product__c. When I search incomplete keyword like 'park' it doesn't display any results, but '...
Aza Pradana's user avatar
0 votes
0 answers
33 views

Non-required lookup + lookup formula WHERE condition = weird results?

Lets assume sObject_A with a formula field that calculates some positive number based on record fields. If the number cannot be calculated due to lack of data, the number is set to -1. sObject_B has ...
Kacper A's user avatar
0 votes
0 answers
47 views

Vlocity/Salesforce Industries Cloud: Product Attribute of type Lookup?

Is it supported to create an Attribute of type "Lookup" in Salesforce Industries CPQ? I see that for example, Picklists, text and number are supported but i don't see Lookup to be supported. ...
Giorgos Galaios's user avatar
1 vote
1 answer
284 views

How many LookUp and Master Detail Relationships we can create on a single object?

I have came through various articles saying that we create 25 or 40 Lookup relationships on an object but in my org it is showing relationship limit as 50.Can anyone confirm the right number?
Hira Khan's user avatar
0 votes
0 answers
284 views

How to save multi select lookup values

I have created a multi select lookup component. Below I am pasting my code. HTML <template> <div class="slds-form-element" onmouseleave={toggleResult} data-source="...
Prince Sharma's user avatar
0 votes
1 answer
371 views

I'm unable to select the Id of the related record within the Flow. However, I can choose other fields without any issues

I have a weird problem and don't know how to solve it, maybe I am blind. Please have a look: I need to update a lookup field on the Account object. This lookup field is present on the current record ...
Valentine Potapov's user avatar
0 votes
1 answer
495 views

Salesforce Flow - Update Records Element question

I think I have a pretty easy question for more advanced Flow users. I was working through the Data and Actions in Flows module on Trailhead and on the 2nd section of the module called Data and Actions ...
nwohhn's user avatar
  • 3
0 votes
0 answers
39 views

How is ContactId determined in Visit object on Consumer Goods Cloud?

I'm new to Consumer Goods Cloud and I would like to ask you about a doubt I haven't been able to discover. I have not understand how is the "Contact" (ContactId) standard Lookup field ...
yanaspaula's user avatar
0 votes
1 answer
130 views

Ampscript for Uppercase hyphenated values

I've been trying to solve an Ampscript code, but keep getting the same results. What am I doing wrong? For /* Case 1: Uppercase hyphenated */ a) the original value looks like this A-BCDE b) the ...
O'Kiel's user avatar
  • 3
-2 votes
1 answer
122 views

is sharing settings of parent object can affects the lookup on child object?

My org account object OWD is private. And one of my Sales Rep. try to make an opportunity record and in lookup he wants the account record which he doesn't own. So , can he create opportunity related ...
avnish gupta's user avatar
0 votes
0 answers
65 views

LookupOrderedRows function reutrning 'System.Data.DataRow[]'

I have the below ampscript to lookup the most recent purchase by the date based field "updated_date". %%[ SET @SFCRMID = _subscriberkey SET @orderId = LookupOrderedRows(&...
Greg's user avatar
  • 17
3 votes
1 answer
111 views

AMP script LookUpOrderedRows with deduplication

I'm writing an AMP script code to have a top 3 of products based on pageviews (=value1) inside an email. I've started with the AMP script funtion LookUpOrderedRows and this gave me the desired outcome....
JasBas9100's user avatar
1 vote
1 answer
538 views

Auto populate Lookup Fields related to multiple Objects

I have a custom object called Project, that has related object called Milestone. I then have an object called Log which is related to both a Project and a Milestone. If you create the log from the ...
Ed Lawrence's user avatar
0 votes
2 answers
509 views

Links in email not working in inbox

I have a data extension that contains customers along with a category. In my html content, I want to add the category for the customer IF the customer_id can be found within that data extension. If it ...
T01's user avatar
  • 9
0 votes
1 answer
143 views

ampscript lookup to pull in all rows of data

I am trying to use the LookUpRows function to display specific attributes associated with the 2 members in my Data Extension. The attributes are MEMBER_NAME, MEMBER_NUMBER, CUSTOMER_TYPE & ...
JordanMiguel's user avatar
0 votes
1 answer
101 views

Default look up Behaviour Not Showing Recent searches

I have this Behaviour in my Dev Org that whenever I am an admin and I click on the Change owner (default OOTB feature) and click on the Look up, I can see this: Questions Where is this getting ...
Snorlax's user avatar
  • 37
0 votes
1 answer
62 views

AMPScript Look up values "Start" and "Finish" dates depending on which Step of the process [closed]

In my data extension I have fields for "start date", "end date" and "course's unit" (being 1, 2 or 3 depending on the number of classes for each course). For each student,...
Jane Malins's user avatar
1 vote
3 answers
326 views

Query Lookup Relationship With SOQL Not Working

I have a SalesForce custom object named Loan__c which has a Lookup field called LoanLead__c and I'm trying to query that relationship with SOQL but I'm getting an error when I run the query SELECT Id, ...
Daniel Phillips's user avatar
1 vote
0 answers
404 views

Syntax for setting default value to related records data

Can I set a default value for a text field (name=Sales Manager Number) on the Account that is equal to a field of the same name (Sales Manager Number) on the user record that is related to the Account ...
user7417's user avatar
  • 341
0 votes
0 answers
370 views

How to clear out a lookup value from a flow

I have a flow where I sometimes need to clear the value of a lookup field to a User record. I've tried setting it to nothing (just blank in the update record), I've also tried {!$GlobalConstant.False},...
user1702965's user avatar
0 votes
0 answers
69 views

AMPscript Lookuprows difficulties

I have some difficulties on my ampscript code. Context of the situation : I have this data extension Product_Id is the primary key of this data extension. I am coding by using ampscript so as to ...
ayakuza91's user avatar
0 votes
1 answer
2k views

Salesforce Flow Button on a Record Page to automatically fetch record info

I am trying to create a Custom button on an Opp Record Page to trigger a flow. I placed the flow Button on Campaign__c Record page. This Object, Campaign__c, has a Masterdetail relationship with Opps ...
JACOPO PARISI's user avatar
0 votes
1 answer
77 views

Lookup field: Need different value on opportunity

I have an opportunity setting where the user needs to select a previous opportunity via a lookup field (The relationship field allows users to click on a lookup icon to select a value from a popup ...
Alex M.'s user avatar
  • 55
0 votes
1 answer
113 views

Invalid index (parameter 2) passed to Row function. (boolean values)

I've checked all the topic regarding this issue but still cannot figure it out, Here is the code: %%[ SET @promo = Attributevalue('Is_promotion') SET @lookOrders = lookuprows("...
ACHBK's user avatar
  • 1
0 votes
1 answer
49 views

🙏🏼 How to add a conditional limit number to a look-up field?

I need your help/advice. I have a contact profile that has the following custom fields: Checkbox Manager Checkbox Tutor Lookup field Apprentice I need to work the lookup field filters so that ...
Sebbie's user avatar
  • 91
-2 votes
2 answers
1k views

Contact lookup shows not result on screen flow on Community

I have created a screen flow to be used on the community website but the contact lookup field is not working. I tried all available suggestions on google and still no luck.
Abby's user avatar
  • 9
0 votes
1 answer
237 views

Lookup's related Lookup is blank in test class, even with test data inserted

My Lookup's(MD) related lookup field is coming up as null in testclass. So I have 3 objects, lets Objects X, Y and Z Z is the detail and Y is the Master. Y has a lookup to X In the test class I am ...
Mavsav Sauve's user avatar
0 votes
1 answer
47 views

Lookup function in email builder returning error "invalid field" and does not pull data

I am trying to pull first name of a contact to my email (emailbuilder) through a simple lookup on my shared data extension. <div style="display:none"> %%[ var @dataExtension, @...
Martin's user avatar
  • 1
-1 votes
1 answer
79 views

Variable does not exist (using startsWith)

With this code, I try to check the two conditions of the size of the list and the field MyFamily__c which must not be null, and it works correctly, now I added the very first condition which consists ...
laila19's user avatar
  • 21
1 vote
0 answers
577 views

LWC - Help text won't disappear on lookup

I'm having an issue where the help text won't disappear when using a lookup field in my LWC. It only appears when the user hovers over the little help text bubble, but it lasts forever and I'm not ...
Scarrien's user avatar
  • 133
0 votes
1 answer
79 views

How can I identify when LookupOrderedRows returns 0 values?

I am using the LookupOrderedRows function to pull apartment suggestions into an email, but when there are no apartments available in the lookup DE it displays nothing. I would like to know if there is ...
Greg Beazley's user avatar
0 votes
1 answer
276 views

Trying to check user permission set from related object validation rule

Submitter field in the object has lookup to the user object. I am trying to create validation rule where only user with a specific custom permission set can be assigned to submitter field. But cannot ...
Gul's user avatar
  • 1
-1 votes
2 answers
294 views

Change owner in child automatically [closed]

When we change parent owner in lookup relationship, child owner should change. How can we achieve this in declarative manner?
SFDeveloper's user avatar
0 votes
1 answer
5k views

LWC Data Table: Hyerplink a record with lookup field

I am trying to add a hyperlink in my datatable to the records that are displayed. I achieved this for records that do not use a lookup field, where I can easily access each field as needed. But for a ...
Chris's user avatar
  • 5
1 vote
1 answer
501 views

LWC Custom lookup in custom datatable doesn't extend out of table boundary

I have a custom datatable which contains a custom lookup component. (Custom lookup component is from: https://lwcfactory.com/custom-lookup-salesforce-lwc/) I put it inside of my custom datatable, and ...
missinghome's user avatar
1 vote
1 answer
341 views

Change "what to do if lookup record deleted" for a lookup field with Self Relationship?

On the object "A" I do have an existing lookup field to the very same object "A". In the "Lookup Options" on this field the setting "What to do if the lookup record ...
Ivan Sudakov's user avatar
0 votes
1 answer
127 views

Lightning Universal Lookup Component doesn't work with healthcloud standart objects

I'm using Lightning Universal Lookup Component in a screen flow. It works with objects like Account, Contact etc. but doesn't work with ClinicalEncounter or other health cloud standart objects. Is ...
pt_5858's user avatar
  • 45
0 votes
0 answers
4k views

"Required fields are missing" I got this warning even the value in that field is not missing

Required fields are missing warning when I'm saving the record on a lookup field and can't be saved but it has the value that it required (FinServ__PrimaryOwner__c is the API name of the Primary Owner ...
BigBoyz's user avatar

1
2 3 4 5
21