could someone know any formula can ID to full name from Inquiry
Answer
Inquiry name showing
Best answer by pandachan48
Hi
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.
Hope this help!!
Any formula to set on inquiry to show full name? I don’t know how to edit in database.
+19Hi
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.
Hope this help!!
Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
Hi
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.
Hope this help!!
Any formula to set on inquiry to show full name? I don’t know how to edit in database.
+19As 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?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.