Alter Database Field to Allow a Recipe to Have More Than One Category

[zombiewoof]

If the database, that is used, allows something like MySQL 'LIKE', it would be nice to be able to associate more than one category with a recipe. For example, I have a Chicken Soup recipe that is prepared in a crock pot. It would be convenient to have the recipe listed in Poultry, Soups, and Crock Pot instead of having to pick just one category.

[thinkle]

Recipes already can have more than one category :) Looks like there was no slick widget for doing a multi-pick, so it's just comma separated at all (which means a category can't have a comma in it). Tom

…

On Tue, Oct 13, 2020 at 12:26 PM zombiewoof ***@***.***> wrote: If the database, that is used, allows something like MySQL 'LIKE', it would be nice to be able to associate more than one category with a recipe. For example, I have a Chicken Soup recipe that is prepared in a crock pot. It would be convenient to have the recipe listed in Poultry, Soups, and Crock Pot instead of having to pick just one category. — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#1008>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAELYW5R2XAB5B3EFPRLEZTSKR5R3ANCNFSM4SPGULYQ> .

[zombiewoof]

Maybe clicking category input could open a window, with the categories listed and a checkbox for each one? Already chosen category(ies) already checked.

[zombiewoof]

I have worked up a screen, in PHP, to illustrate the window I mentioned in my earlier comment. I realize that this probably can't be done with a widget, but shouldn't be too complicated to implement.

The 'New Category' input could be allowed to accept the currently used CSV-type input to add more than one new category or add categories to the chosen ones. Parsing of the input should check against the existing list of categories to prevent duplication - found item(s) should be added to the chosen categories for this recipe, as would any new category(ies) added.

[thinkle]

Yes -- I'm not too likely to work on the GTK side of things but others are welcome too. Here's how it's currently implemented in my web-based prototype -- a type/dropdown combo + a tags interface. [image: image.png]

…

On Mon, Nov 2, 2020 at 4:54 PM zombiewoof ***@***.***> wrote: I have worked up a screen, in PHP, to illustrate the window I mentioned in my earlier comment. I realize that this probably can't be done with a widget, but shouldn't be too complicated to implement. The 'New Category' input could be allowed to accept the currently used CSV-type input to add more than one new category or add categories to the chosen ones. Parsing of the input should check against the existing list of categories to prevent duplication - found item(s) should be added to the chosen categories for this recipe, as would any new category(ies) added. [image: Screenshot from 2020-11-02 16-42-17] <https://user-images.githubusercontent.com/4460090/97922574-b1938880-1d2a-11eb-8998-a0ef161257b8.png> — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#1008 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAELYW4INBMSDIMHVKVO6P3SN4TDFANCNFSM4SPGULYQ> .