Forum Discussion

ConsueloViramon's avatar
Qrew Member
2 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

3 Replies

  • You will need to use a Pipeline to do this.

    Mark Shnier (Your Quickbase Coach)
    • GeorgeBramhall2's avatar
      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
        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)