Trying to dot walk record producer variable in workflow

[josh_the_tech]

Hi,

I'm currently having an issue with dot walking in a workflow.

I've got a form for leavers, where they user types in the name. It references the sys_user table and has secondary lookup fields (name, user_name, employee_number) which allows the user to pick the correct leaver.

I then want to grab just the username and put it into a email message that goes to our automation system (ThinkAutomation) so it can expire the account. I can successfully expire the account but I can't get it to dot walk reference the username.

The field they fill in is called leavers_name and the field in sys_user I want to reference is user_name.

I've tried a combination of different variables I've seen when looking on the community but none have been successful.

The email is formatted as:

Username: ${current.variables.leavers_name.user_name}
Leave Date: ${current.variables.u_leavedate}

I've also tried ${current.variables.leavers_name.user_name.toString()} and I've also tried ${current.request_item.variables.leavers_name.user_name} to no avail.

If anyone can point me in the right direction, I'd be most grateful.

Thanks in advance!

Josh

[josh_the_tech · Accepted solution]

I've discovered the issue was that I was using a Lookup Select Box, rather than a Reference.

So to confirm, to dot walk, you must use a Reference box. Then you can use a normal variable like ${current.variables.leavers_name.user_name}

Thanks all for your comments and suggestions. I've put this in, in the hope others will benefit from it.