Make Changes to a thing - Inventory Application

bosunjohnson · February 12, 2019, 2:40pm

Hi Bubblers,
I am creating an inventory application that deducts data from the inventory when sales is made for different stores.

This is the flow.
I have a drop-down that picks it’s content (store-name) from the database.

I have a sales database with products and quantities sold.
I want when a quantity is enter and “sold” is clicked that the quantity in the sales database is reduced. That is if 25 cases is sold, it should deduct it from the inventory.

Please I my workflow.

I cannot seem to select the dropdown in the constraint dialogue.
I also dont know how to subtract the sales from the item in the database.

Please what can I do?

Thank you,

mebeingken · February 12, 2019, 4:09pm

Hey @bosunjohnson,

You haven’t really said what data type is being used for your dropdown, so I’m going to assume you have a data type established called Store…if that’s not how you’ve setup your system, just let us know what you’ve done there.

This is what your dropdown might look like:

And here is your workflow to subtract the quantity field:

Looking to accelerate your app development?

Let me turn

into

Development through Coaching at https://uniqueideas.com or schedule a free intro session

Ken Truesdale
LinkedIn

bosunjohnson · February 12, 2019, 4:20pm

Thanks for the prompt response @mebeingken.

For my dropdown, I am using data I got from the customer database to fill the dropdown

I cannot find the “Dropdown store’s value” in the constraint.

Where do I go from here?

Thanks again.

mebeingken · February 12, 2019, 4:38pm

The data type for Distributor Name needs to exactly match your dropdown “Type of choices”. My hunch is that your Distributor name data type (not its name) is currently set to be text, but it should probably be Customer. You can alter that kind of stuff on the Data tab.

bosunjohnson · February 12, 2019, 4:40pm

Yeah thanks. The distributor name data type is text. I will change it to customer and see how it works.

bosunjohnson · February 12, 2019, 4:45pm

sorry to bother you. I am just begin to get a hang on the bubble stuff.

I just created another field as “distributor name” with data type customer.
It now limit the options available. Please find screenshot.

mebeingken · February 12, 2019, 4:46pm

Give it a different name so you can ensure you are not selecting the old one. Also, there is a bug I’ve been noticing where all available options don’t always show up, so refresh the page to see if that helps.

bosunjohnson · February 12, 2019, 4:53pm

Thanks but it seems I’m missing something.

Please find screenshot.

mebeingken · February 12, 2019, 4:54pm

I’m jumping on a call with somebody, but if you post up screenshots of the relevant data types, I’m sure somebody will take it from here…otherwise, I’ll be back later.

bosunjohnson · February 12, 2019, 5:04pm

Alright. Please find link to the app here.

Thanks again!

mebeingken · February 12, 2019, 6:48pm

Hey,

It is working for me, which makes me think the refresh idea I mentioned earlier should help:

You would just select Dropdown Sales man I believe.

bosunjohnson · February 12, 2019, 8:01pm

Thanks a lot for the patience and help. This solved my problem.

I have never thought of using Customer or product as a data type. I never even knew it was possible.

Final question, how to I learn and use these type of data types(Users, Customer, Products) and when do I use it in my application. I may as well search for some tutorials on it.

I cannot enter any value in the “Name of distributor” field I have created in the database. It does not take any value I enter.