InfoPath Dev

Ah, I see the issue. The default on the field includes the field itself - I'm guessing that's causing the issue. So changing the field, changes its own value - which then would cause the field to change again and so on. What about just using a calculated value to display them together? I've done that in this copy. You'll need to ...

I attached the template. Trying to concat the BU field with a colon. I would really love to concat the BU Vision field with the BU so I can just put one field on the form so it would look like this: * [BU]: [BU Vision] Thank you so much for your help!

Is there any chance you can attach a copy of your template under the options tab? Your "concat" formula should be either in the default value for a data field or in a rule on the data field. The field you select in the formula should be a data field - query fields are only for filtering data when we query it. "Refresh value when ...

yesterday it was working but today it's not. Am I supposed to concat on the query fields or the data fields? And what does "refresh value when formula is calculated" do because when I check it that's when I get the error. I'm just trying to display data - not a form for editing.

Ah, perfect! This must be a list form - and yes, data vs. query can get a little confusing. Glad you have it all sorted out. :)

omg I just found out what I was doing wrong. I was using the data fields not the query fields. Using the query fields lets me check "refresh..." and not get the error. So sorry but I was confused about query fields and data fields. Now I get it.

Can you just attach your form? You can do that under the Options tab in a reply... or maybe a screenshot that shows the issue?

Thank you for your reply. I did that but it doesn't work. If I check "Refresh value when formula is recalculated" I get a prompt in Sharepoint that I can just click OK but the concat doesn't show.

Maybe so - this needs to go in the formula editor (so, click on the fx button) and the field needs to be selected with the field picker. See attached screenshot. In this sample, I wanted to set a default value for a field, so in the field's properties, I clicked on the fx button, which opened the formula editor. You can pick the concat ...

I've tried to concat a field to add a colon after the field like this: ": " but it doesn't work. This is what I have: concat(field, ": ") Is there something I'm missing?