InfoPath Dev

Can I reuse the form to connect to another sharepoint list and keep the fields in the form? Or do the fields need to be redone. The fields are the same for the other list. Thank you.

Thank you so much again!

I have a number field and if the number is greater than zero the form needs to show an up arrow. If less than zero, a down arrow. What is the best way to do this?

YOU ARE A WIZARD! I didn't know about the calculated value. Thank you SO MUCH!

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!

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.

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.

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.

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?