Forum Discussion

CarolMcconnell's avatar
Qrew Captain
2 years ago

Pop up Message when child is added and field on parent record changes

I have a situation where there are two tables and the parent table has two formula fields.  One counts the number of child records and when that number is 10 or above the other formula field changes ...
  • MarkShnier__You's avatar
    2 years ago

    Rather than a "pop up" what I suggest is to have a Rich Text formula field, which will show a message (perhaps large size font and red).,  You can lookup the current # of Children  and if it's already at 9 or above , then show a message in Add mode.  

    However, if you are adding children in Grid Edit mode, the "ask" becomes more difficult or perhaps not possible as the child record being added in Grid Edit mode do not get "counted" by the Summary Count field until they are saved.  But you can still have that big red message on the parent, but at that point the children will have already been created.

    Mark Shnier (Your Quickbase Coach)