Determine Row Number using FormCalc

Avatar

Avatar
Level 1
robnagby
Level 1

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
View profile

Avatar
Level 1
robnagby
Level 1

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
View profile
robnagby
Level 1

15-12-2008

I'm setting up a table with many questions. The questions asked will change depending on the answers given. Each row will contain a question. The first column is the question number. I'd like the question number to change based on it's position in the table. I hide the rows for questions that are not being used. If the question is in the 5th row, it should be question 5. Is there a way to determine the row number and then have it change if it moves up or down in the table?

Replies

Avatar

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

612 likes

Total Posts

7,689 posts

Correct reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

612 likes

Total Posts

7,689 posts

Correct reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile
pguerett
Level 10

15-12-2008

You can get a subform instance number by using the parent.index on any object in the subform.

Avatar

Avatar
Level 1
robnagby
Level 1

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
View profile

Avatar
Level 1
robnagby
Level 1

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
View profile
robnagby
Level 1

15-12-2008

The problem with that solution is that if I hide a row because the question is not relevant, the numbers don't adjust. For example:



1 What color is your hair?

2 How old are you?

3 How many fingers do you have?



I hide question 2 because it's no longer relevant and here's what shows up:



1 What color is your hair?

3 How many fingers do you have?



I need it to appear like this:



1 What color is your hair?

2 How many fingers do you have?

Avatar

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

612 likes

Total Posts

7,689 posts

Correct reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

612 likes

Total Posts

7,689 posts

Correct reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile
pguerett
Level 10

16-12-2008

I think I have a sample of something similar. Post your email and I will send it.

Avatar

Avatar
Level 1
robnagby
Level 1

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
View profile

Avatar
Level 1
robnagby
Level 1

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
View profile
robnagby
Level 1

16-12-2008

n_linus at yahoo dot com



Thanks!

Avatar

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

612 likes

Total Posts

7,689 posts

Correct reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

612 likes

Total Posts

7,689 posts

Correct reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile
pguerett
Level 10

16-12-2008

Just sent it