Getting Started

 View Only
  • 1.  Dynamic rules not working with Grid Edit

    Posted 10-06-2022 09:05
    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
    ------------------------------


  • 2.  RE: Dynamic rules not working with Grid Edit

    Posted 10-06-2022 09:07
    You will need to use a Pipeline to do this.

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



  • 3.  RE: Dynamic rules not working with Grid Edit

    Posted 03-01-2023 12:58

    Hi Mark,

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



    ------------------------------
    George Bramhall
    ------------------------------



  • 4.  RE: Dynamic rules not working with Grid Edit

    Posted 03-01-2023 13:57

    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
    ------------------------------