Hey Everyone, Pretty new to filemaker so this idea could be way over my head/not possible.

I have a portal that displays two fields "ingredient Name" and "Qty Used". A typical portal looks something like this

Ingredient #1 ----> 50 Units

Ingredient #2 ----> 30 Units

Ingredient #3 ----> To Wet

Ingredient #4 ----> Qs to 100 Units

I am looking for a way to "tag" any ingredient that has "To wet" or "Qs" in the Qty Used Field. The reason i need something like this is because I track each ingredients inventory level. As you can imagine it is pretty hard to track inventory for amounts such as "to wet", so I am looking to tag any ingredients with this designation perform a calculation and then the calculations result will be taken off inventory. Is this sort of idea possible or am i heading out into left field?

Hey Everyone, Pretty new to filemaker so this idea could be way over my head/not possible.

I have a portal that displays two fields "ingredient Name" and "Qty Used". A typical portal looks something like this

Ingredient #1 ----> 50 Units

Ingredient #2 ----> 30 Units

Ingredient #3 ----> To Wet

Ingredient #4 ----> Qs to 100 Units

I am looking for a way to "tag" any ingredient that has "To wet" or "Qs" in the Qty Used Field. The reason i need something like this is because I track each ingredients inventory level. As you can imagine it is pretty hard to track inventory for amounts such as "to wet", so I am looking to tag any ingredients with this designation perform a calculation and then the calculations result will be taken off inventory. Is this sort of idea possible or am i heading out into left field?

You could use a conditional case statement on your quantity calculation that looks to your ingredient amount. Can use pattern count, string comparison, etc to decide how to "count" the quantity deducted from inventory.

Thanks for the advice, i will see what i can come up with!