Forum Discussion

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
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)
mark.shnier@gmail.com
------------------------------

BrianSeymour

Qrew Assistant Captain

2 years ago

Mark's suggestion is what came to mind for me too. Your parent table would summarize (count) the children. But then you'd pass that count back to the child table using a lookup field.

Then once the child has info about it's siblings, you could give the User a heads up when that page is loaded, such as when the count is 9 or more via a Form Rule. Oftentimes, I'll wrap this into a helper formula checkbox for Form Rule readability. Something like:

// Children::Should Show xyz Warning
If (
    [Parent - # of Children] > 8,
    true,

    // Default to unchecked
    false
)

Then leverage that in your Form Rules to display a section with a "Text" Form Element where the HTML (Limited) box is checked. Or a maybe a Formula Rich Text field.

I usually lean on Bootstrap's Alert component styling for this type of messaging.

<p style="
    background-color: #cfe2ff;
    border-color: #b6d4fe;
    border-radius: .25rem;
    border: 1px solid transparent;
    color: #084298;
    font-size: 0.875rem;
    line-height: 1.4;
    margin-bottom: 1rem;
    padding: 1rem 1rem;">
    This is an <b>informational</b> message!
</p>

Hope that gives you some ideas!

------------------------------
Brian Seymour
------------------------------

CarolMcconnell
Qrew Captain
2 years ago
Thanks Brian. I used your HTML and just change the colors.

------------------------------
Carol Mcconnell
------------------------------