From Help Zapier / google sheets

I need some help, currently developing my first application. Fairly tech savy, just finding a roadblock for what I am trying to do.

overview the app is used for data collection… this form is essentially an alternative for google forms. The information recorded is for sales people when they make a sale to spiff them as well as keep them engaged. My form needs a couple items

Invoice number (user input)
I have 16 items that we sell and will spiff on I would like to either have a drop down that they click on each item they sold or a slider bar toggle. I need an input for the sale price on the right side. in different markets our product is priced differently.

I also want this to push to forms, or sheets, or airtable (not using it yet)

I set up a Zapier, I have a zap that works but does not work the way it really needs too.

please see this photo. This is what I am trying to capture I am trying to get this on a single sheet… or better yet. Each Alias has its own sheet. Not sure what the best method is…

Open to price quotes. Honestly dont want to have someone do it for me. I would rather learn and I am happy to pay a coach. Thank you.

I think I can help. But I need to understand something in detailes. Tell me please in what way can we discuss it?

Hi Dan,
If you are still on the lookout for some help I would be glad to help you out, as what you are wanting done is well within my area of expertise.
You can reach me on
Cheers and Have a great day ahead,

Hi Dan,
I believe I have the right expertise to help you launch what you want.
Happy to hop on a Zoom call and discuss You can reach me at
Cheers and Have a great day ahead,
sahira mehta