Hi Jen,
I don't believe their is any combination of sharing that will allow that behavior, but our (unlisted) UberForm solution can do so, since (under the hood) it uses an API Key with elevated rights to perform the data entry. If you'd like to explore it further, I invite you to email me at doug.denhoed@atappstore.com.
Regards,
Doug