Hey, Interesting to know you are working on appsheet Apps. App sheet is great platform to create quick apps.
I understand your difficulty in table referencing, dynamic dropdowns and other small matters issues you have mentioned.
Having an experience to create more than 35+ Apps on appsheet, I would be very happy to help you in this regard.
I can show you my previous apps for reference.
let's discuss and start it soon. hope we will make a progressive start soon.
Thanks.