Forum Discussion

ConsueloViramon's avatar
ConsueloViramon
Qrew Member
3 years ago

Dynamic rules not working with Grid Edit

Hi there!

I have a  [Assigned to] user field, I have another field [Assigned To Converted to Text] which converts to text the [Assigned to] field. I also have a [Most recent Assigned to] text field (this filed appends information and with user and timestamp).
Then I have a rule that "When [Most Recent Previous Assigned to] is not equal to the value in [Assigned To Converted to Text], change [Most Recent Assigned to] to the value in [Assigned To Converted to Text]". 
The idea is to track changes in time of the [Assigned to] field.
My problem is that when I do a bulk update of the [Assigned to] field using Grid Edit, the rule doesn't work the field [Most recent Assigned to] does not update. 

How can I solve this?  Thank you in advance for any help!




------------------------------
Consuelo Viramonte
------------------------------
  • You will need to use a Pipeline to do this.

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • GeorgeBramhall2's avatar
      GeorgeBramhall2
      Qrew Cadet

      Hi Mark,

      Any indication from QuickBase that at somepoint dynamic rules will work in Grid Edit mode?



      ------------------------------
      George Bramhall
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend

        No, I've never heard if that being in a development road map. It's probably not technically feasible as that processing happens in the Browser, and that's probably impossible to do with hundreds of records at the same time. 



        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------