Skip to main content
Solved

Inquiry name showing

  • 19 May 2021
  • 4 replies
  • 167 views

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

 

 

 

 

4 replies

Naveen Boga
Rank
Userlevel 7
Badge +19

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!!

Naveen B
pandachan48
Rank
Userlevel 2
Badge

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.

Naveen Boga
Rank
Userlevel 7
Badge +19

@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.

 

Naveen B
pandachan48
Rank
Userlevel 2
Badge

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

Reply


Terms & ConditionsCookie settings