How should I do?

[anonymous]

Hi everyone, I hope everyone is doing great.

I’m trying to use AppSheet to make thing faster for company I work. First I wanna let you know how we are doing now. We are a candy shop company runs multiple locations in different states and we have different partners for different locations some partners own multiple locations. I want to make an app to order candies. Right now we use some google sheets sheets to order candies.

Screen shot bellow show our order sheet. We only change “E” column.

Is there any way to make an app user logins to app and starts ordering candies for their locations. I tried to use reference tables for locations and users but I don’t know where I’m missing something.

I’m new in appsheet but I’m very familiar with google sheets, where should I start to do something like this

[Suvrutt_Gurjar]

Welcome to the AppSheet community!

As a very rough reference and a purely as a starting point, you can take a look at the below sample app. Partners in your case can be equivalent to Customers in the sample app. The sample app has also a table for products.

However, please do note the disclaimer that your question is very broad-based. Typically the community answers questions on expressions or such specific points. Your exact app design will depend on many finer details. So the referred app is just as a possible starting point. Please do not take the approach in the sample app as the only and final approach. Please thoroughly evaluate all the other options at your end.