Can’t Understand. Repeatable Group Lookup value in other row?

I am making a game tool. I have an arbitrary number of area shields. My goal is to add up the damage of an arbitrary number of area shields. The damage lookup table is named areadata. The lvl of area shield chosen in drop down can be used to lookup the damage in the areadata table.

I have not quite figured out the easiest way to make the multiplication then arrive at a total sum. Thank you.

I clicked on the link to the app but don’t have permission to view.

In any case, you can do the calcs in an expression or directly into a text field.

i made it viewable. Please see question above. Thank you

If the calc is based on something in your data type, then you can use an expression to do a search for the records that meet your criteria and then reflect the result in a text field. In that case, you won’t need a calc button.

Can you show me please? Thank you

This topic was automatically closed after 70 days. New replies are no longer allowed.