Probably a simple question, but i wanted to use a repeating calc field to display a series of navigational buttons. If there are four repetitions, I wanted to have each field act as a button containing text indicating which layout the buttons would send you. When defining the calc field, I used a Case and GetActiveRepetition function with the corresponding text like so:

 

 

Case(

Get ( ActiveRepetitionNumber )  = 1; "Create Jobs";

Get ( ActiveRepetitionNumber )  = 2; "Search Jobs";

Get ( ActiveRepetitionNumber )  = 3; "Search Companies";

Get ( ActiveRepetitionNumber )  = 4; "Search Invoices")

 

My issue is that the text displays but only when I place the cursor in the field. What am I doing wrong? Meaning, how can I get the text to just display on its own without engaging the calc field?

Try

 

Let ( labels = List ( "Create Jobs"; "Search Jobs"; "Search Companies"; "Search Invoices");
        GetValue ( labels; Get ( CalculationRepetitionNumber ) )
      )

Another possibility with the same effect:

Choose ( Get ( CalculationRepetitionNumber ) - 1 ;
    "Create Jobs" ;
    "Search Jobs" ;
    "Search Companies" ;
    "Search Invoices"
)

Much obliged!