Current User Question

Question

Let me set the scene before starting.&nbsp; I have a form with sections that each have a status, last modified on and last modified by fields.&nbsp; There is a form rule to set the last modified by field to the current user when the status changes.&nbsp; This form rule is working some times but not working other times.&nbsp; Why isn't the last modified by updating correctly every time?&nbsp; Could it be caused by more than one user editing the record at the same time?------------------------------Paul Peterson------------------------------

markshnier__you · Answer

if you are talking about the native [Last Modified field] I don't believe you can have a form rule affect that "built-In" field. it is set according to the user which last modified that record or by which owner of an Automation or Pipeline which modified the record..

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

paulpeterson1 · Answer

No, this is not the native field.&nbsp; Each section has it's own field to track the Last Modified By Service X, Last Modified By Service B, etc. field that the form rule is updating with the current user.------------------------------Paul Peterson------------------------------

markshnier__you · Answer

How does your form rule read?&nbsp; Can you post a screen shot?------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

michaeltamoush · Answer

Two other things that could contribute:1. Is the status field a formula? If so, just because the status changes, the dynamic rule won't fire until the record is opened and fulfills the conditions.2. Can someone be changing the status in grid edit mode? Dynamic rule won't fire in that case.------------------------------Mike Tamoush------------------------------

paulpeterson1 · Answer

Mark,Here's a screenshot:Mike,&nbsp;The Status field is a Drop Down and no, grid edit is disabled in this table.&nbsp; I have mentioned this table in several other posts.&nbsp; This form has more form rules than I care to admit due to the automation requested by the end user.&nbsp; Initially the last modified by and on fields were updated with an automation.&nbsp; I went with the form rules because the notifications were not triggering correctly.------------------------------Paul Peterson------------------------------

Forum Discussion

Current User Question

Related Content

Form Rule Question

Jinja Question: Adding business days to today

Chart Question

Questions & Checklist setup

iframe header question