Forum Academy Marketplace Showcase Pricing Features

How to Search for Field Name in a Thing With Condition

Suppose If I have a ORDER Database with Data Fields as Following

  1. Apple1 (Type: Number)
  2. Apple2 (Type: Number)
  3. Apple1000

And BOM Database with Data Fields as Following

  1. Apple Type (Type : Text)
  2. Ingredient Item (Link to Other Table Data)
  3. Quantity Use (Type : Number)

The Apple Type Fields have text data with the same name like data fields in ORDER Thing (Apple1 or Apple12 etc.)

I want to Calculate The Summery of Ingredient Use Quantity And I don’t want to Set 1000 Conditions in my Work Flow because it is really takes time like

Condition 1 : When BOM’s AppleType is “Apple1” → Search for BOM’s (Item = Item) Quantity Use * ORDER’s Apple1
Condition 2 : When BOM’s AppleType is “Apple2” → Search for BOM’s (Item = Item) Quantity Use * ORDER’s Apple2
Condition 3 : When BOM’s AppleType is “Apple3” → Search for BOM’s (Item = Item) Quantity Use * ORDER’s Apple3

Is it Possible to make a Calculation to Dynamically Link the Apple Type that have the same name with ORDER Data Field Just to Calculate The Summery of Ingredient Use Quantity?

There are many use cases in my app that is totally need this type for dynamically field name to link to other thing data. like Auto Bot Chat etc.