MikeTamoush
2 years agoQrew Commander
Ideas when filling out a form and using a child table
I have always struggled with the following, and wonder what creative solutions people have come up with.
When building a form, say an equipment request form, the user would fill out some typical info, and then need to create a list of equipment to request. The best practice way for this is to create a child table. Here are the issues I run into when trying to use a child table in a form:
- Editable Report Links would be the perfect solution, except for the terrible interface where when you double click on cells, particular the very right cell, you don't really 'see' the entire selection. You always end up scrolling the report link to the right etc. It's particularly wonky when the far right column is a drop down selection. Any way to combat this awkwardness?
- Alternatively, could just use the 'Add Child Record' button. Works, but not super user friendly as they have to hit 'save and next' until they are done. Additionally, they need to figure out how to delete the child record if they decide they don't want it, which isn't necessarily intuitive for non QB users or for users who rarely use QB. Additionally, if ever on mobile, you need to have the record saved first to see the button, or create a custom rich text button.
- If I have say, 10 or less items that could be chosen, just create a bunch of fields on the parent and use dynamic form rules to keep showing them as the user fills in the prior. This works well, but if I have description fields etc, could result in a lot of fields. This wins for user friendly, but loses for best practice in a build.
I suspect if I knew coding, I could design something with a code page, but that is beyond my capabilities. Anyone else come up with a creative solution?
------------------------------
Mike Tamoush
------------------------------