Forum Discussion
OK, so to be clear about what we are trying to solve for is that unfortunately at this time New Style forms does not allow for child records to be added in Grid Edit mode without forcing to the user to manually select the Parent in Grid Edit. In Legacy forms, one can create Grid Edit (connected) Children either in Add Mode or in Edit Mode.
The ask is therefor to be able to create a button in Add Mode (but which will also work in edit mode) which will auto save the Parent and re-display the newly created record on an alternate "Legacy style" mini Grid Edit form, so children can be auto attached.
We will need to use a formula Rich text field (not formula URL).
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Mark,
This was perfect!! Love it.
Thanks!
------------------------------
Deepa Prashant
------------------------------
- DeepaPrashant19 months agoQrew Cadet
Hi Mark,
What you suggested is working beautifully but now I need a creative solution for confirming if each line in this embedded report that you helped me design above has a checkmark against a column called "Ready for processing." This checkbox field triggers a set of rules in the table and ensures that required fields are filled in etc. So I need each line in this embedded report to have a checkbox before they can continue to process the report and send it for approvals.
Any ideas of how I may achieve that?
So in the record above - Asset Capitalization request #27 has a number of assets that need to be capitalized - shown in the report to the right. You can see that I was playing with Line # and counting the number of checkboxes with "True" for "Ready for processing."
"Ready for approvals" in the 2nd section in the form should be editable only if each line in the report has "Ready for processing" checked. how do i confirm that?
Thanks!!
deepa
------------------------------
Deepa Prashant
------------------------------ - MarkShnier__You9 months ago
Qrew Legend
You can make a summary field of the # of children and another summary field of the # of children ready for processing.
Then you can have a form rule that when the # of children is ready for processing is >0 and the # of children = # of children ready for processing, then allow Ready for Approvals to be editable.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------ - DeepaPrashant19 months agoQrew Cadet
Duh! I must have been tired last night. That's such a simple solution.
Thanks Mark!
------------------------------
Deepa Prashant
------------------------------ - MarkShnier__You9 months ago
Qrew Legend
OK, great. I should have also mentioned of course that the summary fields will not see your data entry if it's being done In Grid Edit until the record (and hence its children in the grid edit data entry area) is saved.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------ - DeepaPrashant19 months agoQrew Cadet
That's not a problem. Already configured and the app is looking pretty cool and slick. Thanks Mark!
------------------------------
Deepa Prashant
------------------------------