Question

Grabbing value from certain rows in a table

Forms Version 11

Updated an hour ago

asked on August 15

I've got the following table and the text field "Extra Airfare Expense type:

I'd like Extra Airfare Expense Type to populate with the word "Reimbursable" if ANY of the rows has an Expense Type value of "Reimbursable". The code I currently have in the Advanced section of the Extra Airfare Expense Type is:

=IF(tabExtraAirfare.drpExAirfareExpense="Reimbursable","Reimbursable","FALSE")

Obviously, it's only looking at the very first row of the table and seeing the value "City-Paid". I'd like to avoid using JS because I'm no very familiar with it yet. Is there any code I can use in the Advance section that will look at all the rows to see if there is a "Reimbursable" value?

0 0

Replies

replied on August 15

You extract the value with Index(tabExtraAirfare.drpExAirfareExpense,ROW())

I have a form in production that a Total Cost column is a Product of 2 columns Charge Hrs and Cost per hour

=PRODUCT(INDEX(Tasks.Charge_Hrs,ROW()),INDEX(Tasks.Cost_Ph,ROW()))

1 0

replied 16 hours ago

This should work for you since that field is outside the table:

=IF(
  COUNTIF(tabExtraAirfare.drpExAirfareExpense, "=Reimbursable") > 0,
  "Reimbursable",
  "FALSE"
)

0 0

replied an hour ago

Thanks guys! I ended up figuring it out. I appreciate the input though!

0 0

You are not allowed to follow up in this post.

Question

Question

Grabbing value from certain rows in a table

Replies

Sign in to reply to this post.