Question

Where Is the ROW and INDEX functions Described for 10.1?

Forms Version 10

Updated December 8, 2016

asked on October 27, 2016

In Forms 10.1 I know that there were new functions ROW and INDEX to do calculations in tables, but I do not find anywhere except in the List of changes for Forms 10.1 document that talks about these functions?

I would like to know more specifics on what these functions actually do.

4 0

Answer

SELECTED ANSWER

replied on November 1, 2016

Row() is to get the current row/set in table and collection, Index(variable_inside_table/collection, row/set_numer) is to get the value of the variable for that row/set.

1 0

replied on November 29, 2016

Can the documentation be updated to include this information?

2 0

replied on December 8, 2016

Requested an enhancement for the documentation

3 0

Replies

replied on October 27, 2016

This will put the SUM of the Values N1,N2 and N3 into another field in the same Row of the Table (such as Total Field) where this calculation resides.

=SUM( INDEX(Table.N1,ROW()) , INDEX(Table.N2,ROW()) , INDEX(Table.N3,ROW()) )

It would be nice to understand what additional options are available with INDEX and ROW as one day we were trying to figure out a way to draw a piece of data that appeared in a certain Row\Field in a table

0 0

replied on October 30, 2016

Hi Steve,

As you're probably aware, you can do standard calculations as well as just the sum of the fields (e.g. qty x price - discount):

=SUM(INDEX(Table.Field1,ROW()) * (INDEX(Table.Field2,ROW()) - INDEX(Table.Field3,ROW())))

But something I also found helpful was the use of "ROW" for specifying a specific row, e.g comparing a date field in row 1 in a table (Table.date2) with a date field outside the table (Date1), just using "1" to specify the table row:

=DATEDIF(Date1,INDEX(Table.date2,1),"d")

Cheers,

Mike

1 0

You are not allowed to follow up in this post.

Question

Question

Where Is the ROW and INDEX functions Described for 10.1?

Answer

Replies

Sign in to reply to this post.