tagging certain words in a field

[Chemadian]

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?

[Russell Barlow]

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.

[Chemadian]

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