Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Populating a custom ta...
Microsoft Dynamics GP (Archived)

Populating a custom table on employee creation

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Is it possible to create a custom table with Dexterity (or another tool) that will be populated with default data for each employee when the employee is first entered into the system?  

A little background information.  I'm trying to create a custom table for our HR department to track certain forms that are required to be signed and returned by employees.  Most of them are simply one time new hire forms while others are quarterly or annual.  I need all the forms to be set in the custom table with default data when a new employee is created in Dynamics.  That way I can create a smart list for HR to run regularly that would should which employees have outstanding forms.  I have no idea how to get started on this.  Any help or insight is greatly appreciated.

*This post is locked for comments

  • Thomas Franz Profile Picture
    Thomas Franz 1,105 on at
    RE: Populating a custom table on employee creation

    My pleasure. That seems like the most straight forward implementation. Glad I was able to help!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Populating a custom table on employee creation

    I ultimately accomplished it using a SQL database trigger every time a new record was inserted in the employee master table. It was just easier for me to use SQL then Dexterity since I'm more familiar with SQL.  Thanks for giving me the idea I didn't even think about a SQL trigger when I was trying to solve this.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Populating a custom table on employee creation

    Thanks for the response Tom.  I was digging around in the documentation last night and saw the Trigger_RegisterDatabase.  I'm going to give that a try today.  I'll let you know how it goes.

  • Verified answer
    Thomas Franz Profile Picture
    Thomas Franz 1,105 on at
    RE: Populating a custom table on employee creation

    There are a couple different options depending on the requirements.

    You could use Dexterity to add a database trigger to the employee master table. Within the trigger handling procedure, you can add code to populate your custom table. Conceptually, you could build a window on top of your custom table to allow the user to view/edit the data.

    In a similar vein, you could add a SQL database trigger to function in a similar fashion as the Dexterity database trigger.

    Hope this helps get you started. If you don't have experience in this area, we do this type of custom work on a regular basis. Please feel free to reach out if I can assist further.

    Tom Franz

    Integrity Data, Inc.

    217.689.4658

    tfranz@integrity-data.com

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans