General

Re: Appending Text to a Field Value To Yield Final Result

cbrown00 — Fri, 23 Dec 2011 05:57:23 GMT

Update:

Not sure what I was doing wrong before; but re-entered and it is working. I must have entered different key strokes in condition section versus formula section.

Thanks!

Re: Appending Text to a Field Value To Yield Final Result

cbrown00 — Fri, 23 Dec 2011 05:41:24 GMT

Jimmy:

After creating rule per your guidelines, I key in a value in the field, it appends the "sec" many times (e.g., 120 sec sec sec sec...) until I get the following error:

"An error occurred in the form's rules or code. The number of rule actions or the number of calls to the OnAfterChange event for a single update in the data exceeded the maximum limit.

The rules or code may be causing an infinite loop. To prevent this, ensure that the rule action or event handler does not update the data which causes the same rule action or event handler to execute."

I checked the box in the rule to stop processing after the rule is run, but I get the same result. Any guidance on what's going on and how to just get one cycle?

Re: Appending Text to a Field Value To Yield Final Result

Jimmy — Thu, 22 Dec 2011 19:30:28 GMT

You can accomplish this without a separate field if you add a condition to your rule:

Condition: (the field) does not contain sec

Action: Set (the field) to the formula: concat(., ' sec')

Re: Appending Text to a Field Value To Yield Final Result

Anson Hidajat — Thu, 22 Dec 2011 19:12:48 GMT

It depends where you want to use this appended text in the end. If the report you mention is simply a read-only InfoPath view, then you can use a Calculated Value control to display your formula. This control doesn't have to be bound to any field, so you won't have to add an additional temp field in your data source.

Otherwise, your other option is likely setting a field's value of some temp field. Hope I understood your scenario correctly :) If not, feel free to clarify and I'll be more than happy to help out!

Appending Text to a Field Value To Yield Final Result

cbrown00 — Thu, 22 Dec 2011 06:18:10 GMT

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.