Put value in repetition

[peptoulcer]

I am trying to use virtual method but regardless it is repetition calculations which hangs me up. I have a monthly chart of repetitions field so it can show the lines down the body in list view. I have array $$array with numbers (first value is ID1 etc) and I understand how to use calculation with GetValue($$array;ID) but it won’t work for this need. file attached with sample.

The numbers in the array mean that I want to put an ‘A’ in the repetition of that number. It is only a visual indicator. And yes, this is simple example and there is a lot more to the report but truly this is enough for you all to understand what I need I think. Is it possible to do this? I think I need a calc but if I use a calc, do I need the regular repetition global at all? Confusing.

I went three years using fm and didn’t hit a single snag. Now I try cooler things and get stuck on every turn. I guess I have finally moved outside my understandings to more intermediate needs but this feels like an advanced need (to me). :o

testthis.zip

[comment]

Not sure what's the purpose here. Perhaps this might help?

testthisS.zip

[peptoulcer]

Wow. year and month calcs are better. I tried this I thought but it wouldn't refresh so I read somewhere to use triggers. Thank you for fixing.

It took a minute to figure how you got that dot. Nifty! I never would have used the number boolean in this way.

You are very close but the first number value goes to the first ID, the second value goes to the second and so forth so only one repetition should fill in per record. I am using an external program for a gantt container under and these lines overlay it. The A would represent the month that record was Accepted so 13 would be January of second year.

I suppose I could use the repetition global to produce the lines and then overlay with a calc with the letter but the spacing would not match perfectly like another repetition would to the year and month reps. ps I like your bullet better but owner wanted A. I will see if I can switch her over. But can use get value for the record and then only fill the one repetition? twisted sister it is.

[peptoulcer]

If it helps see my need, I thought this would work but it doesn't

Let(value = GetValue($$array;ID);

not IsEmpty ( FilterValues ( Get ( CalculationRepetitionNumber ) ; value ) ))

[comment]

You are very close but the first number value goes to the first ID, the second value goes to the second and so forth so only one repetition should fill in per record.

Oh, I see. Well, that should be an easy fix - just change the calculation to =

not IsEmpty ( FilterValues ( Get ( CalculationRepetitionNumber ) ; GetValue (  $$array ; Extend ( ID ) ) ) )

You could also use Get (RecordNumber) instead of the ID. Another option would be using a form view showing a repeating field of 60*25 repetitions - I believe it would be easier to control the positioning that way.

[peptoulcer]

That calc was perfect Comment. 60x25 well this is list using virtual table and number of records will vary from a handful to several hundred. Nonetheless I will keep that in mind for future.

I have now finished this project piece. This was last piece when my first post was Date to Chart box. Most everything I have learned from you, like on that post, I found something (many things) on the subject which helped me through. I know you are very busy so I am blown away that you help us. I will learn as fast as I can so not to waste your time. :thumbsup: