DB for Recipets

Rafael Sanchis

unread,

Jul 25, 2019, 8:29:57 AM7/25/19

to Sailforms Users

There are some DB for Recipets.? Appreciate.

MikeG

unread,

Jul 25, 2019, 3:00:19 PM7/25/19

to Sailforms Users

"Recipets" ???

Do you mean receipts (items/money received) or recipes (cooking instructions)?

Rafael Sanchis

unread,

Jul 25, 2019, 5:56:50 PM7/25/19

to Sailforms Users

Cooking

Bmw Contracting

unread,

Jul 26, 2019, 8:30:10 AM7/26/19

to Sailforms Users

I don't know if you are asking if if anyone here has created this or not, but if you find a .csv database online, (or make one) it is not hard to import it into a form.
Bruce

Rafael Sanchis

unread,

Jul 27, 2019, 4:27:17 PM7/27/19

to Sailforms Users

Hi I try develop a personal cooking database, now I have a form with all my ingredients, now I try to on another form for Recipets but how get multiple values in these form ? . The Recipets forms maybe have 6 or more ingredients.
Appreciate some help.

Bmw Contracting

unread,

Jul 27, 2019, 10:10:40 PM7/27/19

to Sailforms Users

Maybe if you post your group, it will give others a better idea of what you want to do.

MikeG

unread,

Jul 28, 2019, 4:38:22 AM7/28/19

to Sailforms Users

Hello Rafael,
You need a form with one entry per recipe, and a second form with an entry per ingredient per recipe. Then you can use a Remote Table to display your associated list of ingredients in the Recipe form.

I attach an example which also includes a second Remote Table listing the steps in the recipe. I've included one sample recipe selected semi-randomly from the internet - that is, selected to show features of the DB, not for its quality (though I'm sure it's very good!)

The database could be extended to, for example, automatically calculate the ingredient quantities for different numbers of servings, bit I'll leave that to you!

I think my example is error free, but no guarantees!!!

Mike

Recipes.sfg

Rafael Sanchis

unread,

Jul 28, 2019, 8:51:56 AM7/28/19

to Sailforms Users

Yes, Ok appreciate your help.

Rafael Sanchis

unread,

Jul 28, 2019, 11:06:33 AM7/28/19

to Sailforms Users

Yes now is working but the problem is that que table ingredients is not a normal form, is a lot of ingrediets repited but is working for me.
Thank

David Chesworth

unread,

Jul 29, 2019, 1:04:41 PM7/29/19

to Sailforms Users

Here an early alpha version of my CookBook, hope it gives you ideas for your own. The good thing about sailforms is that it let's you design your own database the way you want it to be.

CookBook.sfg

Rafael Sanchis

unread,

Jul 29, 2019, 3:12:37 PM7/29/19

to Sailforms Users

Appreciate David Thanks

Rafael Sanchis

unread,

Aug 4, 2019, 7:14:52 AM8/4/19

to Sailforms Users

Hi guy I have a question.

I have a Field called Unit in that field there are some choose option like Gr. Kg, Units etcs, but is I chooice units I need the other field like Price gr place 0

How I do that is posible some help appreciate.

Thanks.

MikeG

unread,

Aug 4, 2019, 4:16:54 PM8/4/19

to Sailforms Users

I think you are saying that when you give a value to field Unit or when you change its value then you would like the value of field Price to be set to 0.

If so, and if your Unit field is a Values (Listbox Math) field of type Text then in its On Change commands use the command:
Math Equation Price 0

Mike

Rafael Sanchis

unread,

Aug 4, 2019, 5:13:52 PM8/4/19

to Sailforms Users

Thanks Mike I will try

Reply all

Reply to author

Forward