Forum Discussion

JonFroderberg's avatar
JonFroderberg
Qrew Cadet
4 years ago

Unable To Create New Child Records In Grid-Edit

We have a table structure as follows: (Job) is a parent to both (Phase Codes) and (Estimates).  (Estimates) and (Phase Codes) can both have many (Estimate-Phase) records. After a minimum of ...
Grid edit
Relationships
JonFroderberg's avatar
JonFroderberg
Qrew Cadet
4 years ago
I have submitted this item to Quickbase tech support (Ticket 672648), and have learned that this is a known issue with the platform with an existing escalated Quickbase ticket.  When I get that ticket number I will append it to this post.

------------------------------
Jon Froderberg
PRIME Developer
Harder Mechanical Contractors
https://www.harder.com
Portland, OR
801.946.0576
------------------------------
Melissa_Doran's avatar
Melissa_Doran
Qrew Cadet
4 years ago
I have run into this issue before. My workaround was to create blank rows via pipeline (other than the relationship field - it would be filled in) ahead of the time that the user would be filling in on the grid. Once the record exists and is related to the parent, conditional dropdowns work in grid edit. In my case, it was for timesheets so it was simple enough to have the blanks ready before user interaction. There was a pipeline running weekly to remove the blanks once users were done interacting with that timesheet-week. It may be trickier if the users are intending to use the grid while adding a new parent record or immediately after adding one.

------------------------------
Melissa Doran
Jr Solutions Consultant
Quandary Consulting Group

linkedin.com/in/melissardoran
mdoran@quandarycg.com
------------------------------
  • JonFroderberg's avatar
    JonFroderberg
    Qrew Cadet
    4 years ago
    Thanks Melissa!  I appreciate your suggestion!
    Our workflow has the user creating these records on-demand and they would need to be able to create the child records as-needed.  I'll describe the workaround that Stanley came up with in a separate post to the main thread.

    ------------------------------
    Jon Froderberg
    PRIME Developer
    Harder Mechanical Contractors
    https://www.harder.com
    Portland, OR
    801.946.0576
    ------------------------------
    • DevQuandary's avatar
      DevQuandary
      Qrew Trainee
      4 years ago
    • Melissa_Doran's avatar
      Melissa_Doran
      Qrew Cadet
      4 years ago

      Awesome, I'll be on the lookout for that post.

      I'd love to see other solutions to this problem as it seems to crop up fairly often for me. 



      ------------------------------
      Melissa Doran
      Jr Solutions Consultant
      Quandary Consulting Group

      linkedin.com/in/melissardoran
      mdoran@quandarycg.com
      ------------------------------