Hi, I cant seem to find the answer to this anywhere?
I am trying to make a column that counts the occurance of each exercise per client, but increments up each time it occurs
eg. the 1st occurance shows 1, the second shows 2, the third shows 3 and so on,
the purpose of this is to be able to find test number 1 and compare to test number 2 or 3 etc. rather than trying to find them by specific dates as people test on different dates
ive attacehd the columns im working with and also a manual column of what the output should look like
when people suggest relations and rollups it just says rollups dont work on relation columns? but then i also want the incrementing value based on date?
thankyou!
This is my query column
when i go to lookup through the query i get this?
ah, it’s a Big Table. That makes a difference. Although, I would expect that Lookup to be supported but limited to 100 rows. Are you creating that in the same table? Also, do you have the below preview feature enabled?
ah i see, yes ive checked that now and it is saying 100 rows
does that mean only 100 rows of the formula? or will only pull through 100?
eg for each client the most weve had is like 15 entries of one exercise
or if it means only 100 rows then yes we would exceed that
It should be the first 100 rows that match the query filter criteria.
oh ok so that would be fine, its being used in an exercise logging database that currently has like 3000 rows in it gathered this year, with view to grow it more each year, so maybe 5000-10000 per year being entered. is this enough to warrant use of a big table? or should i use a normal one?
My general rule of thumb is if I expect 10k or more rows per year, then I will use a Big Table.
1 Like
