You need to sign in to do that
Don't have an account?
Ossie
Concatenate 2 Fields
Hi,
Is it possible to concatenate 2 fields and then set this as a value of a different field.
for example:
Field1__c = Field2__c + Field3__c
Is this possible??
Thanks in advance!
yes, why not?
it depends on the types of the 2 fields.
You can solve this with a formula field.
for example:
formula field type text:
Full Name = LastName & ", " & FirstName
All Answers
yes, why not?
it depends on the types of the 2 fields.
You can solve this with a formula field.
for example:
formula field type text:
Full Name = LastName & ", " & FirstName
Yes it is possible you will just require a workflow or a trigger. Let me know if you have any issue in it. You can read
trigger in : http://forceschool.blogspot.com/search/label/Apex%20Triggers
Thank You
Thank You that was very helpful.
Thanks Baktash H. ,
I was able to resolve due to your solution . But , using this formula : Full Name = LastName & ", " & FirstName (for concatenating two lookup values is actually concatenating IDs )
I have achieved this by below formula inherited from you ,this will help if somebody facing similar issue like me :
LastName__r.Name + " " + FirstName__r.Name
This is what I typed out, but it says I have a syntax error: extra "," how do I fix this?
Hi everyone,
I am in a very complicated situation. Please give some inputs or ideas to tackle this.
In our org some managers are using a Form (made using Formstack)to gather information from customers at the time of some changes in their requirement. So, this changes what customers are asking are capturing as a custom object 'Request' in SF. All the fields in the form are mapped to the custom fields (on Request object) in SF.
But the requirement is, most of this custom field they don't want to see in the page layout of request. Instead of that they want to put most of the field's data capturing in the form wanted in description field-'Request Detail'in SF.
For example:
Form fields: Request due date, Regions (picklist type), Country(picklist), Description fields (there are many fields in forms that are picklist,date,free text,checkbox)
In SF they need all the above field information in a single 'Request Detail' Description field. That too if the form field is blank while filling by manager, that field shouldn't include in the 'Request Detail'. It should only include form fields data in 'Request Detail'(in SF) if it's not blank while filling the form.
How can i include all these criterias and capture all the field data from that form to a single field in SF?
So complicated for me.
Any inputs will really help. Please let me know if more information is required
Thanks
Sandaya
I have a related question. I'm concatenating event names for two event types for contacts who have a status of "checked-in" on these event records. I have a DLRS rollup with the below:
Event_Type__c = 'Inservice' AND CnP_PaaS_EVT__CheckIn_Status__c = 'Checked-In'
But now I need to add a second event type:
Event_Type__c = 'Equity' AND CnP_PaaS_EVT__CheckIn_Status__c = 'Checked-In'
I'm having trouble figuring out the correct way to put these two items in the Relationship Criteria field in DLRS without having syntax errors. I need an "or," but I haven't found how to write that.
Thanks!