Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

Determine Row Number using FormCalc

robnagby
Level 1
Level 1
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?
5 Replies
pguerett
Level 10
Level 10
You can get a subform instance number by using the parent.index on any object in the subform.
robnagby
Level 1
Level 1
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?
pguerett
Level 10
Level 10
I think I have a sample of something similar. Post your email and I will send it.