Auto populate Employee start date on a catalog item

[DeIvory Gordon]

Hello, I want to add an employee start date field to catalog item that auto populates when a field titled "Who is the user receiving the phone is filled in.  I added a variable titled "employee start date" to the catalog item, I made it type "reference" and I referenced my company's HR table.  I then went to type specification and entered the required info. lasty, I went to auto populate, but my dependent question "employee start date" is not available for me to select.  Please see the screen shot below of my steps.  Any help is greatly appreciated.

[Brad Bowman · Accepted solution]

If you want to auto-populate a variable named "Employee start date" when a variable named "Who is the user..." then the Dependent question on the Auto populate tab for the Employee start date variable is "Who is the user..." not the same "Employee start date" variable.  "Who is the user..." needs to be a reference type variable for this to work, but you probably don't want "Employee start date" to be a reference as this will populate/appear with the display value of the HR table, which is likely not a date, so try making it date, date/time, or string.

[svirkar420 · Accepted solution]

Hi @DeIvory Gordon , You want to populate the entered user's start date to the catalog item form when the user is selected right?

for this requirement you can use the combination of catalog client script and script include.

Catalog client script - for sending the logged is user's 'sys_id' as parameter to the script include.

Script include - Script include will glide to the user's table and query the record with 'sys_id' coming from the catalog client script and fetch the caller's start date field data and then send it back to catalog client script and then set that value to the field on the catalog item form using catalog client script.

Let me know if you need any further help.

If this response helps you mark it as accepted solution and give it a thumbs up 👍. This help me and community to find answers quickly.

Best Regards,

Saurabh V.

[Brad Bowman · Accepted solution]

If you want to auto-populate a variable named "Employee start date" when a variable named "Who is the user..." then the Dependent question on the Auto populate tab for the Employee start date variable is "Who is the user..." not the same "Employee start date" variable.  "Who is the user..." needs to be a reference type variable for this to work, but you probably don't want "Employee start date" to be a reference as this will populate/appear with the display value of the HR table, which is likely not a date, so try making it date, date/time, or string.

[svirkar420 · Accepted solution]

Hi @DeIvory Gordon , You want to populate the entered user's start date to the catalog item form when the user is selected right?

for this requirement you can use the combination of catalog client script and script include.

Catalog client script - for sending the logged is user's 'sys_id' as parameter to the script include.

Script include - Script include will glide to the user's table and query the record with 'sys_id' coming from the catalog client script and fetch the caller's start date field data and then send it back to catalog client script and then set that value to the field on the catalog item form using catalog client script.

Let me know if you need any further help.

If this response helps you mark it as accepted solution and give it a thumbs up 👍. This help me and community to find answers quickly.

Best Regards,

Saurabh V.

[yashkamde · Accepted solution]

Hello @DeIvory Gordon ,

There might required some changes in your setup,

Correct setup should be:

• Variable: Who is the user receiving the phone => type Reference
• Variable: Employee Start Date => type Date

Then you can select your Who is the user... variable for making start date auto populating :

If my response helped mark as helpful and accept the solution.