Forum Discussion

AdamKrzyzanek's avatar
AdamKrzyzanek
Qrew Captain
2 years ago

Prevent from Adding & Removing record when Parent table condition Met

I have Parent Table (CM) where in Form I have imbedded child table record (CM CI Pair) to add data. I want to prevent users at certain point (when Status change to "Approved" to not be able to add n...
CHILDREN
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
2 years ago

I think the challenge here is that the Add Record is being done in Grid Edit.



------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
joevandervest's avatar
joevandervest
Qrew Cadet
2 years ago

ah.. sorry. I missed that entirely.  So yeah - Pipelines seems to be the "best" way to fix it - though preventing it prior to save... is another thing entirely. 

You could also send the "offending" user an email at the tail end of the pipeline - though it's probably more hassle to setup - but it might be worth it. Or - what about blasting the user a CHAT via a chat interface - e.g. "Hey, you can't add or delete items from 'X' !  " 



------------------------------
joe vandervest
------------------------------