I know it is possible to use a rule in a control to set its value by using concatenate function and pulling values from other different controls.
I'm trying to find a solution where I don't have to set up a different data element just to make the concatenation happen. So, my question is can you use a rule to set the value in a data element by taking the value entered, but then auto-append text to it so that whenever the field is used, it returns not just the value, but the appended text, too. I'm wanting to create a field where a time value is entered, say 60, and using a rule to add "sec" to it so that when the data element is referenced later in a report, it will return "60 sec" versus just the "60" shown. I have tried concat function in a rule for the field to make this happen, but it still only returns the value.. cannot get the text to show up in a report referencing the data element.
I don't need the result to indicate 60 sec in the form....just for that to be the real value. Hope this makes sense.