https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/123140.aspxFri, 26 Jun 2020 20:14:26 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123140Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/123140.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=123140I like calculated values for displaying things like this. As long as it isn't a value you need in your list (like - people want to filter the list data by BU: BU Vision but don't want to have to use two filters or something) you can use calculated values for displaying things the way you want. :)https://www.infopathdev.com:443/forums/thread/123139.aspxFri, 26 Jun 2020 20:04:44 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123139Toni2120https://www.infopathdev.com:443/forums/thread/123139.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=123139YOU ARE A WIZARD! I didn't know about the calculated value. Thank you SO MUCH!https://www.infopathdev.com:443/forums/thread/123138.aspxFri, 26 Jun 2020 19:50:25 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123138Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/123138.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=123138Ah, 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 right click the link in the header of this message, and save the attached file to your local machine. Find the saved file, right click and select design - that will open the form back up in design mode. There is a calculated value at the bottom of the form with some notes.https://www.infopathdev.com:443/forums/thread/123137.aspxFri, 26 Jun 2020 19:42:53 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123137Toni2120https://www.infopathdev.com:443/forums/thread/123137.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=123137I 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!https://www.infopathdev.com:443/forums/thread/123136.aspxFri, 26 Jun 2020 19:27:44 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123136Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/123136.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=123136Is 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 formula is recalculated" is an option for default values - basically indicating that if the fields in your default value formula change, the field the formula is on should be updated.https://www.infopathdev.com:443/forums/thread/123135.aspxFri, 26 Jun 2020 19:22:11 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123135Toni2120https://www.infopathdev.com:443/forums/thread/123135.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=123135yesterday 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.https://www.infopathdev.com:443/forums/thread/123134.aspxThu, 25 Jun 2020 19:21:46 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123134Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/123134.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=123134Ah, perfect! This must be a list form - and yes, data vs. query can get a little confusing. Glad you have it all sorted out. :)https://www.infopathdev.com:443/forums/thread/123133.aspxThu, 25 Jun 2020 19:19:41 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123133Toni2120https://www.infopathdev.com:443/forums/thread/123133.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=123133omg 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.https://www.infopathdev.com:443/forums/thread/123132.aspxThu, 25 Jun 2020 19:15:27 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123132Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/123132.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=123132Can you just attach your form? You can do that under the Options tab in a reply... or maybe a screenshot that shows the issue?https://www.infopathdev.com:443/forums/thread/123131.aspxThu, 25 Jun 2020 18:57:35 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123131Toni2120https://www.infopathdev.com:443/forums/thread/123131.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=123131Thank 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.https://www.infopathdev.com:443/forums/thread/123130.aspxThu, 25 Jun 2020 18:36:03 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123130Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/123130.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=123130Maybe 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 function using the insert function button, or just type it in. Select the field using the insert field button - you'll see how it now shows as underlined in the final formula.https://www.infopathdev.com:443/forums/thread/123129.aspxThu, 25 Jun 2020 18:26:49 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123129Toni2120https://www.infopathdev.com:443/forums/thread/123129.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=123129I'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?