Newbie Questions

Re: Calculated formula

Patrick Halstead — Sun, 18 Aug 2013 22:47:13 GMT

May I humbly suggest a better design?

Use a proper repeating control and stop hacking strings. Then, map the data as individual rows to a SharePoint list. Display this along with your InfoPath metadata, using a dashboard form that pulls from both. You can do this without code. Our YouTube.com/Qdabra weekly webinars have highlighted dashboards for repeating data several times in the last 6-7 months.

Send us email and we'll send you a sample. :)

But, please, stop the bad practice string hackery...

Re: Calculated formula

love2cusmile86 — Fri, 16 Aug 2013 17:40:11 GMT

Thank you for your suggestion and insight.

I have resolved the solution by creating an xml file to creat a new line.

So I used EVAL to get the values of the repeating table field and concat it with a new line xml. It looks great in my infopath form but when the data is submitted into SharePoint, it looks like this

" $203 $303 "

The new line did not get added in. My goal is to get SharePoint to show the currency format $ in front of the number.

Re: Calculated formula

wilkies0106aw — Fri, 16 Aug 2013 14:25:26 GMT

As far as I know you can't do that in SharePoint by default. It's either a row or a column. You'll have to perhaps play around with SP designer to get it looking like you want.

In Infopath you could do the following:

Add a field to your form called CarriageReturn.

The CarriageReturn text box should be hidden and have it's default value set in the function builder to:
      a. Type an open quotation      "
      b. Hold down the Control key and hit the Enter key
      c. Type a close quotation       "

Then use this in your formula.

Calculated formula

love2cusmile86 — Thu, 15 Aug 2013 17:12:56 GMT

Hello,

I have a textfield in InfoPath that concat a field from a repeating table.

The textfield would look like this " 12; 40; 80 ; "

SharePoint Library display:

Number of Deals (column1 )

12; 40; 80; (row 1 )

How can I make it look like this within a row?

Number of Deals

I used this formula

=LEFT([Deals],INT(FIND(";",[Deals])-1)) but it returned the first number. How can I get all the numbers and display them vertically?

Thank you.