Can Assign People workflow add "current user" to contact cell in the Actions?

Susan Vieira

I would like to automatically populate a Contact Cell Column (called Associates) with the current user when they fill in a row. It does not seem possible and I am wondering if I am missing something. My workaround is using a fx in my contact column that basically says =[Modified by]@row.

But I'd prefer an automation if I could since my workaround populates my Associate cell with email address and I prefer to see person's name. Not a huge deal, just wondering if it was possible. Thanks!

Andrée Starå

Hi @Susan Vieira

I hope you're well and safe!

Unfortunately, as far as I know, it's not possible now, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

Here's a possible workaround or workarounds

• Please have a look at my post below with a method I developed.

More info: 

Lock or Store Date/Value Solution without using Zapier

Andrée Starå

May 24, 2020

Hi all,

I hope you're well and safe!

I've developed a solution that lets you store the date or value.

You'd use the copy-row automation and a VLOOKUP or combination of INDEX/MATCH to make it work.

We'd trigger the copy-row to another sheet and get the created date/other value and then use the VLOOKUP/INDEX/MATCH to get it back to the main sheet in another so-called helper column. As long as you have a unique id/value that we can use, it will work.

Also, this opens up more options with auto-numbering and similar.

Depending on other workflows, you could reuse one sheet for multiple workflows.

I hope that helps!

Let me know if you have any questions!

Stay safe and have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

---

View Post

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Susan Vieira

I hope you're well and safe!

Unfortunately, as far as I know, it's not possible now, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

Here's a possible workaround or workarounds

• Please have a look at my post below with a method I developed.

More info: 

Lock or Store Date/Value Solution without using Zapier

Andrée Starå

May 24, 2020

Hi all,

I hope you're well and safe!

I've developed a solution that lets you store the date or value.

You'd use the copy-row automation and a VLOOKUP or combination of INDEX/MATCH to make it work.

We'd trigger the copy-row to another sheet and get the created date/other value and then use the VLOOKUP/INDEX/MATCH to get it back to the main sheet in another so-called helper column. As long as you have a unique id/value that we can use, it will work.

Also, this opens up more options with auto-numbering and similar.

Depending on other workflows, you could reuse one sheet for multiple workflows.

I hope that helps!

Let me know if you have any questions!

Stay safe and have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

---

View Post

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Susan Vieira

Thank you. I've sent the request.

Andrée Starå

@Susan Vieira

Happy to help!

I haven't received anything. Can you double-check?

Susan Vieira

The enhancement request? How can I double check?

Andrée Starå

@Susan Vieira

Apologies, I confused you with someone else where I answered about sharing an example.

Susan Vieira

No worries!! Have a great day!