Pulling select data based on previous conditions

Hello all,
I have been using the Glide app for around 24hrs so just getting to terms with it. So far so good

The query i have is the following

I have 2 stores who sell the same products but make 2 different profits
Product is identified by a SKU code

I am using a form by the sales staff to log their sales.
However what i would like to happen is the form auto populate the Revenue made, based on the sales staff selecting which store they work in and the SKU entered

I have a sheet which has all the sales date ( item, description , monthly fee ) and there is a column each each store.

My question is this possible?
I have attached a few images to hopefully help explain.
Thanks in advance for your help


This is how the app looks,
Ideal plan is once Store is selected it will put in the Value under that store name

The form is perfect for that you can populate automatic data that comes either from the user or from the store (revenue made, specific profit margin, etc …).
To do so in the form when you press the + button you have to select either the data from the screen columns or/and from the user.
The trick is to get the get the right screen column datas and to achieve that, place your form button in the right spot in the app or get the datas you need through relations and Lookup.
Let me know if you need further explanations.

If each sale here is uniquely identified by a combination of Store and SKU, then you can:

  • Create a relation in the Sales table, relate the SKU submitted to the SKU table. This should be a single relation.

I assume the image above is your SKU table and SOC Code is the SKU.

  • Use two lookup columns to return “Ashton” and “Hyde”, which I assume are two values that represent the revenue based on the store name.

  • Create a final If Then Else column in the Sales table to represent the revenue. If Store is “Ashton” then return the “Ashton” lookup, else the “Hyde” lookup.


Thank you very much for your reply. I will work on trying to get this set up.

Many thanks

1 Like

Let us know if you need any further help!