Bill of Materials

[Gustavo_Eduardo]

Hello friends, I put them in context; I am trying to create an app for the gastronomic industry that allows me to know the ingredients of a product and, therefore, its cost. Suppose I am going to make a pizza for which I need a pre-pizza, a portion of sauce, and a portion of cheese. Now, the sauce is composed of tomato, oregano, salt. The cheese is previously bagged in portions, the pre-pizza is made with flour, yeast, salt and water.

I would like (in the end) that, when finishing a pre-pizza, the app tells me how much flour, yeast and salt to replace in the warehouse, since each preparation is supposed to consume inputs. This should be possible to execute in "n" levels, that is, an analysis of ingredients within another, because just as the pre-pizza has flour, water, salt and yeast, the pizza has a pre-pizza.

Is it possible to structure an app, with Appsheet, like that?

I thank you in advance for your answers.

[Marc_Dillon]

"Pre-pizza" lol! 

Anyways... I think I would possibly put all of your "items" (pizza,sauce,cheese,tomato,flour,etc) into one table.
Then in a 2nd table, combine the concept of "recipe" and "ingredient" into a single entity, where each record would reference an item, then optionally reference another record in its same table (as a parent "recipe") along with a quantity.
Then your cost calculation would be conditional, if [Related ...] isnotblank, [qty] * sum([related...][cost]), otherwise [item].[cost] * [qty].

[Gustavo_Eduardo]

First of all, thank you very much for your time and your answers. I will try to elaborate something with his ideas. As soon as I have news I will comment here, since it will be useful for the entire community. Regarding the title of the publication, I am going to change it to Bill of materials. Gracias @Marc_Dillon 

[Suvrutt_Gurjar]

This is a very broad based question.  So response is also broad based and just to share some relevant inputs.

It sounds that you are looking for a kind of BOM( Bill of Materials) application. If you search the internet by the key words "Bill of Materials", you will get lots of articles, general templates. You may want to refer those as guidelines and evaluate if and how you can fit into an AppSheet app.

Bill of materials - Wikipedia

Edit: If you search by "Restaurant Bill of Materials" , you will get articles on the BOMs for that industry also.

[Gustavo_Eduardo]

First of all, thank you very much for your time and your answers. I will try to elaborate something with his ideas. As soon as I have news I will comment here, since it will be useful for the entire community. Regarding the title of the publication, I am going to change it to Bill of materials. Gracias @Suvrutt_Gurjar 

[Gustavo_Eduardo]

Good Day Suvrutt_Gurjar

With this you want to tell me that no Appsheet is impossible to do BOM? I thank you in advance for the answer so as not to move forward with the proposal.

[Suvrutt_Gurjar]

Hi @Gustavo_Eduardo ,

No, I do not at all want to say that it cannot be made with AppSheet or it can be made with AppSheet. The feasibility will entirely depend on the complexity of requirements and whether those fall in AppSheet features. 

I meant , your questions is broad based and only a relevant suggestion to dig more or hint could be given in the community for you to evaluate.

[AleksiAlkio]

As Suvrutt explained, yes it's possible. I have made one app for that purpose. It has lot of tables but these 3 are relevant. Materials, recipes and ingredients. The material contains the Basic info, price, allergens, size convert, units etc.

The recipients table has eaters, cooking time, cooking steps, notes, total prices etc.

Ingredients table has materialID, qty, unit and notes. And the ingredients creates a list for the recipe.

When something is changed in the material like price, it reflects the recipe and its price automatically. Same with allergens etc.

So.. definitely doable.

EDIT: And the recipe can contain two other subrecipies as well.

[Gustavo_Eduardo]

Hello AleksiAlkio how are you, nice to write to you!

Yes, I have already done that and largely thanks to your idea. I just need to be able to create a report with a behavior action or something like that (thinking aloud). My idea is that I can create a report with a list of all the unique ingredients, that is, they are not repeated where they appear, depending on the units sold, the amount of supplies to buy or restock.

Maybe I don't think you have to make more tables than you tell me, but if the appsheet returns a CVS that has the information on the amount to be replaced in the warehouse.

Will this be possible through bots? or create CVS or fill tables automatically?
If so, are there tutorials to do it?
In Access there are reports and queries. How to make an equivalent in Appsheet?

[AleksiAlkio]

Yes you can do that. The best way is to do it from the Material table as it's a unique list already.

[AleksiAlkio]

The easiest method I have used with recipes.. have two tables, recipes and ingredients. First create the sub recipe in recipes table, then create the main recipe. Now add a Ref column in your Recipes table and make the reference to the same Recipes table.

Now when you select the sub recipe with your Ref field, you are able to count/sum the price for the sub recipe and combine it with the main recipe. Done that and it works. You probably need more than just one ref column as normally recipes are using more than just one sub recipe. Maybe two Refs would be enough.

[Gustavo_Eduardo]

First of all, thank you very much for your time and your answers. I will try to elaborate something with his ideas. As soon as I have news I will comment here, since it will be useful for the entire community. Regarding the title of the publication, I am going to change it to Bill of materials. Thaks @AleksiAlkio 

[AleksiAlkio]

You're welcome

[Gustavo_Eduardo]

I have been considering changing the approach. I am going to create a somewhat more powerful application but it should rely on external features. My idea is not to leave Google, but if I have to, I'll probably use Microsoft's power Query; I don't know yet, but as soon as I have any news, I'll come back here to tell you about my experience since they have taken care to answer me.

[yasarcan]

merhaba proje ne seviyede?