Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Parse 3 letters form 2 fields and 2 portals


bigzilla
 Share

Recommended Posts

I have a CustomerName portal and a CustomerInfo Portal on the same layout. What I want to do is this.

 

In the CustomerInfo portal I want a new field called “Together” and I want it to contain the first letter of the CompanyName and the first two letters of a field called CompanyEct that are both in the CustomerName portal.

 

So if the CompanyName field says,

 

“Porter Foods Corp” and the CompanyEct field says “Mostler”,

 

the new field will read “PMO”!

 

How would you do this?

 

Thanks for your help,

 

Bill

Link to comment
Share on other sites

To give you the best answer, we would need to know what relationships you have set up between the various tables.

 

To do what you want, you need a relationship between the CustomerName and the CustomerInfo tables. In the CustomerInfo table, you create a calculation field something like:

 

Left(CustomerName:: CompanyName; 1) &

Left(CustomerName:: CompanyEct; 2)

 

But you would need to use your actual table occurrence names which you have not provided.

Link to comment
Share on other sites

Hi David,

 

I can see that I need to give you more information.

 

The CompanyName and CompanyEct fields are in the table called [Customer].

 

On my layout, the CompanyName field and the CompanyEct field are in the portal called Detail_CustomerName.

 

I have another Portal called Detail_CustomerInfo which Is where I need the new calculation to reside. Detail_CustomerName and Detail_CustomerInfo are not related to each other but they are both related to the [Customer] table by CustomerID.

 

From your post I set up a calc field as follows and put the filed in my Detail_CustomerInfo portal but it does not work.

 

Left(Detail_CustomerName::CompanyName; 1) &

Left(Detail_CustomerName::CompanyEct; 2)

 

Any additional help you can give me will be most appreciated.

 

Bill

Link to comment
Share on other sites

More confused!

What table is the main layout based on? (where the portals are)

What table is the table occurrence Detail_CustomerInfo based on?

What table occurrences have you set up and what are the relations between them?

Link to comment
Share on other sites

 Share



×
×
  • Create New...

Important Information

Terms of Use