I’m trying to find a way to see if a long text field contains what’s in a single line text field from another table on the same base? For example, Table A has a list of different ingredients (one per record), and Table B has a list of recipes with all ingredients that are needed for each recipe in a long text field. I’m trying to automatically see if one of the ingredients on Table B is part of the single line text field ingredients on Table A, then maybe use an IF formula to create tags and tell me how many we have vs we don’t have. Ideally all this would happen automatically when we add a new recipe/record, since I’m using image to text to grab all the ingredients quickly and won’t be selecting one by one of the ingredients of Table A.
Is there a way to see if the list of Ingredients from Table B contain the Ingredients from Table A? Would I need to first break the list of ingredients into single ingredients by separating through a comma or something like that? I’ve been reading different articles on Lookup fields and formulas all week but I haven’t been able to find a solution that I feel is staring right at me.
Thank you so much for your help!