Skip to main content

could someone know any formula can ID to full name from Inquiry

 

 

 

 

Hi @pandachan48,

We can not get the full name directly, as this user-defined field value only stores the ID in the database. Please find the screenshot for reference.

In order to get the Name, you need to join with the proper table. I just ran the sample example for the Customer ID.  Please find the details below.

 

Added UDF for Customer ID
Only stores ID, but not the name
I have added extra join with BAccount table to fetch the name

 

UDF: Customer ID and Customer Name

 

 

Hope this help!!

Hi @pandachan48,

We can not get the full name directly, as this user-defined field value only stores the ID in the database. Please find the screenshot for reference.

In order to get the Name, you need to join with the proper table. I just ran the sample example for the Customer ID.  Please find the details below.

 

Added UDF for Customer ID
Only stores ID, but not the name
I have added extra join with BAccount table to fetch the name

 

UDF: Customer ID and Customer Name

 

 

Hope this help!!

 

Any formula to set on inquiry to show full name? I don’t know how to edit in database.

@pandachan48 I don’t think we can using formula.

As I said, you need to with BAccount table and get the Customer Name just like below.

 

Any Formula can we put here(Style) to show full of the name? 

Reply


Terms & ConditionsCookie settings