Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Question on automatically populating a user-defined field

Hello

I'm wondering if its possible to write a query that would automatically fill out a user-defined

field on a activity each time a new one is opened. When a sales rep starts a new activity

I want the field to be populated with their name.

Any help would be appreciated

thanks

Mike

Former Member
Former Member replied

Hello Mike,

If the Sales Person's name matches the User Name, then you could use the following query and assign it as a Formatted Search to your User Field.

SELECT T0.U_Name FROM [dbo].[OUSR] T0 WHERE T0.INTERNAL_K = $[USER]

Set the Formatted Seach to Auto refresh on Activity Type or Remarks or (any field that the user would certainly change)

Suda

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question