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
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
------------------------------