Forum Discussion
QuickBaseCoachD
7 years agoQrew Captain
OK, i did not know that the data entry method was Grid Edit.
I think a decent workflow would be to have the user create the request and select the test category and save,
Then the user would click a button to ADD tests. That button would have a URL to add 10 records. (I can help you with that but its just somethng like this.
$ADD
& "&rdr=" & URLEncode($ADDADD )
& URLEncode("&rdr=" & URLEncode($ADDADDURLThree))
& URLEncode(URLEncode("&rdr=" & URLEncode($ADDADDURLFour)))
& URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($ADDADDURLFive))))
& URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($ADDADDURLSix)))))
& URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($ADDADDURLSeven))))))
& URLENcode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($ADD)))))))
& URLENcode(URLENcode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($ADDURLNine))))))))
& URLENcode(URLENcode(URLENcode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($ADDURLTen)))))))))
& URLENcode(URLENcode(URLENcode(URLENcode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($EDIT))))))))))
So the URL will add 10 records and then edit the parent record.
Then you can have an Automation run maybe when a child is saved but was blank for the test, so delete those unneeded of the 10 records.
I think a decent workflow would be to have the user create the request and select the test category and save,
Then the user would click a button to ADD tests. That button would have a URL to add 10 records. (I can help you with that but its just somethng like this.
$ADD
& "&rdr=" & URLEncode($ADDADD )
& URLEncode("&rdr=" & URLEncode($ADDADDURLThree))
& URLEncode(URLEncode("&rdr=" & URLEncode($ADDADDURLFour)))
& URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($ADDADDURLFive))))
& URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($ADDADDURLSix)))))
& URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($ADDADDURLSeven))))))
& URLENcode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($ADD)))))))
& URLENcode(URLENcode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($ADDURLNine))))))))
& URLENcode(URLENcode(URLENcode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($ADDURLTen)))))))))
& URLENcode(URLENcode(URLENcode(URLENcode(URLEncode(URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($EDIT))))))))))
So the URL will add 10 records and then edit the parent record.
Then you can have an Automation run maybe when a child is saved but was blank for the test, so delete those unneeded of the 10 records.