Passing current user through an action
I have a formula user field that is a simple User() to determine who is currently signed in. I have an action that is triggered and I want this value to be passed through the action. The issue is the ...
Forum Discussion
Mark:
A huge thank you for your clever work-around here using the [Last Modified By] user value on the original record that triggered the action! I just got off the phone with Dan G at QuickBase support. The issue here is that currently (Dec 7, 2017) the User() function is not supported in webhooks and actions. They don't have an ETA on when they are going to fix this, but there are now two cases (including mine today) that are logged and attached to their developer queue request to fix this.
Dan had mentioned that there were no known work-arounds until I googled and found this forum question and then pointed out to him that you offered what looked to me to be a great work-around. I just tested your approach, and it works like a charm. It won't help with the fact that the [Record Owner] and the [Last Modified By] of the record that gets added by the Action are still going to be wrong and always listed as me, the creator of the Action, but my Action will now fill in the current user correctly for the Timesheet records that I'm creating on the fly in a 1-step process when the Activity records are updated by the user. Thanks again.
Michael
A huge thank you for your clever work-around here using the [Last Modified By] user value on the original record that triggered the action! I just got off the phone with Dan G at QuickBase support. The issue here is that currently (Dec 7, 2017) the User() function is not supported in webhooks and actions. They don't have an ETA on when they are going to fix this, but there are now two cases (including mine today) that are logged and attached to their developer queue request to fix this.
Dan had mentioned that there were no known work-arounds until I googled and found this forum question and then pointed out to him that you offered what looked to me to be a great work-around. I just tested your approach, and it works like a charm. It won't help with the fact that the [Record Owner] and the [Last Modified By] of the record that gets added by the Action are still going to be wrong and always listed as me, the creator of the Action, but my Action will now fill in the current user correctly for the Timesheet records that I'm creating on the fly in a 1-step process when the Activity records are updated by the user. Thanks again.
Michael
- Are there any updates on this topic since 2017, or do we still use Last Modified By workaround? Does the Last Modified By field update as soon as the record is opened in edit mode, or does it have to be saved first? If it has to be saved first, I'd imagine this workaround would result in a 'lag'..?
------------------------------
Chelsea Carpenter
------------------------------- There is no "lag". The record is saved and the Automation is triggered immediately. I'm not sure of your use case, but the Automation can grab the [Last Modified by] of the real person who triggered the Automation by an edit and write it somewhere.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
