Question for expression in attachment

[hellomotto]

Hi All,

I have a system where user can ask for employee certificate, I have a tab called employee info which is just a reference table contain all employee information  (no action), a tab for form and several reference tab.

I am trying to extract what user have filled out in form on attachment sending to user, this is what I have tried and failed <<[employee info].[original hire date]>> still doesn't work the error from automate is: '[employee info].[original hire date]' is invalid due to: Unable to find column 'employee info'

What should be the expression here? 

Thanks in advance!

[Vincent_P · Accepted solution]

Hi

The bot is fired by a row table. Is [employee info] a ref of this table ? 

I suppose bot is fired when you save your form (update), so it may be [ref of employee info].[your column]. If it's not work, you can use a select or lookup function.

[Vincent_P · Accepted solution]

Hi

The bot is fired by a row table. Is [employee info] a ref of this table ? 

I suppose bot is fired when you save your form (update), so it may be [ref of employee info].[your column]. If it's not work, you can use a select or lookup function.

[hellomotto]

thanks! I use the lookup function. So on my employee info table there is a column name original hire date which is formatted as 1-Jun-20, when I use the extression [original hire date], the result is 6/1/2020 12:00:00 AM, how can I formatted as June 01, 2020. I try TEXT([original hire date],"mmmm dd, yyyy") still doesn't work. 

[Vincent_P · Accepted solution]

Is your column typed as text ? If it's right, try to convert it as date and then use text function with format.

Maybe you can have problem due to locale.

My advice, always store date as date type, for working easily on it, text are only for views after a convert

[hellomotto]

Thanks @Vincent_P !