Discussions

 View Only
  • 1.  Delete parent record... ???

    Posted 11-07-2022 09:18
    Good morning. In a relationship there is table A(parents) and table B (childs) .

    Since my beginnings in quickbase I have question...

    ¿Why does quickbase allow you to delete records from table A regardless of whether it has a related child in table B?

    Marcelo Benavides Torres

    ------------------------------
    Marcelo Benavides
    ------------------------------


  • 2.  RE: Delete parent record... ???

    Posted 11-07-2022 09:25
    It's not really a valid question to ask.  It is just not an automatic capability that is part of the product features at this time.

    You can either use the feedback process to suggest an enhancement or post a question as to how you can adapt to this situation if you are looking to prevent allowing regular users deleting a Parent record when it has children.

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



  • 3.  RE: Delete parent record... ???

    Posted 11-07-2022 09:32
    Good morning Mr. Shnier.

    I think this is a valid question, in my 24 years of experience (software developer)  it is the first software I know of that allows you to delete parent records from an entity relationship schema.

    About looking for mechanisms to avoid this: I already did it, remove the options to delete all users and with URL - buttons and formulas I can control this situation (show or not a delete button for each record).

    Having the capabilities to do what I've just mentioned I don't think will diminish or validate my question.

    Thank you

    Marcelo Benavides Torres





  • 4.  RE: Delete parent record... ???

    Posted 11-07-2022 09:44
    Sorry, I was not trying to say that this would not be a useful feature.    I'm just saying that given that this forum is mainly used for a peer to peer help each other type forum, the knowledge of why or why not a  feature was build 20 years ago when Quickbase was invented is hard for us to answer.

    In my case I block delete for all regular non admin users.  Then a provide a checkbox to request deletion and have a Pipeline do the delete if there are no children.

    The other reason not to automatically block deleting a parent if there are children, is that there are use cases where the desired outcome is to delete the parent and its children automatically so as not to leave Orphans.  This can also be done with a Pipeline

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



  • 5.  RE: Delete parent record... ???

    Posted 11-07-2022 09:47
    Thanks Mr. Shnier, Just now I understand your comment, this is not the appropriate forum for that question.

    Thank you!

    Marcelo Beanvides Torres







  • 6.  RE: Delete parent record... ???

    Posted 11-08-2022 12:20
    Hi Marcelo,

    I think it's an interesting question, though actually in my usage I'm kind of glad that it doesn't work that way.  In my database we have a trio of tables: grandparent A, parent B, and child C, which are:
    A=Companies
    B=Contacts
    C=Notes. 

    We record Notes record that show on both the Contact and the Company record. When a Contact leaves a company, they get deleted because well, too many contacts clutter the search, etc.

    However we want to preserve the Notes from our interactions with that person on the Company record because they may be relevant to ongoing business activities.  So for us it is a good thing that we can delete that parent record (Contact) without deleting the child (Notes) which still appear on the grandparent (Company) record.

    I do understand however that in other situations it can be annoying because you would end up with orphan children. (That does also happen in our system in other areas which I need to do a better job of keeping track of, though it's less common.)

    ------------------------------
    Kim G
    ------------------------------



  • 7.  RE: Delete parent record... ???

    Posted 11-08-2022 12:32
    HI Kim... 

    It is an interesting example. 

     From the ACADEMIC: the record you are deleting "should" be left in an inactive status, so you never lose a parent's history.  

    I repeat that it is something strictly academic and how the college teach us to take care of information. 

     But the ambiguity of computer science remains: "if it works for you .... that's fine"

    Thank you

    Marcelo Benavides 





  • 8.  RE: Delete parent record... ???

    Posted 11-08-2022 12:39
    I would say this is a good question and a problem most Quickbase Admins/builders eventually face. There are no "before you start building there are a few things you should know" articles I am aware of that warn us to remove delete rights. This is one of those problems everyone will face and then come to their own conclusions on how to make it work. This design is an open architecture and preferred.

    It is nice to have the open design. It is not so nice to come in to work and find out that yesterday you deleted all the parents and now no one can see the children and now you have to put it all back etc. etc. this is not fun but a great way to never forget. 

    One last note, Quickbase does have a restore feature, so one can put it back to the previous nights backup. That is the extent of the granularity to restore. There are no transaction logs one can replay. 

    While you're paying attention, another thing to be aware of, once a record is deleted, you cannot ever get that record id back other than by a table restore. So if your record id is number 123 and you deleted it from the table, you will see record id 122 and then 124​. This subtle distinction becomes very important when working with related fields.

    Good luck Marcelo, good observation!

    ------------------------------
    Jim Harrison
    transparency = knowledge + understanding : The Scrum Dudes
    ------------------------------



  • 9.  RE: Delete parent record... ???

    Posted 11-08-2022 13:01
    Very good contribution. Thank you Jim

    Marcelo Benavides Torres